11- Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN

from OPEN Tech Talks: AI 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/

Episode details come from the podcast's RSS feed.

Embed this episode

Attribution link and audio player

Ready to play

11- Tech Talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN

0:00 15:12

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

French Your Way Jessica: Native French teacher founder of French Your Way Boost your French listening skills and test your comprehension with this one of a kind series of podcasts. Get the chance to listen to a real conversation between native speakers talking at normal speed AND customise your learning experience through carefully designed sets of questions (2 levels of difficulty) available for download at www.frenchvoicespodcast.com. All interviews also come with the transcript. French teacher Jessica interviews native speakers of French from around the world who share a bit of their life and passion. Where else would you meet in one same place a French yoga teacher based in Melbourne, a soap manufacturer from Provence, or a couple cycling around the world? The Course Mentors Podcast The Course Mentors Hey there, future course creator! Ever feel like turning your know-how into an online course is like trying to solve a Rubik's cube blindfolded? Well, grab your headphones because "The Course Mentors Podcast" is here to be your secret weapon! Meet Aimee and Odette (that's us!), your new best friends in the course creation world. We've been in the trenches for over a decade, and for the last five years, we've been rocking the online course space. Now we're here to spill all our secrets in bite-sized, 15-20 minute episodes that'll fit perfectly in your coffee breaks. No fluff, no filler - just real, actionable advice that'll take you from "um, what's a landing page?" to "holy moly, I just hit six figures!". We're talking everything from crafting your course to marketing it like a pro and building a business that'll have you pinching yourself. Whether you're dreaming of ditching the 9-to-5 grind, adding a sweet extra income str

Frequently asked questions

How long is this episode of OPEN Tech Talks: AI worth Talking| Artificial Intelligence |Tools & Tips?

This episode is 15 minutes long.

When was this OPEN Tech Talks: AI worth Talking| Artificial Intelligence |Tools & Tips episode published?

This episode was published on June 18, 2015.

Can I download this OPEN Tech Talks: AI worth Talking| Artificial Intelligence |Tools & Tips episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.