Re: New diagnostic tool
From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Fri, 9 Mar 2012 04:59:37 -0800 (PST)
Message-ID: <5946679.853.1331297977967.JavaMail.geo-discussion-forums_at_vbkc1>
On Tuesday, February 28, 2012 4:53:06 AM UTC+1, Mladen Gogala wrote:
> 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.
>
> --
> http://mgogala.byethost5.com
Date: Fri, 9 Mar 2012 04:59:37 -0800 (PST)
Message-ID: <5946679.853.1331297977967.JavaMail.geo-discussion-forums_at_vbkc1>
On Tuesday, February 28, 2012 4:53:06 AM UTC+1, Mladen Gogala wrote:
> 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.
>
> --
> http://mgogala.byethost5.com
Interesting indeed! Received on Fri Mar 09 2012 - 06:59:37 CST