# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1488650098 -7200
# Node ID f780f1b08e12dc4b380c24b9dba8de94c80679aa
# Parent  1cf4c735fa6d2bcd435667f5532447ff8b32537c
Managing data files location.

diff -r 1cf4c735fa6d -r f780f1b08e12 oracle.rst
--- a/oracle.rst	Fri Mar 03 00:24:11 2017 +0200
+++ b/oracle.rst	Sat Mar 04 19:54:58 2017 +0200
@@ -106,6 +106,29 @@
   select * from USER_TAB_PRIVS
   select * from USER_ROLE_PRIVS
 
+Managing data files location
+============================
+
+To find out where is data files located run as ``sysdba``::
+
+  select * from dba_data_files;
+  select * from dba_temp_files;
+
+Above files represent table spaces::
+
+  select * from dba_tablespaces;
+
+Another information about installation::
+
+  select * from v$controlfile;
+  select * from v$tablespace;
+  select * from v$database;
+  show parameter control_files;
+
+Place for dumps::
+
+  show parameter user_dump_dest;
+
 Profiling.
 ==========