| 32 bit application on 64 bit oracle [message #266071] |
Sun, 09 September 2007 09:00  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
|
64 bit application can address much more memory, then 32 bit oracle.The limit I, found is 1.7 gb of sga for 32 bit oracle. If I, use 32 bit application for a 64 bit oracle database, then can it address the same amount of memory as 64 bit database on 64 bit application.
|
|
|
|
|
|
|
|
| Re: 32 bit application on 64 bit oracle [message #266088 is a reply to message #266077] |
Sun, 09 September 2007 11:39  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello vijaychauhan,
Basically Oracle Application Server provides an environment for web applications. I mean... applications that runs via web, via browser... accessible thru tcp/ip network (private or public).
This way of develop new applications make the new applications independent of OS... only browser type.
As any applications which deals with data... oracle AS can be backed thru 64-bit database or traditional 32-bit database.
OEM is an example of subject. You access your database (32 or 64-bit) thru web application. Sometimes the web application (OEM) needs to access the server OS as a user... then you register on OEM a user with OS user rights... besides DB user.
In the future... I guess you will need only a browser to do anything... (back to the time of IBM green character terminal... but in browser, colored and graphical version)
Regards,
mson77
|
|
|
|
|
|
| Re: 32 bit application on 64 bit oracle [message #266785 is a reply to message #266071] |
Tue, 11 September 2007 11:39 |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
Hello mson77,
I had one final doubt, the client will be on web browser, but on middle tier there will be 10gas where the execution of form will take place, now this will 32 bit or 64 bit and it will be connected to 64 bit 10g database, so will this combination work.
|
|
|
|
| Re: 32 bit application on 64 bit oracle [message #266796 is a reply to message #266785] |
Tue, 11 September 2007 12:03 |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello vijaychauhan,
Yes.
You are right.
At one end there will be clients... one,two,... many!
In the middle or opposite side... to serve all these clients there will be application server-AS (Ora 10gAS)... and this/these AS will be backed by database (one,two or many).
This scalability is what Oracle calls "grid".
Depending on the volume fo demand... you may have many AS in load balance fashion... and databases in either fashion.
One single example is: one AS and one database.
Have in mind that this is quite the same fashion as "www" today. I say quite the same because "www" starts from "static web server" until... full/any/whatever server.
Regards,
mson77
|
|
|
|
|
|
| Re: 32 bit application on 64 bit oracle [message #267052 is a reply to message #266071] |
Wed, 12 September 2007 06:32 |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
Thanks
I got that point of one to one or one to many, also that the memory addressing capacity is defined by OS, but if the os is 64 bit then it can address more memory, now if the os is 64 bit and oracle is 32 bit , then the SGA is also limited, am I, correct on this?
|
|
|
|
| Re: 32 bit application on 64 bit oracle [message #267065 is a reply to message #267052] |
Wed, 12 September 2007 06:55 |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello vijaychauhan,
I will write up here by goggling. It is not my experience.
Each 32bit Oracle has its own max_sga_value depending on each OS.
You say for instance:
I have 10GB of memory and I am able to use only 2GB?
Answer: You can use up to 2GB for each 32bit oracle instance on this server. Also regarding that you have to leave some amount of memory for OS uses.
Regards,
mson77
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
