OraFAQ Forum: Performance Tuning » how to set the sql

Home » RDBMS Server » Performance Tuning » how to set the sql_profile (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to set the sql_profile [message #553729]

Tue, 08 May 2012 03:32

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'

Report message to a moderator

Re: how to set the sql_profile [message #553774 is a reply to message #553729]

Tue, 08 May 2012 08:09

LNossov
Messages: 318
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?

Report message to a moderator

Re: how to set the sql_profile [message #553851 is a reply to message #553774]

Tue, 08 May 2012 21:13

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks!

Report message to a moderator

Previous Topic:	Performance issue in query
Next Topic:	Expplain plan output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 12:47:25 CDT 2024