Drill down to what services Oracle 11g must open _oracle

After the Oracle 11g database is successfully installed, you will find that your computer is running slowly, with a lower configuration or even a very card condition, and that you can improve the speed of your computer by banning Oracle services that you do not have to open. So, what exactly should be done?

Following the successful installation of Oracle 11g in the Win7 64-bit environment under the Oracle 11g R2 installation, there are 7 services, Oracle ORCL VSS Writer SERVICE,ORACLEDBCONSOLEORCL, respectively. ORACLEJOBSCHEDULERORCL,

Oraclemtsrecoveryservice,oracleoradb11g_home1clragent,oracleoradb11g_home1tnslistener,oracleserviceorcl. of which ORACLEDBCONSOLEORCL,

The ORACLEMTSRECOVERYSERVICE,ORACLEORADB11G_HOME1TNSLISTENER,ORACLESERVICEORCL is automatically started by default, The ORACLEJOBSCHEDULERORCL is automatically disabled by default, and the remainder is manually operated by default. Assuming your global database name is ORCL, your Oracle service should be the same as above. As shown in the following illustration:

The meanings of these seven services are:

Oracle ORCL VSS Writer service:oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables storage infrastructure (such as disks, arrays, etc.) to create high-fidelity point-in-time images, that is, mapped copies ( Shadow copy). It can create a mapped copy on multiple volumes or on a single volume without affecting the system's ability to do so. (must not be started)

Oracledbconsoleorcl:oracle The Database console service, ORCL is an instance identity of Oracle, and the default instance is ORCL. You need to start this service when you are running Enterprise Manager (Enterprise Manager OEM). (must not be started)

Oraclejobschedulerorcl:oracle Job Scheduler (timer) service, ORCL is an Oracle instance identity. (must not be started)

Oraclemtsrecoveryservice: Server-side control. This service allows the database to act as a resource manager for a Microsoft Transaction Server MTS, com/com+ objects, and transactions under a distributed environment. (must not be started)

Oracleoradb11g_home1clragent:oracle part of the database. Net Extension Service. (must not be started)

Oracleoradb11g_home1tnslistener: The listener service, which is only needed when the database requires remote access. (Does not have to start, below will have detailed explanation).

ORACLESERVICEORCL: Database service (database instance), is the Oracle Core service, which is the foundation of database startup, and the Oracle database can start properly only if the service is started. (Must Start)

So what services do you need to start when you're developing?

For starters, if you only use Oracle's own sql*plus, just start ORACLESERVICEORCL, if you use a third-party tool such as Pl/sql Developer, Oracleoradb11g_ Home1tnslistener service should also be opened. ORACLEDBCONSOLEORCL is going into web-based em must be turned on and the rest of the service is rarely used.

Note: ORCL is the database instance name, the default database is ORCL, you can create other, that is oracleservice+ database name.