-
Title
How to identify the size of a database in Toad for Oracle -
Description
I want to know if it's possible to determine or identify the size of a database in Toad for Oracle; is there a tool or can I find a way to find this information in Toad?
-
Resolution
There isn’t a field or tool exactly that indicates the size of a database, but the majority of the size comes from the datafiles of tablespaces. In Toad there is a graphical representation of the space usage in Tablespaces that can be accessed in two ways:
A. If the DB Admin module is an add-on on the license key, go to Database | Monitor | Database Browser. In the new window, click on the database in question and then click on the Space Usage tab.
B. If the DB Admin module is not present, go to Database | Administer | Tablespaces to get the same information.
C. Optional: Query the numbers and add them up; to find out how many megabytes are allocated by ALL tablespaces, use the following query:
1. select sum(bytes)/1024/1024 from dba_data_files;
To find the size (in megabytes) of your redo logs:
2. select sum(bytes)/1024/1024 from v$log;The above two queries will show you how large your database is (essentially).Also, if the database is in archivelog mode, files are generated in the archivelog destination. Issue the following query to see where the archived redo logs get placed:select * from v$parameter where name = 'log_archive_dest';