Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
|
|
||
Product |
Prinergy Connect 2.1 ; Prinergy Direct 2.1 ; Prinergy Access 2.1 ; Prinergy Powerpack 2.1 | |
Platform |
Intel |
|
Operating system |
Windows 2000 |
|
|
|
||
Error |
||
|
|
||
Symptoms |
You suspect that Oracle is running slow and you want to find out which threads in Oracle are taking up the CPU time. |
|
|
|
||
Cause |
||
|
|
||
Solution |
Run the script OraclePerf.cmd. This script will display all the Oracle threads, CPU usage and the SQL query the thread is running. Thread - Oracle thread name bgProcess - Oracle background process Thread Id - thread id of Oracle thread % Processor time - percentage of CPU time used by the Oracle thread Process -Process name Sql text - SQL being executed by the Oracle thread C:\Stan\Scripts>oracleperf Thread bgProcess Thread id % Processor time Process Sql text ------------------ --------- --------- ------------------ ---------------------- ------------------------------ ORACLE/0 1108 0.0 ORACLE/1 1156 0.0 ORACLE/10 ARC0 1712 0.0 ORACLE/11 2372 0.0 ORACLE/2 PMON 1320 0.0 ORACLE/3 DBW0 1688 0.0 ORACLE/4 LGWR 1384 0.0 ORACLE/5 CKPT 1692 0.0 ORACLE/6 1700 0.0 ORACLE/7 SMON 1704 0.0 ORACLE.EXE select f.file#, f.block#, f.ts#, f.length from ORACLE/8 RECO 1708 0.0 ORACLE.EXE select local_tran_id, global_tran_fmt, global_ ORACLE/9 SNP0 308 0.0 None BEGIN sys.dbms_ijob.remove(:job); END; Permanent fix: |
|
|
|
||
See also |
||
|
|
||
Keywords |
oracle |
|
|
|
||
Technical contact(s) |
Stan Yoshida |
|
Submitted by |
Stan Yoshida |
|
Date submitted |
17 Sep 2004 |
|