
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved.
MICROSOFT WINDOWS ......................................................................................................... 12-1
UNIX ............................................................................................................................. 12-2
ORACLE TRANSPORTATION MANAGEMENT TOOLS ........................................................ 12-4
CONFIGURATION DATA COLLECTION .......................................................................................... 12-4
PERFORMANCE DATA COLLECTION ............................................................................................. 12-4
WEB SERVER TOOLS ............................................................................................. 12-4
LOAD BALANCERS ............................................................................................................... 12-4
APPLICATION SERVER TOOLS ................................................................................. 12-4
ADMINISTRATION CONSOLE .................................................................................................... 12-4
JVM TOOLS ........................................................................................................ 12-5
CONSOLE LOGS .................................................................................................................. 12-5
THREAD DUMPS ................................................................................................................. 12-5
HEAP DUMPS..................................................................................................................... 12-5
CAPTURING JROCKIT MISSION CONTROL JRA FILES........................................................................ 12-5
DATABASE MONITORING TOOLS .............................................................................. 12-6
AUTOMATIC WORKLOAD REPOSITORY ......................................................................................... 12-6
AUTOMATIC DATABASE DIAGNOSTIC MONITOR .............................................................................. 12-6
NETWORK MONITORING ........................................................................................ 12-6
DIAGNOSING A PERFORMANCE ISSUE ....................................................................... 12-6
STEPS FOR DIAGNOSING A PERFORMANCE ISSUE ............................................................................ 12-6
ADDITIONAL STEPS FOR DATABASE RELATED ISSUE ......................................................................... 12-7
13. PERFORMANCE TUNING ................................................................. 13-1
JVM ................................................................................................................. 13-1
CHANGING MEMORY SETTINGS ................................................................................................ 13-1
WEB SERVER ...................................................................................................... 13-2
SIMULTANEOUS USERS ......................................................................................................... 13-2
APPLICATION SERVER ........................................................................................... 13-3
LOGGING ......................................................................................................................... 13-3
ORACLE TRANSPORTATION MANAGEMENT BUSINESS OBJECT CACHES .................................................... 13-3
BUSINESS NUMBER GENERATOR (BNG) CONTENTION ..................................................................... 13-4
DIRECTSQLUPDATE ............................................................................................................ 13-5
WORKFLOW THREAD TUNING .................................................................................................. 13-5
AUTOMATIC TIMEOUT FOR STUCK THREADS .................................................................................. 13-6
MULTI-THREADING BULK PLAN PROCESSING ................................................................................. 13-6
DATABASE .......................................................................................................... 13-6
ANALYZING TABLES/GATHERING STATISTICS ................................................................................ 13-6
DATABASE FILE STORAGE PERFORMANCE..................................................................................... 13-7
FULL EXPORT AND RE-IMPORT ................................................................................................. 13-7
CHECKING FOR STALE AND PARTIAL ORACLE DATABASE STATISTICS ..................................................... 13-8
MAINTAINING ORACLE DATABASE STATISTICS ............................................................................... 13-8
SQL TUNING .................................................................................................................... 13-8
DETERMINING THE ORIGIN OF A SQL STATEMENT .......................................................................... 13-9
USING TIMEOUTS WITH SQL STATEMENTS ................................................................................... 13-9
INIT.ORA PARAMETERS ...................................................................................................... 13-10
TUNING A RAC DATABASE INSTALLATION USING SERVICES .............................................................. 13-10
Kommentare zu diesen Handbüchern