-
My 817 DB is very busy generating archived log every 1/2 hour for 1 week or so or so while there is not seem to be any users or people doing anything. However we have process scheduler that I am suspicious of. v$sqlarea don't show any heavy sql's neither. I bonced the db once but didn't seem to help. The problem is that there is no Unix process show up so I can kill as this runaway job(s) is probably initiated via background. Can I look at any tables or views to help identify what is going on?
-
You might want to check there is nothing running via DBMS_JOB. As the dba user, try
SELECT * FROM DBA_JOBS;
Cheers,
-
I did checked dba_jobs but there was nothing.
The other reason might be some sql's might be runaway and been running for days. Is there a quick way to check on a sql and its duration, how long it has been running currently or in the past?
-
if you have the session_id of the sql, then check the logon_time from v$session