Investigation of database and its component

[Adriana_andros]

Hello, I am not much familiar about database terms and willing to know the space of whole database and its component,suggest me some way to find out these things from database. I have used some queries to know tablespaces but I didn't found Free space column.

[MindSpace]

You can check every action of your database using some provided tools like base tables and dynamic views.

Before doing anything,you have to access on the administration account of database otherwise you can not investigate anything from database.

There are two different method through which you can check the status of your database :

1. Base tables (Physical database information)
2. Database dynamic views(logical database information)

[Modifier]

You can get the information of database using dynamic views. It fetches the required information from database instance when it is running without any error.
These view are created when administrator executes the following files from admin folder of ORACLE_HOME"catproc.sql" and "catalog.sql".These files are responsible for creation of dynamic views.

[Praetor]

These are some views and base tables from where you can get the information about database configuration.

From Dynamic Views

1. V$database -information of database
2. V$instance -information of instance
3. v$logfile -information of redo log files
4. V$log -About log groups and members
5. v$datafile -About datafiles

From Base Tables which provide much more information

1. DBA_TABLESPACES
2. DBA_DATA_FILES
3. DBA_LOG_FILES
4. DBA_FREE_SPACES