| database size [message #143317] |
Wed, 19 October 2005 21:03  |
gjayasekar
Messages: 45
Registered: October 2005
|
Member |
|
|
hi,
pl provide the script
1.to find out the current database size
2.to find out the day by day database growing size
thanks
jai
|
|
|
|
| Re: database size [message #143510 is a reply to message #143317] |
Thu, 20 October 2005 12:36  |
humair77
Messages: 13
Registered: August 2005
|
Junior Member |
|
|
Following SQL will provide you the Size of your DB:
SQL> Select sum(bytes/1024/1024/1024) "Size in GB" from dba_data_files ;
Size in GB
----------
1721.25729
|
|
|
|
| Re: database size [message #143515 is a reply to message #143317] |
Thu, 20 October 2005 13:18 |
bmahireddy
Messages: 14
Registered: March 2005
|
Junior Member |
|
|
MAHI@DEV> @ts_free_used
Enter Tablespace Name:
Tablespace Name Tablespace Size (Mb) Used Space (Mb) Free Space (Mb) Difference
-------------------- -------------------- --------------- --------------- ------------
CLIENT_SDATA01 25.000 18.438 6.500 6.563
CLIENT_SINDX 30.000 17.500 12.438 12.500
CLIENT_VINDX 50.000 45.375 4.563 4.625
DSS_DATA01 5.000 .063 4.875 4.938
SYSTEM 300.000 289.266 10.727 10.734
USR 670.000 546.375 123.563 123.625
-------------------- --------------- --------------- ------------
Total 1,080.000 917.017 162.666 162.985
8 rows selected.
Elapsed: 00:00:28.05
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
