How to find the detail of very quick session
Hi,
One of my developer is executing few quick sessions(30,45,60 seconds...... ) and wants me to provide the session details like :
1. How much resource that particular session has used?
2. Explain plan of the statements used in session ?
I can not find thses details in toad as the sessions are very quick and he can not see the explain plan and other details as he is running it from client software.
I know that I can trace the session but is there any other way ?
Is thare any way I can see the log of a quick partiular session based upon the session_id(SID) of the session ?
One of my developer is executing few quick sessions(30,45,60 seconds...... ) and wants me to provide the session details like :
1. How much resource that particular session has used?
2. Explain plan of the statements used in session ?
I can not find thses details in toad as the sessions are very quick and he can not see the explain plan and other details as he is running it from client software.
I know that I can trace the session but is there any other way ?
Is thare any way I can see the log of a quick partiular session based upon the session_id(SID) of the session ?
0