This content has been marked as final. Show 1 reply
davidredden1973 wrote:"It depends."
I was wondering if there is a way to show all network_ids that are accessing the oracle database in my group.
All users connect using the same username of adhoc
So I know there is a select * from all_users where username = 'adhoc'
just wondering if there is another sql that can be ran to display all network ids on our network who are accessing Oracle database with that adhoc username.
There are a number of ways to access over a network. Look at the columns in [url http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_2101.htm#REFRN30186]v$process and [url http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3016.htm#REFRN30223]v$session.
I've seen some setups where I could figure it out by looking up some of that information, then grepping for it in netstat -a output. The listener log is helpful sometimes. Some application servers have their own utilities for this.
So what OS is this, anyways?