11- Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN

OPEN Tech Talks: Technology worth Talking| Artificial Intelligence |Tools & Tips

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.

https://www.otechtalks.tv/tech-talk-on-display_cursor-table-function-of-dbms_xplan/