Errors per user session!

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

    Errors per user session!

    Hi All,

    I would like to track errors per user session. What I am looking at
    some kind of dynamic performance view that list the errors in a
    particular user session.
    I looked into Oracle documnetations but could not find any V$ listing
    view errors
    Any alternate solution?
    What I am trying to do is able to see the errors which Oracle server
    throw to client without being on client machine.

    Any help would be appreciated.



    Thanks


    Rao
    Tags: None
    • Mark D Powell
      #2
      Re: Errors per user session!

      faheemrao@yahoo .com (FaheemRao) wrote in message news:<43b58913. 0309230715.9f49 49b@posting.goo gle.com>...
      Hi All,
      >
      I would like to track errors per user session. What I am looking at
      some kind of dynamic performance view that list the errors in a
      particular user session.
      I looked into Oracle documnetations but could not find any V$ listing
      view errors
      Any alternate solution?
      What I am trying to do is able to see the errors which Oracle server
      throw to client without being on client machine.
      >
      Any help would be appreciated.
      >
      Thanks
      >
      Rao
      The only realistic way to capture this is to modify the client code to
      store to a table error codes and messages returned to the client when
      they occur. Care should be given to conditions which indicate "no
      listener", "not connected to Oracle", etc....

      HTH -- Mark D Powell --

        Comment

        • Stephen_CA
          #3
          Re: Errors per user session!

          faheemrao@yahoo .com (FaheemRao) wrote in message news:<43b58913. 0309230715.9f49 49b@posting.goo gle.com>...
          Hi All,
          >
          I would like to track errors per user session. What I am looking at
          some kind of dynamic performance view that list the errors in a
          particular user session.
          I looked into Oracle documnetations but could not find any V$ listing
          view errors
          Any alternate solution?
          What I am trying to do is able to see the errors which Oracle server
          throw to client without being on client machine.
          >
          Any help would be appreciated.
          >
          >
          >
          Thanks
          >
          >
          Rao
          Hi,

          I know you're looking for errors per session, but perhaps you can make
          some use of the DBA_ERRORS view? It lists error information by OWNER
          (i.e. user) although not by session.

          Hope this helps,

          Steve

            Comment

            Previous template Next
            Working...