Home » RDBMS Server » Server Administration » Get size of the Perticular User (Oracle 10g)
Get size of the Perticular User [message #375924] Mon, 15 December 2008 06:28 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
How can i get the size occupied by the perticular USERNAME in the database?

Thanks,
Re: Get size of the Perticular User [message #375925 is a reply to message #375924] Mon, 15 December 2008 06:30 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
SELECT SUM(bytes) FROM dba_segments WHERE owner = 'SCOTT';
Re: Get size of the Perticular User [message #375927 is a reply to message #375924] Mon, 15 December 2008 06:37 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks for quick reply Smile
Previous Topic: Database shifting from UNIX to WINDOWS
Next Topic: Job Created Date
Goto Forum:
  


Current Time: Sat Dec 10 11:01:37 CST 2016

Total time taken to generate the page: 0.09249 seconds