 |
Hot Jobs
ORA- Search (Press GO)
|
example:
orcl-experts.info$./topdb.sh
TOP ORACLE PROCESSES:
---------------------
******************************************************************************
Processing 16129 ...
******************************************************************************
COMMAND:
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
0 S oracle 16129 4554 0 76 0 - 688 - Feb26 pts/2 00:02:36 top
This is NOT an Oracle database USER process
******************************************************************************
Processing 9742 ...
******************************************************************************
COMMAND:
F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME CMD
0 S oracle 9742 1 0 77 0 - 172538 404394 03:40 ? 00:00:00 oracleEXPERTS1
(LOCAL=NO)
=====================================================================
SID/Serial : 122,59660
Foreground : PID: 1234 -
Shadow : PID: 9742 - oracleEXPERTS1@experts.info.prod
Terminal : / UNKNOWN
OS User : on experts.info.prod
Ora User : SYSMAN
Status Flags: INACTIVE DEDICATED USER
Tran Active : NONE
Login Time : Wed 03:40:36
Last Call : Wed 03:40:35 - 13.9 min
Lock/ Latch : NONE/ NONE
Latch Spin : NONE
Current SQL statement:
Previous SQL statement:
SELECT t.target_guid FROM mgmt_targets t, mgmt_target_propertie
s p WHERE t.target_type = 'oracle_database' and t.target_guid =
p.target_guid and p.property_name = 'MCSpInst' and p.property_v
alue = '1' and not exists (select 1 from mgmt_sql_evaluation e
where e.target_guid = t.target_guid)
Session Waits:
WAITING: SQL*Net message from client
Locks:
=====================================================================
|
|