Database Administration (MOSC)

MOSC Banner

about some question about v$session_wait

edited May 27, 2010 1:24AM in Database Administration (MOSC) 2 commentsAnswered
 about some question about v$session_wait

i did two test, seem two test result are different  when i view v$session_wait.

first: open twn session , one session is  used for test , the other session is used  for monitor

######one

i do a select stament in the session twice

select * from sys.source$;

select * from sys.source$;

i view the v$session_wait show the sid ' wait event is   SQL*Net message from client

####two

then i did a select statment in the sesion

insert into t select * from sys.source$;

i view the v$session_wait show the sid ' wait event is  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center