| How to find the database size [message #60436] |
Sun, 08 February 2004 18:30  |
S.Rajesh Kannan
Messages: 26
Registered: September 2003
|
Junior Member |
|
|
Hi all,
I am working in Oracle 8.1.7 on Solaris. How to find the database size?. Is there any command for this?.
Thanks in advance
-S.Rajesh Kannan
|
|
|
|
| Re: How to find the database size [message #60437 is a reply to message #60436] |
Sun, 08 February 2004 18:38  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
To know the Size allocated for Datafile use
SELECT NAME,BYTES/1024/1024 MB FROM V$DATAFILE ;
THIS GIVES ALL THE DATAFILE SIZE.
IF YOU NEED TO KNOW TOTAL
SELECT SUM(BYTES)/1024/1024 MB FROM V$DATAFILE ;
SATISH
|
|
|
|
|
|
| Re: How to find the database size [message #60484 is a reply to message #60436] |
Tue, 10 February 2004 09:30 |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
I just posted a new release of dbAdmin which is a comprehensive, easy to use, integrated set of tools that allow a novice as well as an experienced Oracle DBA, to manage, monitor, diagnosis and tune the Oracle database 8i as well as 9i. It is also an excellent DBA learning tool as it include a wealth of functions from managing tables to comparing two schemas, from monitoring the library cache hit ratio to building your own KPIs, with the option the view all the SQLs executed behind the scene. One of the many functions is to display all the statistics about the database including SGA, log files and data files.
It is free trial and free support. I will appreciate any feedbacks to make it even better. The link is http://www.barsoft.net my email address is mbartov@barsoft.net
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
