help me for below queries
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.