After successfully installing the Oracle 11g database, you will find that your computer is running slower, that your computer is running faster with a lower-profile PC or even a very card-enabled Oracle service. So, how do you do it specifically?
After successfully installing Oracle 11g in accordance with the method of Oracle 11g R2 installation in Win7 64-bit environment, a total of 7 services are Oracle ORCL VSS Writer SERVICE,ORACLEDBCONSOLEORCL, respectively, ORACLEJOBSCHEDULERORCL,
Oraclemtsrecoveryservice,oracleoradb11g_home1clragent,oracleoradb11g_home1tnslistener,oracleserviceorcl. Among them ORACLEDBCONSOLEORCL,
The ORACLEMTSRECOVERYSERVICE,ORACLEORADB11G_HOME1TNSLISTENER,ORACLESERVICEORCL is automatically started by default, ORACLEJOBSCHEDULERORCL is automatically disabled by default, and the rest defaults to manual operation. Assuming your global database name is ORCL, your Oracle service should be the same as above. As shown in the following:
The meanings of these seven services are:
Oracle ORCL VSS Writer service:oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images of storage infrastructure (such as disks, arrays, etc.), i.e. mapped copies ( Shadow copy). It can create a mapped copy on multiple volumes or on a single volume without affecting the system's system performance. (must not be started)
Oracledbconsoleorcl:oracle Database Console service, ORCL is the instance identity of Oracle, and the default instance is ORCL. you need to start this service when you run Enterprise Manager (Enterprise Management Manager OEM) . (must not be started)
Oraclejobschedulerorcl:oracle Job scheduling (timer) service, ORCL is the Oracle instance identity. (must not be started)
Oraclemtsrecoveryservice: Service-side control. The service allows the database to act as a resource manager for transactions in a Microsoft Transaction Server MTS, com/com+ object, and distributed environment. (must not be started)
Oracleoradb11g_home1clragent:oracle part of the database. Net Extension Service. (must not be started)
Oracleoradb11g_home1tnslistener: Listener service, the service is only needed when the database requires remote access. (not required to start, detailed below).
ORACLESERVICEORCL: The database service (DB instance), which is the Oracle Core service, is the basis for database startup, and only if the service is started, the Oracle database can start normally. (Must Start)
So what are the services that need to be started at the time of development?
For beginners, if you only use Oracle's own sql*plus, just start ORACLESERVICEORCL, and if you use a third-party tool such as PL/SQL developer, Oracleoradb11g_ Home1tnslistener service is also to be opened. ORACLEDBCONSOLEORCL is a web-based EM must be turned on, and the rest of the service is seldom used.
Note: ORCL is the database instance name, the default database is ORCL, you can create other, that is, the oracleservice+ database name.