Oracle Database Discussions

Hello Experts,

I was going through one of the article in oracle magazine about Tuning.

It deals with a very basic situation. An user has open two separate session of a schema and performed below tasks

1> In first session user executes a update statement.

update emp set ename='ABC' where empno=7400;

User does not commit it.

2> In second session user executes the same update statement.



Now in the first session user has executed the following query.

select sid,state,event from v$session where username='SCOTT';

SID STATE EVENT
---------- ------------------- ----------------------------------------------------------------
21 WAITING enq: TX - row lock contention
147 WAITED SHORT TIME SQL*Net message to client


I have observed in the magazine it is written that the state of the session 1 (SID 21) is WAITED KNOWN TIME.
But when i executes the same query is is coming as WAITED SHORT TIME.

In next paragraph of the article it is written that

--quote

On the other hand, the state of session 2832, “WAITED KNOWN TIME,” means that it is working—not waiting—right now.

--Unquote

My question is when the state of the session is WAITED SHORT TIME does it also mean it's working,not waiting right now.


My DB information is written below

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


Regards
Rajat

Edited by: Rajat on Apr 14, 2013 8:10 PM