Hi All,
Is there a way of mapping the PID on the OS to the SID on the database as below :
Traditionally we need to go and do this check outselves but I am looking for way to execute a script, that gives me output as below.. Note : The output should list databases from multiple databases if there are more than one database running.
The output below is from a tool one of our monitoring tool but I am wondering if we can achive the same with either PL/SQL or Shell or perl script for that matter.
PROCESS PID USER CPU-USAGE MEM-USAGE TOTAL-MEM(KB) THREADS STATE UP-TIME ARGS
oracle 11123 oracle 2.75 % 0.06 % 0 1 Runnable 00 Days 01:44:59 oraclePROD123 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13083 oracle 2.63 % 0.30 % 0 1 Runnable 00 Days 00:07:05 ora_j002_PROD123
oracle 18472 oracle 2.18 % 0.12 % 0 1 Runnable 00 Days 00:03:32 ora_j000_PROD123
oracle 22673 oracle 2.15 % 0.02 % 0 1 Runnable 00 Days 00:00:28 oraclePROD123 (LOCAL=NO)
oracle 21680 oracle 1.92 % 0.02 % 0 1 Sleeping 00 Days 00:00:53 oraclePROD123 (LOCAL=NO)
Thanks in advance