Database Administration (MOSC)

MOSC Banner

how to identify when the database is last accessed/modified

edited Oct 10, 2013 5:27AM in Database Administration (MOSC) 8 commentsAnswered
Hi

  How to identify whether the database is last accessed or modified so based that the database can be de-comissioned to reclaim storage.

  At present we have identified the below queries for 10g & 11g but not able to find for 9i versions.

 Last_user_execution -> select max(sample_time) from DBA_HIST_ACTIVE_SESS_HISTORY where session_type='FOREGROUND';

Last_user_modification -> select max (TIMESTAMP) from ALL_TAB_MODIFICATIONS where table_owner NOT IN ('SYS', 'SYSTEM', 'SYSMAN', 'OUTLN', 'DBSNMP') ;

   Is this the right approach to capture the information.  Auditing at the database level is not enabled and client doesn't want any logon/logoff triggers to implemented for the requirement.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center