Note 618868 - FAQ: Oracle performance

Component : Oracle - Oracle Performance Problems

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

Key words :

check whether, performance problems, information about, database performance, physical reads, oracle performance, table buffering, logical reads, database accesses, whether there, database server, insert statements, round, reads direct, performance analysis, performance optimization, detail analysis, certain cases, problems, unusable indexes, direct reads, insert performance, indexes, network problems, large number, managed tablespaces, status unusable, dictionary managed, parallel query, check, trace transaction, system event, about oracle, oracle parameter, structure validation, buffer quality, determine whether, significant differences, access times, significantly higher, gather stats, normal operation, ensure, queue events, system performance, oracle, statements

Related Notes :

1854524Performance degradation over time for Oracle >=11.2.0.3, AIX
1672954Oracle 11g: Usage of hugepages on Linux
1431798Oracle 11.2.0: Database Parameter Settings
1269911FAQ: Chained Rows
1266771SRM 7.0 Performance Guide
1223360Composite SAP Note: Performance optimization during import
1169088SRM 6.0 Performance Guide
1164043DBSL (Oracle): Maximum buffer size for array operations
1137346Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4
1075118SAP on HP-UX: FAQ
1047734Unrealistic Oracle performance values on Windows/AMD
1037755Performance problems with ASSM tablespaces
1036194OS timers are not synchronized
1020260Delivery of Oracle statistics (Oracle 10g, 11g)
964344FAQ: Oracle mutexes
950658Huge values shown in READTIM, WRITETIM of V$FILESTAT
912918Massive UNDO/REDO generation when you use ASSM
892296Enhancements in update statistics in BRCONNECT 7.00/7.10
881083Blocking factors on Oracle-based systems
871735Current patch set for Oracle 10.2.0
871455Poor performance when accessing DBA and V$ views
871096Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2
869521Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE
869006Composite SAP note: ORA-04031
868590Performance issue with SUN/Oracle 8.1.7 client
857973Deleting clients efficiently using Oracle
853576Oracle 10g: Performance analysis w/ ASH and Oracle Advisors
842240FAQ: Backup strategy of large and highly-available databases
838725Oracle dictionary statistics and system statistics
832343FAQ: Clustering factor
830576Parameter recommendations for Oracle 10g
825653Oracle: Common misconceptions
806554FAQ: I/O-intensive database operations
805934FAQ: Database time
797629FAQ: Oracle histograms
793113FAQ: Oracle I/O configuration
789011FAQ: Oracle memory areas
787533Bad performance/ system lockup due to enqueue waits
771929FAQ: Index fragmentation
767414FAQ: Oracle latches
766827Composite SAP note: Performance SCM 4.0
766349FAQ: Oracle SQL optimization
762808FAQ: Keep pool
750205High memory usage with AIX5.2/5.3 and Oracle9.2
745639FAQ: Oracle enqueues
723894Brconnect: Create the statistics for all columns.
717484FAQs: Oracle statspack
716000Database monitor for Oracle 9/Oracle RAC SAP Release 6.X
712624High CPU consumption by Oracle
706478Preventing Basis tables from increasing considerably
705608Database monitor for Oracle 9/Oracle RAC
703035Objects with ERROR status in buffer
689818High Paging Rates during Backup
659946FAQ: Temporary tablespaces
651060FAQ: Oracle Parallel Execution
650631Composite SAP note: ORA-01003
648203Database objects with INVALID status
619188FAQ: Oracle wait events
618861Composite SAP Note: ORA-01013
596420System standstill during deadlock (ORA-60)
592393FAQ: Oracle
588668FAQ: Database statistics
582427Error due to inconsistent Oracle DDIC
579462Runtime parameter of the statistics collection
567745Composite note BW 3.x performance: DB-specific setting
562403FAQ: Oracle Net
558746Better Oracle Data Dictionary BW Performance
539921Current patch set for Oracle 9.2.0
521264Hang situations
500340FAQ: LOBS
421795Report SAP_ANALYZE_ALL_INFOCUBES
378509Oracle DB parameter setting for APO
354080Note collection for Oracle performance problems
332677Rebuilding fragmented indexes
192658Setting parameters for BW systems
184905Collective note Performance BW 2.0
176754Problems with CBO and RBO
160063Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9
138639Poor DML performance with Oracle DDIC statistics
135048Long runtimes statements w/ ROWNUM <= condition
132861CBO: Statistics creation with SAPDBA or BRCONNECT
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
122718CBO: Tables with special treatment
47239Behavior of the table buffers
20071Permanent lock after connection termination
4162Missing "end backup"