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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: OEMAPP Console
Next Topic: deadlock detected
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 14:38:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.