SAP Note 745639 - FAQ: Oracle enqueues

Component : Oracle - Backoffice Service Delivery

Solution : https://service.sap.com/sap/support/notes/745639 (SAP Service marketplace login required)

Key words :
FAQ, lock wait

Related Notes :

1725432CL_CTMENU_LOAD_TEXTS and invalid program name
1702617Timeout or deadlock on table DDFTX when generating screens
1614802Mass activation hangs during INSERT in the table DDFTX
1608273Deadlock on D342L and D345T
1231267Code optimization for Master Data operations
1227227SQL statement runs endlessly or times out (kkompr)
116624210g: "enq: HW contention" waits for LOB Inserts in ASSM TBS
1086678D345T updates
1028360Locks on DYNPLOAD during parallel execution of reports
1013912FAQ: Oracle BW performance
949737Generating screen & CUA loads in own LUW
935817SE14: INITRANS storage parameter not configurable (Basis 640
923099Locking background processes SMON in RAC environment
915242FAQ: Reverse key indexes
910389FAQ: Oracle Segment Shrinking
909484SE14: Storage parameter INITRANS is configurable (Basis 620)
867681ALTER DATABASE TEMPFILE DROP hangs
843042Oracle: Database locks for SELECT FOR UPDATE
840553BW Oracle: TRUNCATE table slower than DELETE
831234Deadlock ORA-00060 during parallel loading into BW ODS
825653Oracle: Common misconceptions
821687FAQ: Space utilization and fragmentation in Oracle
793113FAQ: Oracle I/O configuration
787533Bad performance/ system lockup due to enqueue waits
767414FAQ: Oracle latches
766349FAQ: Oracle SQL optimization
750033INITRANS parameter for InfoCube secondary indexes
712624High CPU consumption by Oracle
706478Preventing Basis tables from increasing considerably
682926Composite SAP note: Problems with "create/rebuild index"
678501System stoppage, locks on table NRIV
666061FAQ: Database objects, segments and extents
659946FAQ: Temporary tablespaces
658744Composite SAP Note: ORA-00600 [2103]
651060FAQ: Oracle Parallel Execution
619188FAQ: Oracle wait events
618868FAQ: Oracle performance
596748Simultaneous generation of selection screens in background
521264Hang situations
412767Lockwait for parallel extraction from Profitability Analysis
395997DB block on DDFTX after language transport action
359835Design of the temporary tablespace in the BW System
356208Locks on D010SINF after transport
330165problems due to locks on D020L and D020LINF
214995Oracle locally managed tablespaces in the SAP environment
183648SAPMSSY2: long runtime in background process
164925Storage parameter of tablespace PSAPTEMP
150353In batch mode impairment by DB locks on D020L
84348Oracle deadlocks, ORA-00060
79341Checkpoint not complete
78595ORA1575 timeout waiting for space management res.
36795Locks on D020L / D020LINF in batch processing
20071Permanent lock after connection termination