RE: HIstory of sessions
From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 21 Jan 2010 09:21:59 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112F273ABF_at_ONEWS06.oneneck.corp>
If you have 10g+ and a diagnostics pack license, then you can check dba_hist_active_sess_history for sessions that were active, but I'm not sure if it shows an accurate history of all sessions ever connected. If you have "audit session" enabled, then you can check the dba_audit_session view.
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
Date: Thu, 21 Jan 2010 09:21:59 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E112F273ABF_at_ONEWS06.oneneck.corp>
If you have 10g+ and a diagnostics pack license, then you can check dba_hist_active_sess_history for sessions that were active, but I'm not sure if it shows an accurate history of all sessions ever connected. If you have "audit session" enabled, then you can check the dba_audit_session view.
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 21 2010 - 10:21:59 CST