Explain plan question

[akhorram]

Hi there, I have been away from Oracle for a while and so I have forgotten some things. I remember that there was a command that would show the query execution plan for each query. It was set for a user and after it was set, every query by the user would show the execution plan. Could you kindly tell me what that command is? Thank you.

[Mister]

If you have Plan table created in the Schema,

Use This

Set Autot On

This will help

Thanks..

[rsuri]

set autotrace on;

[akhorram]

Thanks you very much guys