Finding database name and PID

[Adriana_andros]

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.

[Praetor]

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.

[Katty]

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.

[kelfro]

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.

[Zecho]

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.

[Reegan]

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.