# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1540310485 -10800
# Node ID 39da290b29bb3d2ab4150a04ccb71e0a889f9b73
# Parent  3662cdbd7b643d7195bfd16247f35701f85890ae
About removing/collecting statistics.

diff -r 3662cdbd7b64 -r 39da290b29bb oracle.rst
--- a/oracle.rst	Tue Oct 23 18:42:39 2018 +0300
+++ b/oracle.rst	Tue Oct 23 19:01:25 2018 +0300
@@ -430,7 +430,17 @@
 
   select * from table(dbms_xplan.display);
 
-To get actual execution plan run following after executing query::
+Remove statistics::
+
+  execute DBMS_STATS.DELETE_SCHEMA_STATS('BOB');
+
+Collect statistics::
+
+  execute DBMS_STATS.GATHER_DATABASE_STATS;
+  execute DBMS_STATS.GATHER_SCHEMA_STATS('BOB');
+  execute DBMS_STATS.GATHER_TABLE_STATS('BOB', 'EMPLOYEE');
+
+Get actual execution plan of query after executing query::
 
   select * from table(dbms_xplan.display_cursor);
   select * from table(dbms_xplan.display_cursor(format => 'basic'));