Solution : https://service.sap.com/sap/support/notes/745639 (SAP Service marketplace login required)
Summary :
This SAP Note outlines the management of Oracle enqueues, contrasting them with R/3 enqueues, and offers detailed solutions for common issues such as lock waits and error ORA-00054. It provides a comprehensive overview of enqueue types, including transaction (TX), DML (TM), and system enqueues like space transaction (ST) and control file (CF). Key Oracle parameters affecting enqueues, such as DML_LOCKS and ENQUEUE_RESOURCES, are discussed. Practical guidance on how to track and manage enqueues through various tools like V$SESSION_WAIT and DBMS_LOCK.REQUEST is also provided, alongside insights into handling different enqueue request modes and resolving typical wait events.
Key words :
column sqltext word_wrap format a43column reads wrapped format a8column elaperexec wrapped format a8column elatime wrapped format a8column cputime wrapped format a8select, components sv-bo backoffice service delivery priority recommendations / additional info category faq validity, reference-> 22 instance tuning-> wait events-> enqueueoracle10g database reference-> 4 dynamic performance, oracle bw performance 867681 alter database tempfile drop hangs 1231267 code optimization, performance views-> wait event statistics-> enqueue waits header data released, enqueue-dependent lock ids tm enqueue -> id1 = object id, $lockoracle10g database performance tuning guide-> 10 instance tuning, oracle bw performance 949737 generating screen & cua loads, language transport action 214995 oracle locally managed tablespaces, master data operations 1227227 sql statement runs endlessly
Related Notes :
| 1725432 | CL_CTMENU_LOAD_TEXTS and invalid program name |
| 1702617 | Timeout or deadlock on table DDFTX when generating screens |
| 1614802 | Mass activation hangs during INSERT in the table DDFTX |
| 1608273 | Deadlock on D342L and D345T |
| 1231267 | Code optimization for Master Data operations |
| 1227227 | SQL statement runs endlessly or times out (kkompr) |
| 1166242 | 10g: "enq: HW contention" waits for LOB Inserts in ASSM TBS |
| 1086678 | D345T updates |
| 1028360 | Locks on DYNPLOAD during parallel execution of reports |
| 1013912 | FAQ: Oracle BW performance |
| 949737 | Generating screen & CUA loads in own LUW |
| 935817 | SE14: INITRANS storage parameter not configurable (Basis 640 |
| 923099 | Locking background processes SMON in RAC environment |
| 915242 | FAQ: Reverse key indexes |
| 910389 | FAQ: Oracle Segment Shrinking |
| 909484 | SE14: Storage parameter INITRANS is configurable (Basis 620) |
| 867681 | ALTER DATABASE TEMPFILE DROP hangs |
| 843042 | Oracle: Database locks for SELECT FOR UPDATE |
| 840553 | BW Oracle: TRUNCATE table slower than DELETE |
| 831234 | Deadlock ORA-00060 during parallel loading into BW ODS |
| 825653 | Oracle: Common misconceptions |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 793113 | FAQ: Oracle I/O configuration |
| 787533 | Bad performance/ system lockup due to enqueue waits |
| 767414 | FAQ: Oracle latches |
| 766349 | FAQ: Oracle SQL optimization |
| 750033 | INITRANS parameter for InfoCube secondary indexes |
| 712624 | High CPU consumption by Oracle |
| 706478 | Preventing Basis tables from increasing considerably |
| 682926 | Composite SAP note: Problems with "create/rebuild index" |
| 678501 | System stoppage, locks on table NRIV |
| 666061 | FAQ: Database objects, segments and extents |
| 659946 | FAQ: Temporary tablespaces |
| 658744 | Composite SAP Note: ORA-00600 [2103] |
| 651060 | FAQ: Oracle Parallel Execution |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 596748 | Simultaneous generation of selection screens in background |
| 521264 | Hang situations |
| 412767 | Lockwait for parallel extraction from Profitability Analysis |
| 395997 | DB block on DDFTX after language transport action |
| 359835 | Design of the temporary tablespace in the BW System |
| 356208 | Locks on D010SINF after transport |
| 330165 | problems due to locks on D020L and D020LINF |
| 214995 | Oracle locally managed tablespaces in the SAP environment |
| 183648 | SAPMSSY2: long runtime in background process |
| 164925 | Storage parameter of tablespace PSAPTEMP |
| 150353 | In batch mode impairment by DB locks on D020L |
| 84348 | Oracle deadlocks, ORA-00060 |
| 79341 | Checkpoint not complete |
| 78595 | ORA1575 timeout waiting for space management res. |
| 36795 | Locks on D020L / D020LINF in batch processing |
| 20071 | Permanent lock after connection termination |