- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle memory Managment
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
тАО12-05-2003 01:24 AM
тАО12-05-2003 01:24 AM
Oracle memory Managment
I would like to ask except the SGA is oracle reserves other memory for sessions or any other reason?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2003 01:37 AM
тАО12-05-2003 01:37 AM
Re: Oracle memory Managment
I suppose you have access to Metalink.
You can starts with the following documents :
[NOTE:148346.1] Monitoring Automated SQL Execution Memory Management
[NOTE:223730.1] Automatic PGA Memory Management in 9i
Note:147806.1 -- Oracle9i New Features: Automated SQL Execution Memory Management
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2003 01:46 AM
тАО12-05-2003 01:46 AM
Re: Oracle memory Managment
See
http://www.oracle-training.cc/teas_elite_troub_3.htm
Then add on the memory each process needs just to exist at system level
The SGA is just a big parcel service sending parcels of data between back and front line processes
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2003 07:09 PM
тАО12-07-2003 07:09 PM
Re: Oracle memory Managment
Oracle creates a PGA area in memory for each dedicated connection to the database.
If you set up the database with Multi Threaded Server option, some of the PGA data is moved inside the SGA and thus reduce your memory needs for multiple connections.
rgds
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2003 09:19 AM
тАО12-08-2003 09:19 AM
Re: Oracle memory Managment
The primary cost for each sessions connection to the database is the 'sort_area_size' and 'sort_area_reserved_size'. There is some other cost associated with the PGA, but it shouldn't be very high. These will be the major portion.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2003 06:16 PM
тАО12-08-2003 06:16 PM
Re: Oracle memory Managment
I have about 150 of such process.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2003 07:06 PM
тАО12-08-2003 07:06 PM
Re: Oracle memory Managment
I wouldn't worry about the setting from the 'ps' command, as this will show memory that is being taken up from the shared memory of the database as well. So the amount of from Oracle processes shown can well exceed the amount of memory taken or available on the system. I would suggest using 'glance' to check for memory management, and tune from there.
If you are worried, please put your init.ora out, along with the amount of memory on your system, whether this is only a DB server, or if you application runs on it, and how many databases exist on the system.
Otherwise, I wouldn't worry. You most likely are ok.
Thanks,
Brian