Home » RDBMS Server » Server Administration » how to determine how large is the database
how to determine how large is the database [message #63672] Wed, 27 October 2004 02:37 Go to next message
seka
Messages: 11
Registered: November 2001
Junior Member
how do I determine the size of my database(how large is the database)? I am using Oracle 8 and the platform is Unix.

Report message to a moderator

Re: how to determine how large is the database [message #63673 is a reply to message #63672] Wed, 27 October 2004 03:40 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sum of all the tablespace size is size of your 'database'.
here tablespace size is 'allocated size' to get 'allocated size of database'.
or you can consider the 'actual size used' to find the 'actual size of the database'.
In general terms database size will exclude the size of control files,redolog files, archived log files , temp (tablespace files) etc.

These might help...
http://www.orafaq.com/scripts/sql/tsspace.txt
http://www.orafaq.com/scripts/sql/dffree.txt

Report message to a moderator

Previous Topic: Tools to manage and use scripts
Next Topic: How to turn on Tracing? nmi.log
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 10 22:33:59 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.