Create The World With Creativity
 
Welcome, Guest:Log in | Register | Information Center | Languages | Search | Tags | FAQs | Lite
There was a problem with the request. Check your permission or contact with administrator.




Your Ad Here

Grade this thread

Quote Favorites Report
Starter:  Topic: : Oracle 11g New Processes and Features
R.Wang 
5 Stars
 

Info: Moderator Offline Male
From: Not Specified 
Posts: 329  
Digest 0  
Credits: 59
Money: 1746 $OraclePoint
Registered on 2007-04-20
ProfileProfile BuddyBuddy PMPM Reply Reply QuotesQuotes   1 F 
Oracle 11g New Processes and Features



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]





Attachment: (Description of the attachment: Oracle 11g New Processes and Features)index.html (Size:0.16kb, Download times:27)


Tags: share 

2008-10-19 18:21
  Grade this thread



Similar Threads Forum Author Replies Views Last Post
How to Verify Memory Leaks on Unix
Oracle Tools, Utilities & Scripts R.Wang 0 384  2010-05-11 14:59
Duplicating Oracle Database with RMAN on Remote Server
Oracle Case Study R.Wang 0 343  2010-05-10 00:00
How to Change Character Set to UTF8 for Oracle Database?
Oracle Case Study R.Wang 0 386  2010-05-09 23:53
Summary of Oracle database parameters in different versions
Oracle Database Administration R.Wang 2 1676  2009-11-21 01:42
Oracle 10g RAC PPT Collection
Oracle Database Administration myDBA 2 8541  2009-10-23 23:56

  Quick Response
Title:
Content:




Upload: Disable
Username:
Password:
  



Recommend to a friend Print Article Mode





 


Powered by BMForum Powered by BMForum 2007 5.6 RSS Feed  
Processed in 0.10047698 second(s),8 queries  
Top