Solution : https://service.sap.com/sap/support/notes/745639 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette SAP Note détaille la gestion des enqueues Oracle en les comparant aux enqueues R/3, et propose des solutions détaillées pour des problèmes courants tels que les attentes de verrouillage et l'erreur ORA-00054. Elle offre un aperçu complet des types d'enqueues, incluant les enqueues de transaction (TX), DML (TM) et des enqueues système telles que les enqueues de transaction d'espace (ST) et de fichier de contrôle (CF). Les paramètres Oracle clés affectant les enqueues, tels que DML_LOCKS et ENQUEUE_RESOURCES, sont abordés. Des conseils pratiques sur la manière de suivre et de gérer les enqueues via divers outils comme V$SESSION_WAIT et DB pump buttons batteries analogous models defined by dangerous WMS_LOCK.REQUEST sont également fournis, ainsi que des perspectives sur la gestion des différents modes de demande d'enqueues et la résolution des événements d'attente typiques.
Mots Clés :
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
Notes associées :
| 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 |