Home » RDBMS Server » Server Administration » how to see when the database was last used
how to see when the database was last used [message #53053] Mon, 26 August 2002 17:31 Go to next message
Helena
Messages: 42
Registered: February 2002
Member
Hi there
Can someone please tell me how to see when the oracle database was last used, I have Oracle version's of 7340, 8150, 8160, 8170 and 9010, any help would be great
Thanks
Helena

Report message to a moderator

Re: how to see when the database was last used [message #53060 is a reply to message #53053] Tue, 27 August 2002 02:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
look at the logs! everytime the database is mounted / unmounted there will be an entry there.
also if you look at logswitche it will indicate the last active period( it may not be accurate)

Report message to a moderator

Re: how to see when the database was last used [message #53062 is a reply to message #53053] Tue, 27 August 2002 05:14 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Helena,

One way to do it is to see the LISTENER.LOG file. See at the bottom and the last entry is the last connection to the database. There is a time stamp.

Anyhow, this is for connections coming from outside the server. If someone is doing working local, then it may be difficult to trace, unless there is another way to do it.

Good luck.

Report message to a moderator

Previous Topic: users quota
Next Topic: Re: Quick Question on RMAN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 12:47:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.