- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- abnormal use of CPU by oracle 9.0.1 with MTS
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-12-2004 09:56 PM
тАО02-12-2004 09:56 PM
abnormal use of CPU by oracle 9.0.1 with MTS
I have oracle 9.0.1-4 in raw device mode and MTS. 3,5 GB SGA ( 1,2 GB shared area). The system cpu mode is very high ( 80 % ), and its consumption is in the system call mmap and nunmap. some idea to correct this?
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-12-2004 11:29 PM
тАО02-12-2004 11:29 PM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
guess is that you are out of memory and it swaps a lot
post
swapinfo -tm
Check for dbc_max_pct in kernel
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-12-2004 11:49 PM
тАО02-12-2004 11:49 PM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
don├В┬┤t have swap problems
dbc_mac_pct = 2 % because don'nt work with
file systems. works with raw volumes with async mode access and Virtual Array.
Sys Mem : 500.3mb
User Mem: 5.97gb
Phys Mem: 10.0gb
Active VM: 398.7mb
Buf Cache: 204.8mb
Free Mem: 3.34gb
users = 200 to 9
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2004 09:32 AM
тАО02-13-2004 09:32 AM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
2. What is the process name that is taking up the CPU? (If it is 'oracleSID ...' then it is an Oracle client connection)
3. Have you considered upgrading to 9.2.0? 9.0.1 was the initial 9i version, and had a number of bugs against it. This could be a bug that has already been resolved.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2004 09:35 AM
тАО02-13-2004 09:35 AM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
Do a 'swapinfo -tam' and see what you get.
My next thought is your 'timeslice' kernel parameter. If you happened to apply one of the "tuned parameter sets" then they set timeslice to 1, which it should never be. If it is set to 1, change it back to 10 as soon as you can.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2004 02:34 AM
тАО02-14-2004 02:34 AM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
I don't think there can be an application constraint/incompatibility to stop you from doing that. But of cours you'll need to set aside the time to do it.
2) Are you sure you still have a need for MTS or is that perhpas a carry over from an old installation? The primary objective of using MTS tends to be to reduce memory usage. You seem to have enough of that ?!
3) The real question.. that high CPU usage... have you 'chattered' the Oracle image ? check 'chatr $ORACLE_HOME/bin/oracle'. You probably want pi=16M and pd=L
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2004 05:54 AM
тАО02-14-2004 05:54 AM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
I changed mts because my sga is great ( 1,2 GB Shared area), and a high number of connections needed to reserve to much swap,
(around 29 GB for 500 conections/users ).
The change to mts has reduced radically to this problem, reducing drastically the use of memory and disc.
But the CPU use way system has increased enormously. To change to the 9,2 to change, is not very scientist.
It interests to me to resist your opinions.
Thanks
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2004 08:55 AM
тАО02-14-2004 08:55 AM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
60MB / user of private space?
Using a lot of 'retained sort area' ?
PGA target way high?
That memory usage may well be warranted but is not typical and begs for a solid explanation... or mabye a fix!
Checked those pagesize attributes with chatr?
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-17-2004 02:29 PM
тАО02-17-2004 02:29 PM
Re: abnormal use of CPU by oracle 9.0.1 with MTS
Hein brought up a good point. Have you considered setting pga_aggregate_target instead of using the specific parameters. This could help with the memory impact from the connections. Again, 9.2.0 has a number of new features (V$PGA_TARGET_ADVICE) which can help tune this parameter (which can be changed dynamiclly).
Also, I'm not sure what you meant to say about not upgrading to 9.2.0. Oracle 9.0 was the first release set for 9i, which means that a number of changes have been made between them. It should also be noted that 9.0 has been desupported from ECS.
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=201685.1
Thanks,
Brian