1.

How Do You Find The Total Database Size In The Database?

Answer»

You can use the FOLLOWING database views to get the information on database size:

  •  dba_segments —Gives the information about the used space. You can take a total of all the BYTES in the dba_segments VIEW to get the used space.
  •  dba_data__files —Gives the Information on space allocated to datafiles for permanent tablespaces.
  •  V$log— Gives the information on redo log files.

You can use the following database views to get the information on database size:


Discussion

No Comment Found

Related InterviewSolutions