Hi ,
I have 2 quries :-
1)
Two identical sqls submitted by 2 different users (under same schema)
will be parsed twice or only once ??
Or in short , will 2nd user will be benifited when he runs the same query ??

2) I have multiple select statements in a pl/sql block and there is no exception handler in it. If one the statement raises a "data found " error , where/how this error is shown in TRACE file ??

Thanks & Regds
Amol

Amol Mudholkar

The second query will be parsed again, but it will be a soft parse, rather than a hard parse, so the second session will get a significant benefit.

What sort of trace file are we talking about here?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

Thanks for the reply.

Can u please elborate further ur 1st answer ? and also will the sql statement will be same in shared_pool or diff(since 2 user's are executing)

Regarding 2nd query, i was referring TKPROF trace file.
I quess we can found from the rows returned =0 for the culprit sql but is this correct/only way/or there is something more to it ..

Thanks
Amol

Amol Mudholkar