topic regarding database size in Operating System - HP-UX

regarding database size

Dheeraj Tanwar — Thu, 15 Oct 2009 04:40:25 GMT

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

Re: regarding database size

Suraj K Sankari — Thu, 15 Oct 2009 04:45:18 GMT

Hi,

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

Suraj

Re: regarding database size

Dheeraj Tanwar — Thu, 15 Oct 2009 04:56:51 GMT

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

Re: regarding database size

Horia Chirculescu — Thu, 15 Oct 2009 07:25:24 GMT

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

Re: regarding database size

Horia Chirculescu — Thu, 15 Oct 2009 07:31:22 GMT

... and yould look for oradata/

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

Best regards from Romania,
Horia Chirculescu

Re: regarding database size

Patrick Wallek — Thu, 15 Oct 2009 12:21:20 GMT

>>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.

Re: regarding database size

Dheeraj Tanwar — Fri, 16 Oct 2009 03:21:12 GMT

Thanks Patrick Wallek for giving me solution

Re: regarding database size

Kapil Jha — Fri, 16 Oct 2009 03:36:54 GMT

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+

Re: regarding database size

Richard A Lemons — Fri, 16 Oct 2009 12:10:06 GMT

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

Re: regarding database size

Horia Chirculescu — Wed, 04 Nov 2009 09:28:03 GMT

"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.