Home » RDBMS Server » Performance Tuning » SQL Tuning ... (Oracle 11g R2)
SQL Tuning ... [message #500666] Tue, 22 March 2011 12:54 Go to next message
aucrun
Messages: 114
Registered: February 2011
Senior Member
Hi,

I have a doubt about DBMS_SQLTUNE.
I have a query that is called regularly, and it consumes me a certain amount of time each time (about 40 seconds, and sometimes a little more).
The query is a little complex, and since it has somes Counts and Group Bys in the way it takes some time to execute.

Running the SQL Tuning Advisor it suggested me to use the DBMS_SQLTUNE.ACCEPT_SQL_PROFILE function.

I've used the next code to Accept the SQL Profile as suggested:
begin
dbms_sqltune.accept_sql_profile(task_name => 'staName1',
name => 'SQLProfile_1',
description => 'Tuning of SQL',
task_owner => 'UserDB',
replace => TRUE);
end;

After that, I've tried to run the SQL again to see if it would run faster, and the result was 30 seconds ...

Now I have a doubt ... did I missed any step along the way? Or by another hand, this is the best result of the tuning?
There is any other way to tune it faster?

Thanks!
Re: SQL Tuning ... [message #500669 is a reply to message #500666] Tue, 22 March 2011 13:02 Go to previous message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>There is any other way to tune it faster?
Yes, no, maybe

http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:
Previous Topic: 9582.69043 gigabytes of physical read total bytes and increasing!
Next Topic: sql library miss rate (2 Merged)
Goto Forum:
  


Current Time: Fri Aug 29 05:22:58 CDT 2014

Total time taken to generate the page: 0.14950 seconds