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,

Report message to a moderator

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: 4581
Registered: April 1998
Senior Member
SELECT SUM(bytes) FROM dba_segments WHERE owner = 'SCOTT';

Report message to a moderator

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

Report message to a moderator

Previous Topic: Database shifting from UNIX to WINDOWS
Next Topic: Job Created Date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 21:17:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.