Outer Web | Explore

Explore >> Select a destination

You are here		alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	6.4 parsecs away Travel
\|	\|	There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....	6.4 parsecs away Travel
\|	\|	carlos-sierra.net SQLTXPLAIN 101 \| Carlos Sierra's Tools and Tips	5.5 parsecs away Travel
\|	\|	SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In...	5.5 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com SQL Profiles - 2 \| Oracle Scratchpad	8.6 parsecs away Travel
\|	\|	Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few...	8.6 parsecs away Travel
\|	\|	aivarsk.com Making sense of card range query EXPLAIN plans \| Aivars Kalv?ns	78.7 parsecs away Travel
\|		I was listening to a talk about finding a PAN in a haystack and this slide came up with performance numbers in seconds:	78.7 parsecs away Travel