Subscribe For Free Updates
PaidVerts

Sunday, May 24, 2015

Optimise the memory usage of Oracle DBMS on windows plateform

When installing Oracle on Windows, the oracle DBMS 's services will be configured as automatic.

That means that whenever the computer boots, these services are started even when you are not using Oracle.

To solve this problem, you should go through these steps:

Step 1: Open configuration panel

Step 2: Open Administration tools

Step 3 : Open Services

Step 4 : Search Oracle services which are started

For Oracle 10g: the names of the services contains the string "ORCL"
For Oracle 11g: the names of the services contains the string "XE"


Step 5: Make those services as manual

Right click on the service name then you click on properties


The screen below will appear.
You change the status type to Manual and you click on apply.
Then you click on OK.


Step 6: Whenever you want to use Oracle
For Oracle 10g: start the services "OracleServiceOrcl" and the Oracle listener that contains the string "Orcl"
For Oracle 11g: start the services "OracleServiceXE" and the Oracle listener that contains the string "XE"

To start a service, right click on it and choose start.













    0 comments:

    Post a Comment

    Join us on Facebook

    Please wait..10 Seconds

     
    how to program in JAVA core java tutorial java developer jobs java variables for beginners best java books