Home » SQL & PL/SQL » Client Tools » wait tab in toad (toad, oracle 10g)
wait tab in toad [message #501672] Wed, 30 March 2011 09:09 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I open the session browser and wait tab

here is the image
/forum/fa/8840/0/


what does the wait_time and second_in_wait indicate , some times I saw wait_time more that 15 seconds what does this mean ?
Re: wait tab in toad [message #501676 is a reply to message #501672] Wed, 30 March 2011 10:16 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TOAD is dumb. It just copies what Oracle shows it. It has no smartness to build a more useful information than the simple query on a view.
If you want to know what it means just look at v$session_wait documentation.

Regards
Michel

[Updated on: Wed, 30 March 2011 10:17]

Report message to a moderator

Previous Topic: @@ confusion
Next Topic: Can you help me to improve my database?
Goto Forum:
  


Current Time: Mon Oct 22 03:08:27 CDT 2018