Session's parameters?
David D., June 19, 2020 - 4:13 pm UTC
Hello,
What do you mean by "I have set the user profile also same for both users" : profile, parameters...?
Are you sure that the optimizers parameters have the same value in the session? For exemple, is optimizer_mode different? Is there an after logon trigger which set differently some parameters for your both users?
June 19, 2020 - 4:38 pm UTC
Good question. I'm also wondering if each execution reads the same tables, or if there's tables with the same names in different schemas.
A reader, June 20, 2020 - 2:28 am UTC
While checking the explain plan, showing same for both users
David D.., June 20, 2020 - 10:04 am UTC
Can you post both execution plans?
And if you use autotrace, can you post the result? I want to see if the number of read blocks is the same for both users.
June 22, 2020 - 10:49 am UTC
Yep, that's what I want to see too!