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.
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.