Replies to This Discussion

Permalink Reply by Federico Buerger on June 20, 2013 at 12:33pm

AUDIT CREATE SESSION;
and then query DBA_AUDIT_SESSION. If you are using 11g, this audit is enabled by default. But then, you probably don't know what release you are using.

• ▶ Reply

Permalink Reply by Tomas Nimmo on June 20, 2013 at 12:34pm

thanks 
and iam using oracle 10g

• ▶ Reply

Permalink Reply by Tom Daniel on June 20, 2013 at 12:34pm

query at v$session view where status in('active','inactive';

• ▶ Reply

▶ Reply to Discussion