select sum(bytes) from dba_segments;
This should do it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 11:10 AM
Where can I find the total size of my DB? I have not found anything in
the
DBA_ views or my
Ken,
Look in the DBA_DATA_FILES view. This will show the size of the data files.
It does NOT show you the size of the redo log or control files.
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To: Multiple
Isn't that printed in the admin guide. chapter 37. Size of My Database?
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Where can I find the total size of my DB? I have not found anything in the
DBA_ views or my documentation.
DBA_DATA_FILES, DBA_SEGMENTS
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Monday, December 31, 2001 11:11 AM
To:
yea, or V$DATAFILES
-Original Message-
Sent: Monday, December 31, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
select sum(bytes) from dba_segments;
This should do it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday,
select sum(bytes) from sys.dba_datafiles;
select sum(bytes) from sys.dba_temp_files;
that is how much space allocated, not necessarily used within each datafile.
joe
Ken Janusz wrote:
Where can I find the total size of my DB? I have not found anything in the
DBA_ views or my
Semantics... Both of the below only give you the total size you've allocated
for storage not the actual size of the database. It's also going to include
sizing for the system tablespace, rollback segments and maybe temporary
segments depending on how they were created. Picky, picky... :-)
I will go with:
select sum(bytes) from dba_segments
-Original Message-
Sent: Monday, December 31, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L
select sum(bytes) from sys.dba_datafiles;
select sum(bytes) from sys.dba_temp_files;
that is how much space allocated, not
Physical size?
SELECT sum(bytes)/1024/1024 FROM dba_data_files;
Will show how much physical space your db takes up on the file system in
megabytes.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 10:10 AM
Where can I