--- 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'));