-
Oracle8.1.6
SCO UX 7.1.1
IGB Memmory
2 Processors
I have noticed PMON is consuming 50% CPU time, even when only a few users are connected.
There are no trace files produced.
Usually around 130 users logged on.
Can anyone give me any queries/tuning tips to help establish what it is doing and why it is consuming so much CPU
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
There is no money back guarentee on this one, but i think it can hep
The following procedure provides a process dump for the Oracle database
and shows all statistics for the PMON background process. Follow these
steps:
1. Start by issuing the ORADEBUG SETORAPID command to process 2. Process
number 2 is the Oracle Process Monitor (PMON).
SVRMGR> oradebug setorapid 2
Unix process pid: 25159, image: ora_pmon_test
2. Issue the PROCSTAT command to generate the statistics.
SVRMGR> oradebug procstat
Statement processed.
3. Use the TRACEFILE_NAME command to find the location of the trace
file.
SVRMGR> oradebug TRACEFILE_NAME
/app/oracle/admin/orcl/bdump/pmon_25159.trc
Here's the listing from this procedure. As you can see, this provides
detailed information regarding important PMON activities.
SQL> !cat /u01/app/oracle/admin/prodc1/bdump/prodc1_pmon_25159.trc
Dump file /u01/app/oracle/admin/prodc1/bdump/prodc1_pmon_25159.trc
Oracle8i Enterprise Edition Release 8.1.6.1.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.1.0 - 64bit Production
ORACLE_HOME = /u01/app/oracle/product/8.1.6_64
System name: SunOS
Node name: burleson-01
Release: 5.8
Version: Generic_108528-03
Machine: sun4u
Instance name: prodc1
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 25159, image: oracle@burleson-01 (PMON)
*** 2001-07-04 12:13:25.042
*** SESSION ID:(1.1) 2001-07-04 12:13:24.979
----- Dump of Process Statistics -----
User level CPU time = 121
System call CPU time = 47
Other system trap CPU time = 0
Text page fault sleep time = 0
Data page fault sleep time = 0
Kernel page fault sleep time = 0
User lock wait sleep time = 0
All other sleep time = 562367527
Wait-cpu (latency) time = 0
Minor page faults = 0
Major page faults = 346
Swaps = 0
Input blocks = 251
Output blocks = 0
Messages sent = 0
Messages received = 0
Signals received = 1827660
Voluntary context switches = 1828280
Involuntary context switches = 58531459
System calls = 141934171
Chars read and written = 28650
Process heap size = 1425416
Process stack size = 565248
Regrads
Alexandre
In god i trust
-
Can I use oradebug to check the listener cpu usage? if yes, how.
thanks
-
Thanks for your help alexandre.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Hi Alexnadre..
I take it that this has no overhead..
Does the oradebug command simply take a dump (snapshot) or does it continue adding info to trace file ?
Is there a need to stop it ?
Thanks
Suresh
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|