Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

regarding database size

Dheeraj Tanwar
Occasional Contributor

regarding database size

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
9 REPLIES
Suraj K Sankari
Honored Contributor

Re: regarding database size

Hi,

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

Suraj
Dheeraj Tanwar
Occasional Contributor

Re: regarding database size

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

Re: regarding database size

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
Best regards from Romania,
Horia.
Horia Chirculescu
Honored Contributor

Re: regarding database size

... and yould look for oradata/

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

Best regards from Romania,
Horia Chirculescu
Best regards from Romania,
Horia.
Patrick Wallek
Honored Contributor

Re: regarding database size

>>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
Occasional Contributor

Re: regarding database size

Thanks Patrick Wallek for giving me solution
Kapil Jha
Honored Contributor

Re: regarding database size

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+

I am in this small bowl, I wane see the real world......
Richard A Lemons
Occasional Visitor

Re: regarding database size

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
Honored Contributor

Re: regarding database size

"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.
Best regards from Romania,
Horia.