Home » RDBMS Server » Enterprise Manager » How to find db size, blah blah...
How to find db size, blah blah... [message #68376] Thu, 03 July 2003 00:07 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi,
I m very new dba. Let me know how to find the size of the current database, daily growth of db, unused space in db, used space in db.

TIA,
Sachin
Re: How to find db size, blah blah... [message #68395 is a reply to message #68376] Tue, 15 July 2003 15:19 Go to previous message
ranjan
Messages: 20
Registered: August 1999
Junior Member
You can Gui based tool called DBA studio to view the free space, etc... the tool is located under start-->program-->oracle--->. this is an excellent tool. Login as a user with dba rights and you'll be able to modify most of things except the system parameters.

Also, you can run
select * from dba_data_files; command to see all of you datafiles. Run select * from dba_tablespaces;
I usually use dba_data_files.
Previous Topic: OEMAPP Console
Next Topic: deadlock detected
Goto Forum:
  


Current Time: Thu Mar 28 08:19:49 CDT 2024