A good introduction article for describing oracle database 11g new process and features.
[url=http://www.oraclepoint.com]TidR5fbtMOraclePointQtLcnmgru[/url]
Please see below for new processes introduced by Oracle Database 11g.
[url=http://www.oraclepoint.com]pumZJXsZqOraclePointTkU453WLw[/url]
Process
| Name [url=http://www.oraclepoint.com]2mfE4OPV3OraclePoint23jmiUO8d[/url]
| Description [url=http://www.oraclepoint.com]mq4S0em4YOraclePointfPjRHMxLG[/url]
|
ACMS
| Atomic Controlfile to Memory Server [url=http://www.oraclepoint.com]Cab5SUd53OraclePointxJ1RvgKEg[/url]
| Onlyapplicable in a RAC instance. When a distributed SGA update is issued,ACMS ensures that the update happens on all instances. If the updatefails on one, this process also rolls it back on all instances. Thinkof ACMS as a two-phase commit coordinator process for SGA updates in aRAC cluster. [url=http://www.oraclepoint.com]oraCMpmewOraclePointzS96VZXPr[/url]
|
DBRM
| Database Resource Manager [url=http://www.oraclepoint.com]rtmkhwayiOraclePoint80menU5qh[/url]
| Implements the resource plans and other resource manager-related tasks [url=http://www.oraclepoint.com]jTCWIUUEpOraclePointuc6bJpEtM[/url]
|
DIA0
| Diagnosibility process 0 [url=http://www.oraclepoint.com]1KBZHACloOraclePointWgV5Gp7cy[/url]
| Detectshang situations and deadlocks. In the future there may be more than oneprocess, so the name is set as diag0. The other processes, if they comein the future will be named dia1, dia2, etc. [url=http://www.oraclepoint.com]Qx37hU30eOraclePointiEOu6YwUg[/url]
|
DIAG
| Diagnosibility process [url=http://www.oraclepoint.com]xWIctoynuOraclePointdjNR1BJxj[/url]
| Performs the diagnostics, dumps trace files, if necessary and performs global oradebug commands [url=http://www.oraclepoint.com]epj0NnN9jOraclePointmv4JjPRB0[/url]
|
FBDA
| Flashback Data Archiver [url=http://www.oraclepoint.com]7zmrSL6jCOraclePoint8tzgOfGNt[/url]
| Oracle Database 11ghas a new “Flashback Archives” to write the changes made to a table(refer to “Transactions Management” installment of this series). Thisprocess writes the flashback archives. [url=http://www.oraclepoint.com]tbsTEdMNCOraclePointcfEbc4DJM[/url]
|
GTX0
| Global Transaction Process 0 [url=http://www.oraclepoint.com]PFvSCfHjtOraclePointnp7WZXEsb[/url]
| Ina RAC cluster, Oracle Database now provides improved handling of XAtransactions. This process coordinates XA transactions. If the databaseload on XA grows, more processes are automatically created with namesGTX1, GTX2, upto GTXJ. [url=http://www.oraclepoint.com]i5plXKpymOraclePointj3wvI3ha5[/url]
|
KATE
| Konductor (Conductor) of ASM Temporary Errands [url=http://www.oraclepoint.com]CidvLIshhOraclePointGmQhLKNxh[/url]
| Undoubtedly the grandest name of all new processes. This is seen on ASM instances; not the database. (Refer to the installment on this series on ASM for the new feature Fast Disk Resync.) When a disk goes offline, thisprocess performs a proxy I/O on its behalf to an ASM metafile. [url=http://www.oraclepoint.com]XdWACPxyXOraclePointpVykYWDKh[/url]
|
MARK
| Mark AU for Resync Koordinator (coordinator) [url=http://www.oraclepoint.com]M3Fu9sAg4OraclePointLtqtHJFIM[/url]
| Refer to the ASM installmentfor more details on the resiliency of the ASM diskgroups. When a diskfails, it becomes offline, causing writes to miss. In that case, thisprocess marks the ASM allocation units (AUs) as stale. When the diskcomes online, the stale segments will be refreshed. [url=http://www.oraclepoint.com]V7AslWhLvOraclePoint4P6bbyhMx[/url]
|
SMCO
| Space Manager [url=http://www.oraclepoint.com]PMUJYE1HLOraclePointANUNiQOR3[/url]
| SMCOis the master space management process that dynamically allocates anddeallocates space. It spawns slave processes Wnnn to implement thetasks. [url=http://www.oraclepoint.com]kyEWrURJwOraclePointGr948KNGi[/url]
|
VKTM
| Virtual Keeper of TiMe process [url=http://www.oraclepoint.com]R8qd94yLbOraclePointFZs8AgCWO[/url]
| Provides a wall clock equivalent (with 1 second updates). When running at elevated priority, it provides a 20 ms update. [url=http://www.oraclepoint.com]WoYIuFGnCOraclePointR2J1JGgnF[/url]
|
W000
| Space Management Worker Processes [url=http://www.oraclepoint.com]ZbQ2gpjeqOraclePointGgCV4qtBa[/url]
| Implements the instructions received from SMCO. More processes are spawned as needed with names like W000, W001 and so on. [url=http://www.oraclepoint.com]yIE2Z6AQFOraclePointHxsMMJdEq[/url]
|
This article also talks about:
- "Colored SQL"-- Identifying a specific SQL statement captured in AWR snapshot
- OLTP table compression
- Export / Import hanging by thread
- Incrementally Updated Global Statistics
- Truly Online Index Rebuild
Please see complete article at attachment.
[url=http://www.oraclepoint.com]JoKzuq2FjOraclePointizl9otDfJ[/url]