-
DB Size
How will you measure the Database Size?
I was asked in one of the interview which I have attended. I have little confusion. Is the db size means, all the db file size or only system tablespace size?
Can someone give explanation for this?
- Bala.
Bala
-
What a dumb question. "Database size" can mean raw data size, size of used blocks in tables, size of tables to high-water mark, total size of tables, tables + indexes, total size of data files, size of data files - (system+undo+temp),any of those things. Depends of the reason why you are asking.
Actually, maybe that's the right answer.
-
Generally It means the sum of all datafiles including your system datafiles.
select sum(bytes)/1024/1024 filesize_in_MB from dba_data_files;
K.Chithra
Oracle DBA
-
Originally posted by k.chithra
Generally It means the sum of all datafiles including your system datafiles.
select sum(bytes)/1024/1024 filesize_in_MB from dba_data_files;
What abt the tempfiles in the case of locally managed temporary tablespaces???? Right query should be..
select a.bytes+b.bytes from
(select sum(bytes)/1024/1024 bytes from dba_data_files) a,
(select sum(bytes)/1024/1024 bytes from dba_temp_files) b
/
-nagarjuna
-
Hi chithra
Database Size= datafiles+control files+Redo log Files
Cheers
Murali
-
Originally posted by dasari98
Hi chithra
Database Size= datafiles+control files+Redo log Files
Cheers
Murali
So if I have a database with one table that contains 20 rows and I have 100 2G datafiles, my db size is 200G?
Jeff Hunter
-
Originally posted by slimdave
Depends of the reason why you are asking.
Actually, maybe that's the right answer.
A good reply to any management request is "What decision will you base upon this?". It's a very intelligent thing to say and, best of all, it pisses them off no end!
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
db_size
But I will calculate in a different way (for the actual database size)
select sum(bytes)/1024/1024 "DB Size(MB)" from dba_segments;
Thomas
Last edited by Thomasps; 03-17-2003 at 10:20 PM.
-
Originally posted by marist89
So if I have a database with one table that contains 20 rows and I have 100 2G datafiles, my db size is 200G?
I have noticed that for many people it is as above, i.e., the sum of the sizes of the files. For me it is the used blocks: for example all that RMAN will backup within a full DB backup.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|