Hi tom,

I have not very much in performance tuning but due to learn i am taking the performance related query also from user end.

For tuning i have generated awr report and get top 10 queries and take the execution plan of that and generate

@?/rdbms/admin/sqltrpt.sql; --And give that sql_id and get the recommendations but yesterday the end user provide the query like -

UPDATE NVT_VEHICLE set v2=nvl(:"SYS_B_0",v2) where vehicle_no=:"SYS_B_1" and company_id=:"SYS_B_2"

1. Hoq to get recommendations like if i have sql_id then pass in sqltrpt.sql .
2. how can i get sql_id from this sql_text if i will get sql_id then i will generate the same recommendations from sqltrpt.sql.

Because i tried to get sql_id from

select sql_id from v$sqlarea where sql_text like '%UPDATE NVT_VEHICLE set%';

But no rows returned.

Pls help me to findout this.

Thanks

select sql_id, sql_text from SYS.DBA_HIST_SQLTEXT
where  sql_text like '%UPDATE NVT_VEHICLE set%';