How can I check the Users who are online ?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • B.Dimple
    #1

    How can I check the Users who are online ?

    Hi Oracle Experts,

    How can I check the Users who are online ?

    Is there a table name which contains a list of DB users (e.g in
    SQLServer the table is sysusers) ?

    B.Dimple
    Junior DBA
    Tags: None
    • Ana C. Dent
      #2
      Re: How can I check the Users who are online ?

      B.Dimple wrote:
      Hi Oracle Experts,
      >
      How can I check the Users who are online ?
      >
      Is there a table name which contains a list of DB users (e.g in
      SQLServer the table is sysusers) ?
      >
      B.Dimple
      Junior DBA
      select username, osuser from v$sessions;

        Comment

        • B.Dimple
          #3
          Re: How can I check the Users who are online ?

          "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6MFJb.471 13$BQ5.3860@fed 1read03>...
          B.Dimple wrote:
          Hi Oracle Experts,

          How can I check the Users who are online ?

          Is there a table name which contains a list of DB users (e.g in
          SQLServer the table is sysusers) ?

          B.Dimple
          Junior DBA
          >
          select username, osuser from v$sessions;
          Thanks for the quick response.

          Unfortunately, when I try your suggestion, I get this error message :-
          "ORA-00942: table or view does not exist"

          B.Dimple

            Comment

            • Ana C. Dent
              #4
              Re: How can I check the Users who are online ?

              B.Dimple wrote:
              "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6MFJb.471 13$BQ5.3860@fed 1read03>...
              >
              >>B.Dimple wrote:
              >>
              >>>Hi Oracle Experts,
              >>>
              >>>How can I check the Users who are online ?
              >>>
              >>>Is there a table name which contains a list of DB users (e.g in
              >>>SQLServer the table is sysusers) ?
              >>>
              >>>B.Dimple
              >>>Junior DBA
              >>
              >>select username, osuser from v$sessions;
              >
              >
              Thanks for the quick response.
              >
              Unfortunately, when I try your suggestion, I get this error message :-
              "ORA-00942: table or view does not exist"
              >
              B.Dimple
              select username, osuser from sys.v$session

                Comment

                • FaheemRao
                  #5
                  Re: How can I check the Users who are online ?

                  You have to be login as DBA (system or sys) to query V$session view.


                  Faheem


                  "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6E_Jb.505 38$BQ5.396@fed1 read03>...
                  B.Dimple wrote:
                  "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6MFJb.471 13$BQ5.3860@fed 1read03>...
                  >B.Dimple wrote:
                  >
                  >>Hi Oracle Experts,
                  >>
                  >>How can I check the Users who are online ?
                  >>
                  >>Is there a table name which contains a list of DB users (e.g in
                  >>SQLServer the table is sysusers) ?
                  >>
                  >>B.Dimple
                  >>Junior DBA
                  >
                  >select username, osuser from v$sessions;

                  Thanks for the quick response.

                  Unfortunately, when I try your suggestion, I get this error message :-
                  "ORA-00942: table or view does not exist"

                  B.Dimple
                  >
                  select username, osuser from sys.v$session

                    Comment

                    • B.Dimple
                      #6
                      Re: How can I check the Users who are online ?

                      "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6E_Jb.505 38$BQ5.396@fed1 read03>...
                      B.Dimple wrote:
                      "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6MFJb.471 13$BQ5.3860@fed 1read03>...
                      >B.Dimple wrote:
                      >
                      >>Hi Oracle Experts,
                      >>
                      >>How can I check the Users who are online ?
                      >>
                      >>Is there a table name which contains a list of DB users (e.g in
                      >>SQLServer the table is sysusers) ?
                      >>
                      >>B.Dimple
                      >>Junior DBA
                      >
                      >select username, osuser from v$sessions;

                      Thanks for the quick response.

                      Unfortunately, when I try your suggestion, I get this error message :-
                      "ORA-00942: table or view does not exist"

                      B.Dimple
                      >
                      select username, osuser from sys.v$session
                      Hi Ana,

                      Thanks again.

                      B.Dimple

                        Comment

                        • Ping
                          #7
                          Re: How can I check the Users who are online ?

                          The select_catalog_ role role might have to be granted.

                          Ping

                            Comment

                            • Pawan
                              #8
                              Re: How can I check the Users who are online ?

                              bdimple@myway.c om (B.Dimple) wrote in message news:<eb271e19. 0401051442.a210 4b3@posting.goo gle.com>...
                              "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6E_Jb.505 38$BQ5.396@fed1 read03>...
                              B.Dimple wrote:
                              "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<6MFJb.471 13$BQ5.3860@fed 1read03>...
                              >
                              >>B.Dimple wrote:
                              >>
                              >>>Hi Oracle Experts,
                              >>>
                              >>>How can I check the Users who are online ?
                              >>>
                              >>>Is there a table name which contains a list of DB users (e.g in
                              >>>SQLServer the table is sysusers) ?
                              >>>
                              >>>B.Dimple
                              >>>Junior DBA
                              >>
                              >>select username, osuser from v$sessions;
                              >
                              >
                              Thanks for the quick response.
                              >
                              Unfortunately, when I try your suggestion, I get this error message :-
                              "ORA-00942: table or view does not exist"
                              >
                              B.Dimple
                              select username, osuser from sys.v$session
                              >
                              Hi Ana,
                              >
                              Thanks again.
                              >
                              B.Dimple
                              Dimple,
                              Looks like you do not have SELECT privileges on the V$session table.
                              Ask your DBA to give permissions.

                                Comment

                                Previous template Next
                                Working...