Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

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 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 Travel
\|	\|
\|	\|	carlos-sierra.net SQL Stats Analytics (from SQL*Plus!) \| Carlos Sierra's Tools and Tips 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...	4.9 parsecs Travel
\|	\|
\|	\|	www.bobbydurrettdba.com Alerting on plans that change for the worse \| Bobby Durrett's DBA Blog 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.8 parsecs Travel
\|	\|
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS)) A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	10.3 parsecs Travel
\|