Skip to Main Content
  • Questions
  • Disk space details of every db and table

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Sourav.

Asked: August 10, 2017 - 5:30 am UTC

Last updated: August 12, 2017 - 4:50 am UTC

Version: 11g

Viewed 1000+ times

You Asked

How can i get the database details like recovery model used, total capacity, free space , space used in case of each database and tables present

and Connor said...

You could write your own to get just the details you want, but here's a very exhaustive suite of scripts that has been popular in the community for a number of years. Its a great place to start

https://carlos-sierra.net/2014/07/27/edb360/


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database