How To Verify Number Of Process Oracle
Oracle Process Number
FYI:Normally, the number of processes should be set to 2 x number of sessions. This is because each 'session' could require two processes to work properly (or possibly more with parallel executions set).So, 170 sessions should really have 340 processes set.If this does not fix it then PLEASE locate the actual alert log for your database, and check that out for unusual error messages for the times the users are seeing their errors, or getting blocked!If your database is called 'PROD' then that should appear in the path somewhere. Here is the way to be sure: From the SQLPLUS as dba prompt:SQL show parameter backgrounddumpdestThat command output should show a path where the alert log (and Oracle internal trace files) are created. You are looking fie a file beginning with 'alert' and it should contain the name of the database (e.g.
Before stating the DB is the culprit, I think an end to end analysis should be done.I'm specially thinking of WEB sessions, Listener limitations, even kernel limitations could be playing a role here.It would help enormously to know the whole environment, I'm thinking of an 'ALL IN ONE' server as opposed to multi-tiered environment where several dedicated servers come to play.As well, since the original poster was up till now not able to give us extract of DB alert log during critical period, I think a thorough analysis has to be done beforehand.
How To Verify Number Of Process Oracle In Windows 10
Table F-1 Background Processes NameExpanded NameShort DescriptionLong DescriptionExternal PropertiesABMRAuto BMR Background ProcessCoordinates execution of tasks such as filtering duplicate block media recovery requests and performing flood controlWhen a process submits a block media recovery request to ABMR, it dynamically spawns slave processes (BMR n) to perform the recovery. ABMR and BMR n terminate after being idle for a long time.See Also:Database instancesACFSASM Cluster File System CSS ProcessTracks the cluster membership in CSS and informs the file system driver of membership changesACFS delivers CSS membership changes to the Oracle cluster file system. These membership changes are required for the file system to maintain file system consistency within the cluster.Oracle ASM instances, Oracle RACACMSAtomic Control File to Memory Service ProcessCoordinates consistent updates to a control file resource with its SGA counterpart on all instances in an Oracle RAC environmentThe ACMS process works with a coordinating caller to ensure that an operation is executed on every instance in Oracle RAC despite failures. ACMS is the process in which a distributed operation is called. As a result, this process can exhibit a variety of behaviors. PMAN monitors, spawns, and stops the following as needed:.dispatcher and shared server processes.connection broker and pooled server processes for database resident connection pools.job queue processes.restartable background processesDatabase instances, Oracle ASM instances, Oracle ASM Proxy instancesPMONProcess MonitorScans for dead processes and coordinates cleanupPMON periodically scans all processes to find any that have died abnormally.
PMON is then responsible for coordinating cleanup performed by the CLMN process and the CL nn slaves.See Also: andDatabase instances, Oracle ASM instances, Oracle ASM Proxy instancesP nnnParallel Query Slave ProcessPerform parallel execution of a SQL statement (query, DML, or DDL)Parallel Query has two components: a foreground process that acts as query coordinator and a set of parallel slaves (P nnn) that are background processes. These background processes are spawned or reused during the start of a parallel statement. They receive and perform units of work sent from the query coordinator.The maximum number of P nnn processes is controlled by the initialization parameter PARALLELMAXSERVERS. Slave processes are numbered from 0 to the PARALLELMAXSERVERS setting. If the query is a GV$ query, then these background processes are numbered backward, starting from PPA7.Database instances, Oracle ASM instancesPR nnParallel Recovery ProcessPerforms tasks assigned by the coordinator process performing parallel recoveryPR nn serves as a slave process for the coordinator process performing parallel media recovery and carries out tasks assigned by the coordinator.