1 Reply Latest reply: Dec 5, 2012 3:16 PM by 700314 RSS

    FINDING All Network Users accesing Oracle Database using one username

    700314
      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.
        • 1. Re: FINDING All Network Users accesing Oracle Database using one username
          jgarry
          davidredden1973 wrote:
          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.
          "It depends."

          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?