| about sql access advisor [message #353161] |
Sun, 12 October 2008 02:21  |
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
|
Member |
|
|
Hi,
I have problem in using SQL Access Advisor on test machine(10.2.0).Can anybody send a copy to use SQL access advisor and attributes with an example?
Thanx in advance. suresh
|
|
|
|
|
|
| Re: about sql access advisor [message #353164 is a reply to message #353161] |
Sun, 12 October 2008 02:35  |
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
|
Member |
|
|
This is the script I executed but I am getting the following error.
BEGIN
DBMS_ADVISOR.quick_tune(
advisor_name => DBMS_ADVISOR.SQLACCESS_ADVISOR,
task_name => 'emp_quick_tune',
attr1 => 'SELECT * FROM emp WHERE EMPNO = 7788');
END;
/
SYSTEM>/
BEGIN
*
ERROR at line 1:
ORA-13600: error encountered in Advisor
QSM-00794: the statement can not be stored due to a violation of the invalid
table reference filter
ORA-06512: at "SYS.PRVT_ACCESS_ADVISOR", line 1782
ORA-06512: at "SYS.WRI$_ADV_SQLACCESS_ADV", line 180
ORA-06512: at "SYS.PRVT_ADVISOR", line 3227
ORA-06512: at "SYS.DBMS_ADVISOR", line 706
ORA-06512: at line 2
Regards,
suresh
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
