on 03-01-2012 12:20 PM
Hello,
when i use the SQL Tuning Advisor in dbacockpit the SQL Tune Job Fails With ORA-13639.
To fix this in sqlplus i Increased the job "Time Limit" by using the below script (Oracle Support Automatic SQL Tune Job Fails With ORA-13639 [ID 1363111.1]):
BEGIN
DBMS_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER(
parameter => 'TIME_LIMIT', value => '7200'
);
END;
/
When i try to execute this PL/SQL statement in the SQL command Editor i get a parsing Error.
How can ii fix this failure in the SAP- environment?
kind regards
Lutz
Hi Lutz,
Execute the PL/SQL statement on SQLPlus at the operating system level, not on "SQL Command Editor" on SAP
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Orkun;
> when i increase the time_limit on operating system level and then execute the "SQL Advisor" the error still exists. Is there a possibility to execute the PL/SQL- Statent in the SAP- Evironment?
>
> kind regards
> Lutz
If you executed the DBMS_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER script on Sqlplus, it will be affect the SAP side, as well. So, you don't need to execute this statement, at SAP level.
The thing you stuck is the time-out error. So, you should configure the time-out value long enough.
One another way is; if you would like to see the statement analysis report for an sql statement, executed previously, you can follow the path DBACOCKPIT -> Performance -> SQL Statement Analysis -> Shared Cursor Cache -> Select the statement on the list -> "Analysis Report"
Best regards,
Orkun Gedik
Hi Orkun,
> the "SQL Tuning Advisor" and the "Analysis Report" are two different reports.
>
>
> kind regards
> Lutz
Of course, they are different. I just wanted to show another way to have statistical values about the statement. They are not same, but you can have information about the statement.
Best regards,
Orkun Gedik
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.