Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Unanswered: how to find oracle database name from windows pid

    Hi,
    I am running two databases on one machine.
    one of the databases is taking almost 90% of the cpu time ( as shown by windows task manager).
    However, I am not able to determine which database is the one taking all the resources. Can anyone please tell me how to find that out.

    One way could be if there was some method by which i could find the name of the database using the pid depicted in the task manager corresponding to the oracle.exe process.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Shutdown one of the DBs & see what happens to system load.

  3. #3
    Join Date
    Mar 2004
    Posts
    50
    Originally posted by anacedent
    Shutdown one of the DBs & see what happens to system load.
    the problem is that i cant afford to shutdown any of the database.

Posting Permissions

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