Home arrow Databases arrow Space taken by a schema in Oracle database
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software

Space taken by a schema in Oracle database Print E-mail
To get the space taken up by all the objects in the schema, the following query can be used

select ((sum(bytes)/1024)/1024)/1024 Space_in_GB from dba_segments where owner='SCHEMA_NAME'
< Previous   Next >



gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org