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 in dba_hist_active_sess_history not in dba_hist_sqltext

spur230Oct 7 2014 — edited Oct 8 2014

I am using Oracle 11.2.0.3.

I have a sql_id in dba_hist_active_sess_history . Its sql_opcode =9 and sql_opname ='CREATE INDEX'. I wanted to find sql_text for it in dba_hist_sqlstat, dba_hist_sqlstat or v$sqltext. Am I missing something or it is normal behavior?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2014

Added on Oct 7 2014

#general-database-discussions

2 comments

857 views