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!

sql_id field is null in v$active_session_history

613520Dec 13 2007 — edited Dec 14 2007

Hi,

I just installed Oracle XE 10.2.0.1.0 and when I run some simple queries I find that some of the rows in v$active_session_history have null values in sql_id column. Moreover sql_id value in v$sql for the query does not match with the sql_id in v$active_session_history! This I verified using session_id.
Can anyone tell me what could have caused this problem.?

Thank you,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2008

Added on Dec 13 2007

#general-database-discussions

2 comments

395 views