Capturing all SQL_IDs for a SessionId

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 25 Apr 2007 14:30:45 -0700 (PDT)
Message-ID: <660437.75333.qm@web52802.mail.re2.yahoo.com>

Is there a way to capture all the SQL_IDs that a session generated - historically?

I have tried a couple of options like v$open_cursor (it's volatile in the sense that entries exist as long as the session exist).

v$active_session_history - Does only sampling and does not capture every sql.

Pls correct me if my above observations are wrong.

Thanks,
Deepak

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 25 2007 - 16:30:45 CDT