- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle and swap space
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
тАО08-31-2009 05:56 AM
тАО08-31-2009 05:56 AM
Re: Oracle and swap space
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 06:58 AM
тАО08-31-2009 06:58 AM
Re: Oracle and swap space
I'm thinking you are on to something with the remnant shared memory segments, we had a maintenance window yesterday morning and bounced the dabatase server. Looking a lot different this morning. Looks like a lot of user processes' just get left hanging on the database server. Sunday morning with no users on the applications it still showed 1600 plus active oracle connections.
@Hein,
I'll talk to the DBA about oracle parms.
I've been staring at this so long I'm going blind. Attaching the ipcs -a output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 07:05 AM
тАО08-31-2009 07:05 AM
Re: Oracle and swap space
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 07:21 AM
тАО08-31-2009 07:21 AM
Re: Oracle and swap space
How much RAM do you have on this particular server and how much SWAP?
It may bery well be your RAM is not sufficient for the Oracle load and SGA your running.
IF you have glance, you can check VM starvation. You can also do vmstat paying particular attention to "sr".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 08:59 AM
тАО08-31-2009 08:59 AM
Re: Oracle and swap space
Right now the there's 120 GIG of paging space defined with 35 GIG used at the time of this writing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 09:04 AM
тАО08-31-2009 09:04 AM
Re: Oracle and swap space
Also I wonder what those 2 or 3 other large chunkks of Shared Memory are though.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 09:05 AM
тАО08-31-2009 09:05 AM
Re: Oracle and swap space
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2009 09:09 AM
тАО08-31-2009 09:09 AM
Re: Oracle and swap space
123 GIG swap
OLTP instance is set with 6 GIG SGA
and a 2 GIG PGA
QL> show sga
Total System Global Area 6442450944 bytes
Fixed Size 2164096 bytes
Variable Size 4777212544 bytes
Database Buffers 1660944384 bytes
Redo Buffers 2129920 byte
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2009 06:27 AM
тАО09-01-2009 06:27 AM
Re: Oracle and swap space
discussion with one of the developers this morning.
If and when a user session disconnects improperly from the application server, i.e., an RF terminal looses power or a terminal session on PC gets "x'd out" rather than closed with the application exit menu option the session server does not clean up so the connection(s) will persist for the lifetime on the application server process.
We've yet to prove this but it makes sense in that we slowly but surely accumulate database connections over and above what we believe should be there. We should be able to graph this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2009 06:34 AM
тАО09-01-2009 06:34 AM
Re: Oracle and swap space
> If and when a user session disconnects improperly from the application server, i.e., an RF terminal looses power or a terminal session on PC gets "x'd out" rather than closed with the application exit menu option the session server does not clean up so the connection(s) will persist for the lifetime on the application server process.
Yes, that is a very BAD THING. Not only connections, but temporary files and shared memory segments could be left lying around!
Regards!
...JRF...