New diagnostic tool
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 28 Feb 2012 03:53:06 +0000 (UTC)
Message-ID: <pan.2012.02.28.03.53.06_at_gmail.com>
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:
Date: Tue, 28 Feb 2012 03:53:06 +0000 (UTC)
Message-ID: <pan.2012.02.28.03.53.06_at_gmail.com>
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.comReceived on Mon Feb 27 2012 - 21:53:06 CST