SQL Monitoring(Oracle 9i)
Hi All,
I have results from v$sql like this (Oracle 9i)
SELECT SUBSTR(SQL_TEXT,1,20),ELAPSED_TIME/1000000 "Elapsed_Secs",EXECUTIONS FROM V$SQL
WHERE ADDRESS IN (SELECT SQL_ADDRESS FROM V$SESSION WHERE STATUS='ACTIVE' AND USERNAME='CRIS_APPS')
ORDER BY 2 DESC
SUBSTR(SQL_TEXT,1,20) Elapsed_Secs EXECUTIONS
UPDATE RECON_RCM SET 3631.728372 34941
UPDATE RECON_RCM SET 1.802795 4992
UPDATE RECON_RCM SET 0 0
UPDATE RECON_RCM SET 0 0
UPDATE RECON_RCM SET 0 0
Could some body help to understand this output. That statement has executed in 3631.728372/ 34941 = 0.1 seconds for single run..
SELECT SUBSTR(SQL_TEXT,1,20),ELAPSED_TIME/1000000 "Elapsed_Secs",EXECUTIONS FROM V$SQL
WHERE ADDRESS IN (SELECT SQL_ADDRESS FROM V$SESSION WHERE STATUS='ACTIVE' AND USERNAME='CRIS_APPS')
ORDER BY 2 DESC
SUBSTR(SQL_TEXT,1,20) Elapsed_Secs EXECUTIONS
UPDATE RECON_RCM SET 3631.728372 34941
UPDATE RECON_RCM SET 1.802795 4992
UPDATE RECON_RCM SET 0 0
UPDATE RECON_RCM SET 0 0
UPDATE RECON_RCM SET 0 0
Could some body help to understand this output. That statement has executed in 3631.728372/ 34941 = 0.1 seconds for single run..
0