Database Administration (MOSC)

MOSC Banner

query that can tell a database is in use when session auditing is not enabled

edited Aug 14, 2013 7:34AM in Database Administration (MOSC) 4 commentsAnswered

Hi All,

I have a situation whereby we need to check if a particular db has been used or not. We need to know if this db in this case there are many databases which we need to check if these have been used or not.

Can you provide me all steps or sql statements or suggestions in which i can use to know if this db is in usgae or not when the auditing is not on.

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