Simple Page Navigator for Home and Archive Blogger Pages with Numbers and Customization Tricks



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.
 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google