• Oracle

    Oracle Explain plan Performance tuning-16

    Explain plan Analyze to gather statistics in Oracle 8i and above, Use DBMS_STATS. ANALYZE TABLE <table> VALIDATE STRUCTURE; — Validate table structure. dbms_stats.set_table_prefs – From 11g onwards. Designed to allow the DBA more control over the freshness of their statistics.   DBMS_XPLAN.xxx DISPLAY – to format and display the contents of a plan table. DISPLAY_AWR – to format and display the contents of the execution plan of a stored SQL statement in the AWR. DISPLAY_CURSOR – to format and display the contents of the execution plan of any loaded cursor. DISPLAY_SQL_PLAN_BASELINE – to display one or more execution plans for the SQL statement identified by SQL handle DISPLAY_SQLSET – to…