Home » RDBMS Server » Server Administration » how can i know the DB size
how can i know the DB size [message #58341] Sat, 16 August 2003 02:27
Rahman
Messages: 40
Registered: July 2003
Member
Hi Satish Shrikhande,
Thanks a lot for ur help
Ur Code display the following
TABLESPACE_NAME AVAILABLE_MB USED_MB PCT_USED
------------------------------ ------------ --------- ---------
RBS 150 12 8
SYSTEM 140 135 96
USERS 268 211 79

so, total of available_mb will be the size of Database
plz consider my other Q. is :-
this is new Database & heavy transaction is going on day by day so how can i know that BataBase size will automatically increase or not?
But few days ago when huge amount of rows were added due to the size error was dispayed the i added a User DataFile of 300MB after that it's working fine.
Addition of BIG size 300MB DataFile is wrong or right?
thanks in advance
rahman
Previous Topic: loss of a table
Next Topic: how can i know the oracle database size
Goto Forum:
  


Current Time: Fri Sep 20 06:32:55 CDT 2024