hi
i am a sys user? how can i see the how many users connect to my database?

Views: 52

Reply to This

Replies to This Discussion

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.

thanks 
and iam using oracle 10g

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

Reply to Discussion

RSS

Oracle Jobs in US

¬© 2022   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service