DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 24, 2012

To get the DATABASE SCHEMA SIZE from the database


set linesize 150
set pagesize 5000
col owner for a15
col segment_name for a30
col segment_type for a20
col TABLESPACE_NAME for a30
clear breaks
clear computes
compute sum of SIZE_IN_GB on report
break on report
select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner;

4 comments:

Anonymous said...

Thanks for the query...It was useful...

Bablu Gope said...

thanks for helping . it was more useful

CIIT Noida said...

Hadoop Training Institute in Noida, The Hadoop

certification has considerable advantages in addition to the great demand for trained professionals. A certified Hadoop professional gets the

advantage in terms of payment package compared to other professionals working in the field without certification. When it comes to IJP, Hadoop

certification is compatible to advance the ladder and accelerate your career. big data hadoop training in Noida, big data hadoop Training institutes

in Noida, sector 2, oracle big data training,Oracle Training

in Noida
, big data boot camp, nosql database training, big data appliance training, exalytics training, exadata course, big data introduction,

oracle course, oracle training, big data training in Noida, ibm big data hadoop training institutes noida
Hadoop Training Institute in Noida

CONTAC CIITN:

B-12, Sector - 2, Noida, U.P
State - Uttar Pradesh U.P
Country - India
Pin Code - 201301

Phone - +917290926565
Mon - Sun: 10am - 6pm

Avigdor Liberman said...

Can I just say what a relief to find somebody who actually knows what theyre talking about on the internet. You definitely know how to bring a difficulty to mild and make it important. Extra individuals must learn this and perceive this aspect of the story. I cant consider youre not more fashionable because you undoubtedly have the gift. casino online