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
It shows like this....
Size in MB
So can i take my DB size is 15.74 GB.
Because this is my management requirement.
Yes. Or you can get accurate value by
select sum(bytes)/1024/1024/1024 Database_size_GB
Yes i got exactly 15.374994 GB.
So informed them which is 15.37 GB.
but you are forgetting redlog files control files and temp files
they are a part of your database, dont forget them
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.
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
Just to say we can have 8 GB tablespace which might have 2GB worth tables.
Click Here to Expand Forum to Full Width