1748195 Members
3082 Online
108759 Solutions
New Discussion юеВ

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 9
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
New Member

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.