Home » Infrastructure » Other Operating Systems » Oracle on S/390 tuning : CPU problem
Oracle on S/390 tuning : CPU problem [message #113637] Thu, 08 March 2001 03:02 Go to next message
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 Go to previous message
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
Previous Topic: Looking for info on Oracle on OS/390
Next Topic: Forms 3.0 and 2.3 running in OSDI
Goto Forum:
  


Current Time: Thu Mar 28 17:23:23 CDT 2024