| Oracle on S/390 tuning : CPU problem [message #113637] |
Thu, 08 March 2001 03:02  |
Chris Jacobs
Messages: 1
Registered: March 2001
|
Junior Member |
|
|
The production oracle instance is consuming all CPU !
How can this be tuned on OS/390.
In the database we see that started worker tasks (heavy I/O consuming SQL) are using all the CPU and inactive worker tasks are not activated, dispatched.
This results in bad performance of the oracle applications environment. HELP
|
|
|
|
| Re: Oracle on S/390 tuning : CPU problem [message #113639 is a reply to message #113637] |
Thu, 08 March 2001 13:21  |
John Jones
Messages: 6
Registered: March 2001
|
Junior Member |
|
|
If this is an application problem, join V$SESSION and V$SESSTAT on SID where STATISTIC# = 12. Look at the VALUE, LAST_CALL_ET, OSUSER, USER_NAME, etc. for all active STATUS.
: The production oracle instance is consuming all CPU !
: How can this be tuned on OS/390.
: In the database we see that started worker tasks (heavy I/O consuming SQL) are using all the CPU and inactive worker tasks are not activated, dispatched.
: This results in bad performance of the oracle applications environment. HELP
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
