SQL Performance (MOSC)

MOSC Banner

help me for below queries

edited Sep 6, 2013 6:51PM in SQL Performance (MOSC) 3 commentsAnswered
Hi,

Please help me for below.

1.I need sql id and plan hash value for current running sql.Please let me know how should I find?

2.let say i know sqlid from awr report whose retention period is 8days.I need to find out the plan hash value.How?

3.I know sql text but let say this sql text having the perfomance issue,If this sql script is using bind variables how a DBA need to execute this sql whose having bind values and need to find out the sql id,hash value and plan for that sql.

4.Let say I have one sql how shoudl I know this sql have only one plan or two plans.If i have 2 plans how should I tell to optimizer to use the one plan whose elapsed time is good.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center