DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: problem assessing whats happening ???

  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Exclamation problem assessing whats happening ???

    hi! Guys ,

    I ran a proc from the sqlplus prompt yesterday evening at 7:00 p.m...

    Its 4:12 p.m today and "I am trying to assess whether the proc
    completed or not" ... "what is the course of action I should take .."

    When I login through the OEM I find that the session is active ...
    I look at the taskmgr and i do not see the session in the applications
    section
    Normally
    it says " sqlplus not responding" and when it finishes the sqlplus
    session shows up.

    The things that are confusing me ..
    1) the session is not there in taskmgr applications section
    "but there on the desktop"
    the session is there in the processes section of the taskmgr.
    2) the ram for the machine is 1.04gig and the mem usage is showing
    the ram being used is 1.25 gig.
    3) the available ram shows 81MB.
    4) the cpu used shows 51%

    What is happening ??
    What is the course of action I should take ?
    thanks,
    harish

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what does v$session tell you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width