Home » RDBMS Server » Server Administration » please any one help on to find out active schemas in 9i oracle database (ORACLE, 9.2.0.5.0, sunsolaris)
please any one help on to find out active schemas in 9i oracle database [message #485779] Thu, 09 December 2010 20:11 Go to next message
lokeshracdba
Messages: 6
Registered: November 2010
Junior Member
Please help me findout and to fill up the excel which lists down the Database schemas and states whether they have in active / or not.

Active state may be determined whether it has been used for the last 3 months or so. The last updated time may be a good indicator of the same.
if have script to findout this please share with me

Report message to a moderator

Re: please any one help on to find out active schemas in 9i oracle database [message #485780 is a reply to message #485779] Thu, 09 December 2010 20:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>The last updated time may be a good indicator of the same.
post SQL & results that satisfy your requirement

Report message to a moderator

Re: please any one help on to find out active schemas in 9i oracle database [message #485797 is a reply to message #485779] Fri, 10 December 2010 00:03 Go to previous message
Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No built-in way to do it.
You have to do it by yourself.

For instance, you can use v$segment_statistics.

Regards
Michel

Report message to a moderator

Previous Topic: I dropped the HR sample DB - now I'm lost!
Next Topic: need to load database files on other machine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 07:27:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.