Re: Question regarding Grid Control Automatic SQL Tuning
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 14 Oct 2011 09:29:05 -0400
Looking at dba_advisor_findings I see the below. So where is this task???
Looking for something called EXEC_61% for an execution name in this table finds
nothing.
select * from sys.dba_advisor_findings where message like '%6172%';
OWNER TASK_ID TASK_NAME
------------------------------ ---------- ------------------------------
EXECUTION_NAME FINDING_ID
------------------------------ ----------
FINDING_NAME
--------------------------------------------------------------------------------
TYPE TYPE_ID PARENT OBJECT_ID
----------- ---------- ---------- ----------
IMPACT_TYPE
--------------------------------------------------------------------------------
IMPACT
----------
MESSAGE
--------------------------------------------------------------------------------
MORE_INFO
--------------------------------------------------------------------------------
F FLAGS
- ----------
SYS 11482 SYS_AUTO_SQL_TUNING_TASK
EXEC_6692 33354
normal, successful completion
INFORMATION 4 0 34938
0
This statement was skipped because it has already been tuned recently. See task
execution "EXEC_6172" for the most recent tuning results.
N 1
>>> Jeffrey Beckstrom 10/14/11 8:58 AM >>>
In Grid Control, looking at "Automatic SQL Tuning Result Details". I click on
sql_id and then the Advisor Task Name, under findings it states:
This statement was skipped because it has already been tuned recently. See task
execution "EXEC_6172" for the most recent tuning results.
Does this mean that the system automatically did something and if so what?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
--
//www.freelists.org/webpage/oracle-l
Other related posts:
