109 Managing data files location

   110 ============================

   111 

   112 To find out where is data files located run as ``sysdba``::

   113 

   114   select * from dba_data_files;

   115   select * from dba_temp_files;

   116 

   117 Above files represent table spaces::

   118 

   119   select * from dba_tablespaces;

   120 

   121 Another information about installation::

   122 

   123   select * from v$controlfile;

   124   select * from v$tablespace;

   125   select * from v$database;

   126   show parameter control_files;

   127 

   128 Place for dumps::

   129 

   130   show parameter user_dump_dest;

   131