SAP Note 619188 - FAQ: Oracle wait events

Component : Oracle - Backoffice Service Delivery

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

Key words :
FAQ, queue event, event, queue events, events

Related Notes :

1611285FRP sequence 1: Performance improvement for DIF access
1438410SQL: Script collection for Oracle
1176846DBA Cockpit: Adjusting the Oracle idle events
1121838SELECT on partition hangs if a shrink compact is running
1044758EM repository operations with EMCA and Oracle quiesce
1017970DBMS_ADVISOR may result in deadlock
1013049FAQ: Oracle Data Pump
971261Oracle 9.2 / 10.2: Hanging queries with STAR_TRANSFORMATION
964619RMAN: Incremental backups with Block Change Tracking
964344FAQ: Oracle mutexes
963894SMON blocks processes in rollback of large transactions
904188Locks when you execute Index Rebuilds Online in parallel
8940789.2.0.7: Long waits for KSU PROCESS ALLOC LATCH YIELD
875477Avoiding long runtimes with BEGIN BACKUP
869006Composite SAP note: ORA-04031
857998Number range buffering for DIM IDs and SIDs
857973Deleting clients efficiently using Oracle
853576Oracle 10g: Performance analysis w/ ASH and Oracle Advisors
853084Transferring temporary /BI0/06 tables to another tablespace
846364Parse of star query may spin
842240FAQ: Backup strategy of large and highly-available databases
840553BW Oracle: TRUNCATE table slower than DELETE
830576Parameter recommendations for Oracle 10g
825653Oracle: Common misconceptions
806554FAQ: I/O-intensive database operations
805934FAQ: Database time
793113FAQ: Oracle I/O configuration
789011FAQ: Oracle memory areas
768308Deadlock with row cache locks and library cache locks
767414FAQ: Oracle latches
766827Composite SAP note: Performance SCM 4.0
766349FAQ: Oracle SQL optimization
758989Poor performance with TRUNCATEs
745639FAQ: Oracle enqueues
738641Change run/rollup stops with simultaneous COALESCE
712624High CPU consumption by Oracle
659946FAQ: Temporary tablespaces
651060FAQ: Oracle Parallel Execution
649876Library Cache Pin Contention after Upg. to 9.2.0.2 - 9.2.0.4
626172Performance problems with Outer Join queries in Oracle 9.2
620803Oracle 9i: Automatic Segment Space Management
618868FAQ: Oracle performance
613872Oracle traces with ORADEBUG
610357Oracle hang with event DB_FILE_SCATTERED_READ
607415RSORAVSE displays poor averages
596748Simultaneous generation of selection screens in background
596420System standstill during deadlock (ORA-60)
582427Error due to inconsistent Oracle DDIC
564446Scheduling of background job BTCH_RSORAVSH
563359Performance optimization for tables with LOB columns
562403FAQ: Oracle Net
556764Upgrade hangs in phase ACT_<REL>
549298RSORAVSH: LOAD_PROGRAM_NOT FOUND during the run of RSCOLL00
541538FAQ: Reorganization
521230FAQ: Client software 9i or lower on UNIX
500235Network Diagnosis with NIPING
488583Database hangs: Waits for cache buffer chain latch
449136"cache buffers chains" latch contention on 8.1
400698ORA-4031 Memory leak on Oracle 8.1.7
376905Long parsing times and Library Cache Locks
359835Design of the temporary tablespace in the BW System
328822AIX kernel extension for Oracle
198752TCP delay problem under Oracle 8.1.x
180430Installing the ORACLE client software for UNIX
164925Storage parameter of tablespace PSAPTEMP
79341Checkpoint not complete
72638Performance problems with SQL*Net
20071Permanent lock after connection termination
391Archiver stuck