Home » SQL & PL/SQL » SQL & PL/SQL » TABLESPACE SIZE
TABLESPACE SIZE [message #247710] Tue, 26 June 2007 23:40 Go to next message
meeta
Messages: 28
Registered: January 2000
Junior Member
Can Anyone tell me the query TO FIND THE SIZE OF TABLESPACE in database
Re: TABLESPACE SIZE [message #247713 is a reply to message #247710] Tue, 26 June 2007 23:49 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
SELECT sum(bytes) FROM DBA_TABLESPACES
Re: TABLESPACE SIZE [message #248298 is a reply to message #247713] Thu, 28 June 2007 10:20 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> desc dba_tablespaces
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                NOT NULL NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 FORCE_LOGGING                                      VARCHAR2(3)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 PLUGGED_IN                                         VARCHAR2(3)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 DEF_TAB_COMPRESSION                                VARCHAR2(8)
 RETENTION                                          VARCHAR2(11)
 BIGFILE                                            VARCHAR2(3)





select tablespace_name,sum(bytes)/1048576 "size in MB"
from dba_data_files
group by tablespace_name;
Previous Topic: Unable to Exit from the Program in the middle (Merged)
Next Topic: GROUP BY is showing error
Goto Forum:
  


Current Time: Mon Dec 05 11:03:35 CST 2016

Total time taken to generate the page: 0.23094 seconds