Page Navigator is a kind of mandatory
item for the blogger mainly for the home, archive pages. Otherwise you will be
able see only the maximum allowed pages in the home pages or in the search
pages. It will be difficult to navigate to the next pages.
Use dbms_xplan.display_awr to Pull Full SQL and Execution Plan for a Query in AWR
Overview:
DBMS_XPLAN package gives an easy way to display the
output of EXPLAIN PLAN command. You can use this package to display the
execution plan of a statement stored in the AWR report, SQL tuning set, cached
SQL cursor based on the information stored in the v$sql_plan and
v$sql_plan_statistics_all views.
