rac 并行执行技术.pdfVIP

RAC: Administering Parallel Execution By Riyaj Shamsudeen ©OraInternals Riyaj Shamsudeen Who am I?   19 years using Oracle products/DBA   OakTable member   Oracle ACE Director   Certified DBA versions 7.0,7.3,8,8i,9i 10g   Specializes in RAC, performance tuning, Internals and E-business suite   Chief DBA with OraInternals   Co-author of “Expert Oracle Practices” ‘2009   Co-author of “Pro Oracle SQL” ‘2010   Email: rshamsud@   Blog :   URL: ©OraInternals Riyaj Shamsudeen 2 Parallel Execution   Parallel query uses PX slave processes to perform work.   A slave set perform specific task at a point in execution plan. After the completion of a task, slave set can be reassigned to perform a different task.   Proper configuration of private interconnect and optimal execution plan is an essential step in scaling the PX operation.   Placement of PX slaves can be controlled by Services or parallel_instance_group configuration. ©OraInternals Riyaj Shamsudeen 3 Example create index mut_t1 on mut (transaction_id) parallel (degree 8) nologging; | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib | | 0 | CREATE INDEX STATEMENT | | | | 117K(100)| | | | | | 1 | PX COORDINATOR | | | | | | | | | | 2 | PX SEND QC (ORDER) | :TQ10001 | 13M| 166M| | | Q1,01 | P-S | QC (ORDER) | | 3 | INDEX BUILD NON UNIQUE| MUT_T1 | | | | | Q1,01 | PCWP | | | 4 | SORT CREATE INDEX | | 13M| 166M| | |