Tag: PL/SQL
Samuel Pesse, an Oracle ACE, wrote in his blog about how to self-test your database. The content below is a republishing of his words.
- Shelby Klingerman
- Blogs
- 11/20/19
A number of polls taken during various PL/SQL-related presentations paint a very strange picture: one of the most-critical FREE server-side performance-tuning tools is almost totally unknown! If you ask basic questions such as, “How much time is spent on routine A?” or “How often is function B called?” most developers would start to hand-code their…
- Quest Customer Learning Team
- Webinars
A number of polls taken during various PL/SQL-related presentations paint a very strange picture: one of the most-critical FREE server-side performance-tuning tools is almost totally unknown! If you ask basic questions such as, “How much time is spent on routine A?” or “How often is function B called?” most developers would start to hand-code their…
- Quest Customer Learning Team
- Webinars
Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query. But once you’ve got an execution plan, what do you do with it? Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the…
- Quest Customer Learning Team
- Webinars
