New diagnostic tool

From: Mladen Gogala <>
Date: Tue, 28 Feb 2012 03:53:06 +0000 (UTC)
Message-ID: <>

Oracle has just made available a new diagnostic tool which can help with examining a SQL statement. Takes a statement, by the SQL_ID, and examines it thoroughly. It goes through the optimizer environment, plan and plan statistics, if available. It can also produce the execution history from AWR, if the user is licensed for the performance tuning pack. Here is the document:

FAQ: SQL Health Check (SQLHC) (Doc ID 1417774.1)

The tool is very interesting and it is free. It's very easy to use. It's so easy that even Kim Kardashian could use it, to paraphrase one nice GEICO commercial.

Received on Mon Feb 27 2012 - 21:53:06 CST

Original text of this message