Skip to Main Content

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!

Whether a Oracle DB user account has logged in the Oracle Database?

776954Mar 31 2011 — edited Apr 1 2011
Hi all,

I'm using Oracle Financials 12.1.2. I'd like to ask, if I haven't turned on the audit trail on Oracle DB, in what ways I can check whether a DB user account has logged in the Oracle Database?

e.g. I've tried this SQL statement but it seems that it is a snapshot instead of full picture of the whole database throughout the whole time about which DB user logged in this database before.

select * from dba_hist_active_sess_history;

Is there any ideas like this can check? Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2011
Added on Mar 31 2011
8 comments
747 views