- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- regarding database size
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2009 09:40 PM
тАО10-14-2009 09:40 PM
regarding database size
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2009 09:45 PM
тАО10-14-2009 09:45 PM
Re: regarding database size
Please contact your DBA who is having the SA permission to do this task...
Suraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2009 09:56 PM
тАО10-14-2009 09:56 PM
Re: regarding database size
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2009 12:25 AM
тАО10-15-2009 12:25 AM
Re: regarding database size
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2009 12:31 AM
тАО10-15-2009 12:31 AM
Re: regarding database size
Or better give the command like this:
du -ksh --total $ORACLE_BASE/oradata/*
Best regards from Romania,
Horia Chirculescu
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2009 05:21 AM
тАО10-15-2009 05:21 AM
Re: regarding database size
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2009 08:21 PM
тАО10-15-2009 08:21 PM
Re: regarding database size
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2009 08:36 PM
тАО10-15-2009 08:36 PM
Re: regarding database 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+
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2009 05:10 AM
тАО10-16-2009 05:10 AM
Re: regarding database size
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2009 01:28 AM
тАО11-04-2009 01:28 AM
Re: regarding database size
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.
Horia.