با برنامه Player FM !
پادکست هایی که ارزش شنیدن دارند
حمایت شده
11- Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN
Manage episode 291823683 series 2922369
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/
158 قسمت
11- Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN
OPEN Tech Talks: Technology worth Talking| Artificial Intelligence |Tools & Tips
Manage episode 291823683 series 2922369
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/
158 قسمت
همه قسمت ها
×









1 AI Tech Circle - Diaries from the Field, Building Ethically Responsible AI Enterprise Solution 23:44




1 Building a Game-Changing AI Strategy: Step-by-Step Guide and Exercises for Your Organization 20:04



















1 Meet AI Teacher: The Future of AI in Education Unveiled with Dr Pauldy Otermans and Dev Aditya 45:36











1 Balancing Work and Study: Tips for the Working Professional Pursuing a Degree with Christie Carmelle Lopez 29:02

به Player FM خوش آمدید!
Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.