- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How many memory a oracle9.2 server process all...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2003 10:06 PM
тАО02-26-2003 10:06 PM
But when I install oracle9.2, I found each process occupy about 67m memory.
Is it OK?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2003 10:25 PM
тАО02-26-2003 10:25 PM
Re: How many memory a oracle9.2 server process allocate ?
Oracle 9i needs more memory than 8i both in terms of file size and SGA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2003 10:33 PM
тАО02-26-2003 10:33 PM
Re: How many memory a oracle9.2 server process allocate ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2003 10:42 PM
тАО02-26-2003 10:42 PM
Re: How many memory a oracle9.2 server process allocate ?
The size of the server proceses depends on many init parameters such as SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, and CREATE_BITMAP_AREA_SIZE, etc ...
It's known as PGA (Process Global Area).
Oracle9i provides an option to completely automate the management of PGA memory available to an instance using a newly introduced initialization parameter PGA_AGGREGATE_TARGET. The database server automatically distributes this memory among various active queries in an intelligent manner so as to ensure maximum performance benefits and the most efficient utilization of memory.
More about sizing of PGA in METALINK Note:223730.1
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-26-2003 10:53 PM
тАО02-26-2003 10:53 PM
Re: How many memory a oracle9.2 server process allocate ?
The size of the server proceses depends on many init parameters such as SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, and CREATE_BITMAP_AREA_SIZE, etc ...
It's known as PGA (Process Global Area).
Oracle9i provides an option to completely automate the management of PGA memory available to an instance using a newly introduced initialization parameter PGA_AGGREGATE_TARGET. The database server automatically distributes this memory among various active queries in an intelligent manner so as to ensure maximum performance benefits and the most efficient utilization of memory.
More about sizing of PGA in METALINK Note:223730.1
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2003 02:17 PM
тАО03-18-2003 02:17 PM
Re: How many memory a oracle9.2 server process allocate ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2003 08:50 PM
тАО03-18-2003 08:50 PM
Solutionthis is from metalink:
There are no thumb rules or exact observations as to increase in CPU or memory usage in 9i vis-a-vis 8i. However one can always have a comparison after migrating from 8i to 9i , keeping in mind the associated changes in the environment that may have happened (e.g. init.ora parameters).
However I would also like to comment that in 9i , as far as, memory usage is concerned we have now have better control than in 8i.
Prior to 9i the memory required for running an instance was roughly calculated as SGA size + (number> of users * ?Meg).
If you use the Automatic SQL Execution Memory Management (In short, Auto PGA:) ) feature of Oracle9i, you should not have to perform any calculation based on the number of users. In many sense, the number of users hardly affects memory utilization, it is actually your workload. You should start with a reasonable sized SGA and PGA (using the PGA_AGGREGATE_TARGET parameters) and adjust the configuration according to the database feedback.
There are many ways to collect this feedback. The buffer cache advisory is one of them. A high numbers of RELOADS as indicated by the v$librarycache view should help you in sizing the shared pool. The V$PGASTAT view can be used to adjust the size the PGA. The next 9i release may make the memory tuning of an Oracle instance even easier by including advisories for the shared pool and PGA ,besides the buffer cache.
For more details on memory tuning, please take a look at our performance tuning guide at:
http://st-doc.us.oracle.com/9.0/901/server.901/a87503/memory.htm.
As for CPU load , I do not see any significant change , unless your explain plans for sqls changes, become poorer in respect to IO, or you are using more parallelization etc.
hth
Yogeeraj