-
Database Size
Hi DBAs,
How to know my Database size.
My used space comes around 2.3 GB from v$datafile.
Can i take this as my database size.
Pls let me know.
Thanx in advance.
-
My simple mathematic is
select sum(bytes)/1024/1024 Database_size_MB from dba_data_files;
Last edited by Thomasps; 01-08-2004 at 04:58 AM.
-
and v$logfile and v$control_file
maybe also the size of you password file and spfile / init.ora file
-
Hi Thomas,
It shows like this....
Size in MB
15743.994
So can i take my DB size is 15.74 GB.
Because this is my management requirement.
Thanx
-
Yes. Or you can get accurate value by
Code:
select sum(bytes)/1024/1024/1024 Database_size_GB
from dba_data_files;
-
Yes i got exactly 15.374994 GB.
So informed them which is 15.37 GB.
Thanx
-
but you are forgetting redlog files control files and temp files
they are a part of your database, dont forget them
-
Oh.... Sorry,
I forgot to take that files into my account and i already informed
them based on my previous query and my control file and redolog file
come around less than 20MB. So i have no problem,
Anyway thanx a lot Dave. Your info will be so helpful in future.
So i will take all files in the account in my next requirement.
Thanx
-
temp files as well, they dont appear in dba_data_files they are in dba_temp_files - chance are in your case they are small.
p.s. Redo log seems very small though
-
Hope we are talking about database size as is. If its just database size interms of used space it will be different based upon how much room you have left for future data growth.
Just to say we can have 8 GB tablespace which might have 2GB worth tables.
Reddy,Sam
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
|