In this session guest speaker Lothar Flatz will give a tech talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN.
Our guest speaker Lothar Flatz, from Switzerland, comes from a family of Austrian engineers and inventors. This inherited talent he used since 1989 to improve applications in the Oracle environment being faster and better. He is an Oracle ACE and in 2010 Oracle appointed him a member of the Real World Performance Group. He is also a member of OakTable.net and he blogs on his own blog Oracle RiddleBlog.wordpress.com. A decade of experience working with customers to solve Oracle Problems.
Thank you so much Lothar for your experience sharing with the Oracle community.
IN THIS SESSION, WE WILL LEARN
The DBMS_XPLAN package gives us a very easy method to display the output of the EXPLAIN PLAN command in predefined formats. DBMS_XPLAN the package can also be used to display the plan of a statement stored in the Automatic Workload Repository (AWR) or stored in a SQL tuning set. It further provides a way to display the SQL execution plan and SQL execution runtime statistics for cached SQL cursors based on the information stored in the V$SQL_PLAN and V$SQL_PLAN_STATISTICS_ALL fixed views.
DISPLAY_CURSOR Function
This table function displays the explain plan of any cursor loaded in the cursor cache. In addition to the explain plan, various plan statistics (such as. I/O, memory, and timing) can be reported (based on the V$SQL_PLAN_STATISTICS_ALL VIEWS).
Syntax
DBMS_XPLAN.DISPLAY_CURSOR( sql_id IN VARCHAR2 DEFAULT NULL, cursor_child_no IN NUMBER DEFAULT 0, format IN VARCHAR2 DEFAULT 'TYPICAL');
LINKS AND RESOURCES MENTIONED IN THIS SESSION
Thank you so much for Listening!
Join today OTechTalks.tv and Be Part of Tech Talk?
If you have some feedback/comments on this session or you want to suggest some new topic we should cover in future Podcast. Please leave a note in the comment section below!
If you enjoyed this episode and we together are learning new Oracle Technologies, please share it with other folks.
Also, please leave a candid review for the OTechTalks Podcast on iTunes! Your ratings and reviews will help the session on iTunes.
Please subscribe to the Podcast on iTunes to get automatic updates