Results 1 to 6 of 6

Thread: Finding database name and PID

  1. #1
    Join Date
    Nov 2009
    Posts
    56

    Finding database name and PID

    hello !

    I am running with oracle and as well as windows software and need to know the name of database from Windows. I am running with two databases and my task manager is showing 90% of the cpu time is being consumed by which database.Have you any idea about this matter please provide me the exact solution because my computer system is going down just because of these complexities.

    Thanks.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Finding Process ID in windows

    Finding Process ID in windows :

    Each process running within Microsoft Windows operating system is assigned with a unique Identification.There are so many methods to get the PID for a given application:By Task Manager, tasklist command, TList utility and the debugger.

    You can access the task manager with very simple way using CTRL+ALT+DELETE.There would be processes tab which explores the different processes currently running.The Tlist Command is used within the prompt and will explore all the current processes in the list with their respective ids.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Finding database name and PID

    Finding database name and PID :

    If your system is going very just because of oracle database execution.you have to investigate about the processes and services related to oracle database.There are so many services always run with oracle database.

    If you want to tune your computer system.you need to close these services when not in use.These services consumes so much space of CPU.These services are automatically started when you start your computer system.

    In the list of services,Includes oracle agent,Oracle database,Listener utility,oracle recovery manager are some services which consumes so much space.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Changing status of services

    Changing status of services

    You can change the status of services using the properties of their own.The processes are automatically started when you start your computer system.

    To close these services,You have to follow the following steps :

    1- GO to control panel and select the Administrative tools.
    2- Open the services icon contained in administrative tools folder.
    3- Search for the name of services which is start with Oracle and select with right click.
    4- select the properties of particular services and make it manual or disable according to your desire.
    5- In the case of manual, the services should be stopped properly with the given button of STOP.
    6- Click on APPLY button and make the changes permanent.

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Finding database name

    Finding database name :

    If you want to find out the name of the database which causes the performance of computer system.Select the services method and disable the second database refresh changes permanent and move to the windows prompt and login into first database and shut it down.

    Now check the oracle processes in task manager how much it is consuming the CPU Usage.Check the percentage of CPU usage and follow the same procedure to check the CPU usage for first database after closing the second database.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,393

    Oracle.exe memory usage

    Oracle.exe memory usage :

    The oracle.exe consumes so much space of memory,in this case you need to follow these instructions to save the CPU usage.

    • Maintain the Performance specifications under Control Panel -> System -> Advanced ->
    • Settings -> Advanced.
    • Adjust the "Processor scheduling" into "Background services" over "Programs".
    • Adjust "Memory usage" into "Programs" over the " machine cache".
    • Adjust Virtual memory to 1-4 times the size of RAM. If possible.
    Last edited by Reegan; 16-02-2010 at 06:50 PM.

Similar Threads

  1. Need help finding a UPS for my current rig
    By Danvir in forum Hardware Peripherals
    Replies: 5
    Last Post: 21-11-2010, 02:28 AM
  2. Finding the version of database
    By Garlands in forum Software Development
    Replies: 4
    Last Post: 08-02-2010, 10:42 PM
  3. Creating Database link in database
    By Lachlann in forum Software Development
    Replies: 3
    Last Post: 28-01-2010, 01:17 PM
  4. convert filemaker pro database to access database
    By Czack in forum MS Office Support
    Replies: 3
    Last Post: 15-04-2007, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,629,455.54388 seconds with 17 queries