Home Oracle Oracle - TO FIND SIZE OF DATABASE
Oracle - TO FIND SIZE OF DATABASE PDF Print E-mail
Written by Siva   
Wednesday, 21 February 2018 20:44

TO FIND ACTIVE/INACTIVE SESSION:

--------------------------------


select count(*) from v$session;



TO FIND DISK SPACE IN UNIX:

---------------------------


$ df -k|pg



TO FIND SIZE OF DATABASE:

-------------------------

desc dba_data_files;

select * from dict;

DESC dict;


select sum(bytes)/1024/1024 from dba_data_files;



select * from v$controlfile;



select * from v$logfile;



Add the sum of above 3 query results!!


*********************************************************


 

 
 

Advertisement

Featured Links:
HREmail.com
Looking for job? Try HREmail.com
Want to have CMS based Websites?
Try siliconwebcreators.com to CMS based websites.
VM Solutions Inc
For best VM solutions..
Digital Procedure Inc.
Looking for Oracle /SAP /Weblogic Consulting services? visit digitalprocedure.com