Outer Web | Explore

Explore >> Select a destination

You are here		jhdba.wordpress.com Automatically running sql_advisor tasks from ADDM reports « Oracle DBA - A lifelong learning experience
\|	\|	jonathanlewis.wordpress.com Expanding SQL \| Oracle Scratchpad	3.8 parsecs away Travel
\|	\|	Here's a little thing that Dan Morgan mentioned to me some time ago. It's a little routine from a package (owned by sys) that appeared in 11.2.0.3 that gives you some idea of the mess hidden behind a query that uses views. The procedure is called dbms_sql2.expand_sql_text and it takes two (CLOB) parameters: an IN	3.8 parsecs away Travel
\|	\|	www.bobbydurrettdba.com Alerting on plans that change for the worse \| Bobby Durrett's DBA Blog	4.7 parsecs away Travel
\|	\|	I've uploaded a monitoring script that I have worked on: zip. The script alerts you when the optimizer runs a SQL statement with a potentially new and inefficient plan so you can intervene. ...	4.7 parsecs away Travel
\|	\|	carlos-sierra.net SQL Stats Analytics (from SQL*Plus!) \| Carlos Sierra's Tools and Tips	5.0 parsecs away Travel
\|	\|	If you have access to some other graphical tool that displays time series on multiple dimensions for one or a set of SQL statements from an Oracle database, then you may not need "SQL Stats Analytics". In the other hand, if you have no such tool, or even more restricting, if you can only access...	5.0 parsecs away Travel
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? - follow up \| Tony's Oracle Tips	45.3 parsecs away Travel
\|		As has happened a couple of times recently, comments on a blog of mine have helped me understand the subject matter on which I am commenting far better. In this case a dialogue with Dom Brooks on my previous blog on how to simulate a stored outline/SQL baseline with FORCE_MATCH using SQL profiles has provided...	45.3 parsecs away Travel