'Sql id' presentation slideshows

Chapter 22

Chapter 22. Database Troubleshooting. Introduction to Database Troubleshooting. DBAs need to be experts at database troubleshooting. There are a wide variety of topics covered in this chapter: Assessing database availability issues quickly.

470 views • 35 slides

Executing Explain Plans and Explaining Execution Plans

Craig Martin 01/20/2011. Executing Explain Plans and Explaining Execution Plans. Why?. Gene Kranz. Explain Plan - Example. Displaying Results. Query PLAN_TABLE Directly Explain Plan feature in SQL Developer DBMS_XPLAN package. DBMS_XPLAN.DISPLAY. Pros

448 views • 31 slides

Oracle Database 18c New Features Hariprasath Rajaram

Oracle Database 18c New Features Hariprasath Rajaram. Training Objective. Oracle Cloud Free Account 18c Database Creation 18c Dataguard MEMOPTIMIZE_POOL_SIZE in SGA Cancel SQL Instead of Killing Session Pre-Upgrade Utility (Doc ID 884522.1 ) SQLPLUS New Options

362 views • 31 slides

101 Ways to get SQL Execution Plan. What is the best option to use?

101 Ways to get SQL Execution Plan. What is the best option to use?. By: Paul Guerin (Originenergy) , Serge Stadnichenko (Originenergy) , Konrad Dear (Telstra) , Yury Velikanov (Pythian) , & All of you. Introductions. Typical responses to poor performance:

347 views • 21 slides

101 Ways to get SQL Execution Plan. What is the best option to use?

101 Ways to get SQL Execution Plan. What is the best option to use?. By: Paul Guerin (Originenergy) , Serge Stadnichenko (Originenergy) , Konrad Dear (Telstra) , Yury Velikanov (Pythian) , & All of you. Introductions. Typical responses to poor performance:

298 views • 21 slides

DBA LESSONS LEARNED

529 views • 18 slides

313 views • 11 slides