regarding database size

[Dheeraj Tanwar]

Hi
Can any one help me how can I find out the database size, I have HP-UX server ( HP 9000 A-CLASS A180 )

From console how can I find out the database size of my oracle database.

Thanks

[Suraj K Sankari]

Hi,

Please contact your DBA who is having the SA permission to do this task...

Suraj

[Dheeraj Tanwar]

Suraj I have to take care of both the parts Server Admin as well as Database Admin.

[Horia Chirculescu]

Hello,

You should "cd" to the top of your database tree and do a "du -ksh --total *"

This would give you a hint about the total size of the files from your current directory

Sample:

su - hpux_oracle_instance_user
cd $ORACLE_BASE
du -ksh --total *


Best regards from Romania,
Horia Chirculescu

[Horia Chirculescu]

... and yould look for oradata/

Or better give the command like this:
du -ksh --total $ORACLE_BASE/oradata/*

Best regards from Romania,
Horia Chirculescu

[Patrick Wallek]

>>du -ksh --total

The '-h' and the '--total' options do not exist in du on HP-UX.

If you have sqlplus access do:

SQL> Select sum(bytes) from dba_data_files ;

SUM(BYTES)
----------
4.1958E+11


With the notation above, move the decimal place to the right 11 times to come up with bytes:

419,580,000,000 bytes which converts roughly to 419 GB.

Your mileage may vary depending on your DB size.

[Dheeraj Tanwar]

Thanks Patrick Wallek for giving me solution

[Kapil Jha]

What you mean by DB size
DB file
or the size DB need in memory

For DB files you will have to go to DB directory and see size of DB files.

For size of DB need to start
check init.ora file for various parameter
eg SGA size, shared pool size.

BR,
Kapil+

[Richard A Lemons]

Since you are also the dba you could log into the database and query:
1. select sum(bytes)/1024/1024 from dba_data_files

2. select sum(bytes)/1024/1024 from dba_temp_files;

The total of the result of these two queries will give you the Mb for all the data files that support the tablespaces and the temp files

[Horia Chirculescu]

"The '-h' and the '--total' options do not exist in du on HP-UX."

Patrick Wallek is right about this. But for the clarity of the post should mention that anyone can install the gnu coreutils from:

http://www.gnu.org/software/coreutils/

This version of du have those options I am talking about and a lot more usefull additional ones.

Best regards
Horia.