Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NULL EVENT

600574May 24 2009 — edited May 25 2009
Hi,

I am running a query and its taking a long time , when I query for session with following SQL

select sample_time, event, wait_time,BLOCKING_SESSION
from v$active_session_history t
where session_id = 20
and session_serial# = 201;

I could see the first event as "NULL EVENT" , the subsequent rows doesn't show anything in Event column. Seems like my session is hanging, any clues on what might be the problem. I am running oracle 10.2.0.3 on UNIX.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2009
Added on May 24 2009
#general-database-discussions
3 comments
1,537 views