Home » RDBMS Server » Performance Tuning » how to set the sql_profile (10.2.0.1)
how to set the sql_profile [message #553729] Tue, 08 May 2012 03:32 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
how to set the sql_profile?


Select sql_id,sql_profile From v$sql Where sql_id='8mpsfa1rms005'
Re: how to set the sql_profile [message #553774 is a reply to message #553729] Tue, 08 May 2012 08:09 Go to previous messageGo to next message
LNossov
Messages: 283
Registered: July 2011
Location: Germany
Senior Member
You can create sql profile via package dbms_sqltune:
1. firstly create a tuning task by dbms_sqltune.create_tuning_task,
2. secondly execute this task by dbms_sqltune.execute_tuning_task,
3. after that you have to create and to check the report by dbms_sqltune.report_tuning_task,
4. then you can accept sql profile suggested in the section "Using SQL Profile" of the report.

For what purpose do you need this?
Re: how to set the sql_profile [message #553851 is a reply to message #553774] Tue, 08 May 2012 21:13 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: Performance issue in query
Next Topic: Expplain plan output
Goto Forum:
  


Current Time: Sun Apr 20 07:40:48 CDT 2014

Total time taken to generate the page: 0.05070 seconds