Home » RDBMS Server » Server Administration » 32 bit application on 64 bit oracle
32 bit application on 64 bit oracle [message #266071] Sun, 09 September 2007 09:00 Go to next message
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 #266074 is a reply to message #266071] Sun, 09 September 2007 09:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
What is 64bit application ???

32/64 bit is Database
or
32/64 bit is Operating System
but what is
64 bit application ???


Regards
Taj
Re: 32 bit application on 64 bit oracle [message #266077 is a reply to message #266071] Sun, 09 September 2007 09:22 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I mean 10g AS, does it work for 64 bit database?
Re: 32 bit application on 64 bit oracle [message #266088 is a reply to message #266077] Sun, 09 September 2007 11:39 Go to previous messageGo to next message
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 #266090 is a reply to message #266071] Sun, 09 September 2007 12:10 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
thanks mson77
Re: 32 bit application on 64 bit oracle [message #266785 is a reply to message #266071] Tue, 11 September 2007 11:39 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #266870 is a reply to message #266071] Tue, 11 September 2007 21:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Questioner you did not follow Mohammad Taj advice. Memory allocation limit is dependent on OS.
Re: 32 bit application on 64 bit oracle [message #267052 is a reply to message #266071] Wed, 12 September 2007 06:32 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: LRU List
Next Topic: os level (veritas) fail over for db
Goto Forum:
  


Current Time: Fri Dec 09 17:43:25 CST 2016

Total time taken to generate the page: 0.51219 seconds