Index

A  B  C  D  E  F  H  I  L  M  N  O  P  Q  R  S  T  U  V  W  

A

  • Active Session History
    • report
      • activity over time 1
      • load profile 1
      • top events 1
      • top files 1
      • top Java 1
      • top latches 1
      • top objects 1
      • top PL/SQL 1
      • top sessions 1
      • Top SQL 1
      • using 1
    • reports 1
  • allocation of memory 1
  • applications
    • deploying 1
    • design principles 1
    • development trends 1
    • implementing 1
  • Automatic Database Diagnostic Monitor
    • actions and rationales of recommendations 1
    • analysis results example 1
    • and DB time 1
    • example report 1
    • findings 1
    • overview 1
    • results 1
    • setups 1
    • types of problems considered 1
    • types of recommendations 1
  • automatic database diagnostic monitoring 1
  • automatic segment-space management 1 , 2 , 3
  • Automatic shared memory management 1
  • automatic SQL tuning 1
  • automatic undo management 1
  • Automatic Workload Repository
    • compare periods report
      • about 1
      • advisory statistics 1 , 2
      • details 1
      • dictionary cache statistics 1
      • I/O statistics 1
      • instance activity statistics 1
      • latch statistics 1
      • library cache statistics 1
      • operating system statistics 1
      • segment statistics 1 , 2
      • service statistics 1
      • SQL statistics 1
      • summary 1
      • supplemental information 1
      • time model statistics 1
      • undo statistics 1
      • using 1
      • wait events 1
      • wait statistics 1
    • configuring 1
    • default settings 1
    • factors affecting space usage 1
    • minimizing space usage 1
    • overview 1
    • recommendations for retention period 1
    • reports 1
    • retention period 1
    • space usage 1
    • statistics collected 1
    • turning off automatic snapshot collection 1
    • unusual percentages in reports 1
    • views for accessing data 1
  • awrrpt.sql
    • Automatic Workload Repository report 1

B

  • baselines
    • performance 1
  • benchmarking workloads 1
  • big bang rollout strategy 1
  • bitmap indexes 1
  • block cleanout 1
  • block size
    • choosing 1
    • optimal 1
  • bottlenecks
    • elimination 1
    • fixing 1
    • identifying 1
    • memory 1
    • resource 1
  • B-tree indexes 1
  • buffer busy wait events
    • actions 1
  • buffer cache
    • contention 1 , 2 , 3
    • hit ratio 1
  • buffer pools
    • multiple 1
  • buffer waits
    • about 1
  • business logic 1 , 3

C

  • chained rows 1
  • classes
    • wait events 1 , 2
  • client/server applications 1
  • column order
    • indexes 1
  • components
    • hardware 1
    • software 1
  • conceptual modeling 1
  • consistency
    • read 1
  • consistent gets from cache statistic 1
  • contention
    • library cache latch 1
    • memory 1 , 2
    • shared pool 1
    • tuning 1
    • wait events 1
  • context switches 1
  • CONTROL_FILES initialization parameter 1
  • CPUs
    • statistics 1
    • utilization 1
  • CREATE INDEX statement
    • PARALLEL clause 1
  • CURSOR_SHARING initialization parameter 1
  • CURSOR_SPACE_FOR_TIME initialization parameter 1
  • cursors
    • accessing 1
    • sharing 1

D

  • data
    • and transactions 1
    • cache 1
    • gathering 1
    • modeling 1
    • queries 1
    • searches 1
  • database caching modes
    • configuring 1
    • default database caching mode 1
    • determining which mode to use 1
    • force full database caching mode
      • about 1
    • verifying 1
  • database monitoring
    • diagnostic 1
  • database performance
    • comparing 1
    • degradation over time 1
  • Database Resource Manager 1 , 2 , 4
  • databases
    • diagnosing and monitoring 1
    • size 1
    • statistics 1
  • database tuning
    • performance degradation over time 1
    • transient performance problems 1
  • DB_BLOCK_SIZE initialization parameter 1
  • DB_DOMAIN initialization parameter 1
  • DB_NAME initialization parameter 1
  • DBA_OBJECTS view 1
  • db block gets from cache statistic 1
  • db file scattered read wait events
    • actions 1 , 2
  • db file sequential read wait events
    • actions 1
  • DBMS_ADVISOR package
    • setting DBIO_EXPECTED 1
    • setups for ADDM 1
  • DBMS_SHARED_POOL package
    • managing the shared pool 1
  • DB time
    • metric 1
    • statistic 1
  • debugging designs 1
  • deploying applications 1
  • design principles 1
  • designs
    • debugging 1
    • testing 1
    • validating 1
  • development environments 1
  • diagnostic monitoring
    • introduction 1
  • dictionary cache 1
  • direct path
    • read events 1
    • read events actions 1
    • read events causes 1
    • wait events 1
    • write events actions 1
    • write events causes 1
  • disks
    • monitoring operating system file activity 1

E

  • emergencies
    • performance 1
  • Emergency Performance Method 1
  • End to End Application Tracing
    • action and module names 1
  • enqueue
    • about 1
  • enqueue wait events
    • actions 1
    • statistics 1
  • estimating workloads
    • benchmarking 1
    • extrapolating 1
  • extrapolating workloads 1

F

  • FAST_START_MTTR_TARGET
    • and tuning instance recovery 1
  • Fast-Start checkpointing architecture 1
  • Fast-Start Fault Recovery 1 , 2
  • free buffer wait events 1
  • free lists 1
  • function-based indexes 1

H

  • hard parsing 1
  • hardware
    • components 1
    • limitations of components 1
    • sizing of components 1
  • HOLD_CURSOR clause 1
  • hours of service 1

I

  • I/O
    • and SQL statements 1
    • contention 1 , 2 , 3 , 4
    • excessive I/O waits 1
    • monitoring 1
    • objects causing I/O waits 1
  • idle wait events
    • SQL*Net message from client 1
  • indexes
    • adding columns 1
    • appending columns 1
    • bitmap 1
    • B-tree 1
    • column order 1
    • costs 1
    • creating 1
    • design 1
    • function-based 1
    • partitioned 1
    • placement on disk 1
    • reducing I/O 1
    • reverse key 1
    • selectivity 1
    • sequences in 1
    • serializing in 1
  • initialization parameters
    • CONTROL_FILES 1
    • DB_DOMAIN 1
    • DB_NAME 1
    • OPEN_CURSORS 1
    • STREAMS_POOL_SIZE 1
  • In-Memory Column Store
    • about 1
    • configuring 1
    • estimating required size 1
    • performance benefits 1
    • sizing 1
  • In-Memory Column Store (IM column store) 1
  • instance activity
    • comparing 1
  • instance caging 1
  • instance configuration
    • initialization files 1
    • performance considerations 1
  • instance recovery
    • Fast-Start Fault Recovery 1
    • performance tuning 1
  • Internet scalability 1

L

  • LARGE_POOL_SIZE initialization parameter 1
  • latch contention
    • library cache latches 1
    • shared pool latches 1
  • latches
    • tuning 1 , 2
  • latch free wait events
    • actions 1
  • latch wait events 1
  • library cache
    • latch contention 1
    • latch wait events 1
    • lock 1
    • pin 1
  • linear scalability 1
  • locks and lock holders
    • finding 1
  • log buffer
    • space wait events 1
  • log file
    • parallel write wait events 1
    • switch wait events 1
    • sync wait events 1
  • log writer processes
    • tuning 1
  • LRU
    • aging policy 1
    • latch contention 1

M

  • MAXOPENCURSORS clause 1
  • max session memory statistic 1
  • memory
    • hardware component 1
    • PGA statistics 1
    • statistics 1
  • memory allocation
    • importance 1
    • tuning 1
  • metrics 1
  • migrated rows 1
  • mirroring
    • redo logs 1
  • modeling
    • conceptual 1
    • data 1
    • workloads 1
  • monitoring
    • diagnostic 1
  • multiple buffer pools 1

N

  • NAMESPACE column
    • V$LIBRARYCACHE view 1
  • network
    • hardware component 1
    • speed 1
  • network communication wait events
    • db file scattered read wait events 1
    • db file sequential read wait events 1 , 2
    • SQL*Net message from Dblink 1
    • SQL*Net more data to client 1

O

  • object-orientation 1
  • OPEN_CURSORS initialization parameter 1
  • operating system
    • data cache 1
    • monitoring disk I/O 1
  • optimization
    • described 1
  • optimizer
    • introduction 1
    • query 1
  • Oracle CPU statistics 1
  • Oracle Enterprise Manager
    • advisors 1
    • Performance page 1
  • Oracle Forms
    • control of parsing and private SQL areas 1
  • Oracle Managed Files 1
  • Oracle Orion
    • calibration tool parameters 1
    • command-line options 1
  • Oracle performance improvement method
    • steps 1

P

  • page table 1
  • paging
    • reducing 1
  • PARALLEL clause
    • CREATE INDEX statement 1
  • parameter
    • RESULT_CACHE_MODE 1
  • parameters
    • initialization 1
  • parsing
    • hard 1
    • Oracle Forms 1
    • Oracle precompilers 1
    • reducing unnecessary calls 1
    • soft 1
  • partitioned indexes 1
  • performance
    • emergencies 1
    • improvement method 1
    • improvement method steps 1
    • mainframe 1
    • monitoring memory on Windows 1
    • tools for diagnosing and tuning 1
    • UNIX-based systems 1
    • Windows 1
  • Performance Hub active reports
    • about 1
    • generating 1 , 2
  • performance problems
    • transient 1
  • performance tuning
    • Fast-Start Fault Recovery 1
    • instance recovery
      • FAST_START_MTTR_TARGET 1
      • setting FAST_START_MTTR_TARGET 1
      • using V$INSTANCE_RECOVERY 1
  • PGA_AGGREGATE_TARGET initialization parameter 1
  • physical reads from cache statistic 1
  • proactive monitoring 1
  • processes
    • scheduling 1
  • program global area (PGA)
    • direct path read 1
    • direct path write 1
    • shared servers 1
  • programming languages 1

Q

  • queries
    • data 1
  • query optimizer 1
    • See: optimizer

R

  • rdbms ipc reply wait events 1
  • read consistency 1
  • read wait events
    • direct path 1
    • scattered 1
  • redo logs
    • buffer size 1
    • mirroring 1
    • placement on disk 1
    • sizing 1
  • reducing
    • contention with dispatchers 1
    • paging and swapping 1
  • RELEASE_CURSOR clause 1
  • resources
    • allocation 1 , 2
    • bottlenecks 1
    • wait events 1
  • response time 1
  • reverse key indexes 1
  • rollout strategies
    • big bang approach 1
    • trickle approach 1

S

  • scalability
    • factors preventing 1
    • Internet 1
    • linear 1
  • scattered read wait events
    • actions 1
  • segment-level statistics 1
  • selectivity
    • ordering columns in an index 1
  • sequential read wait events
    • actions 1
  • service hours 1
  • session memory statistic 1
  • SGA_TARGET initialization parameter
    • automatic memory management 1
  • SHARED_POOL_SIZE initialization parameter 1 , 2
  • shared pool contention 1
  • shared server
    • performance issues 1
    • reducing contention 1
    • tuning 1
    • tuning memory 1
  • SHOW SGA statement 1
  • sizing redo logs 1
  • snapshots
    • about 1
  • soft parsing 1
  • software
    • components 1
  • sort areas
    • tuning 1
  • SQL*Net
    • message from client idle events 1
    • message from dblink wait events 1
    • more data to client wait events 1
  • SQL statements
    • waiting for I/O 1
  • SQL Tuning Advisor 1
  • statistics
    • baselines 1
    • consistent gets from cache 1
    • databases 1
    • db block gets from cache 1
    • dictionary cache 1
    • gathering 1
    • I/O 1
    • instance activity 1
    • latch 1
    • library cache 1
    • max session memory 1
    • memory 1
    • operating system
      • comparing 1
    • PGA memory 1
    • physical reads from cache 1
    • segment 1 , 2
    • segment-level 1
    • service 1
    • session memory 1
    • shared server processes 1
    • SQL 1
    • time model 1 , 2
    • undo 1
    • waits 1
  • STREAMS_POOL_SIZE initialization parameter 1
  • striping
    • manual 1
  • swapping
    • reducing 1
  • switching processes 1
  • system architecture
    • configuration 1
    • hardware components
      • CPUs 1
      • I/O subsystems 1
      • memory 1
      • networks 1
    • software components
      • business logic 1
      • data and transactions 1
      • resources for managing user requests 1
      • user interface 1
  • System Global Area tuning 1

T

  • tables
    • creating 1
    • design 1
    • placement on disk 1
    • setting storage options 1
  • tablespaces
    • creating 1
    • temporary 1
  • temporary tablespaces
    • creating 1
  • testing designs 1
  • thrashing 1
  • time model statistics
    • comparing 1
  • tools for performance tuning 1
  • Top Java
    • Active Session History report 1
  • top PL/SQL
    • Active Session History report 1
  • Top Sessions
    • Active Session History report 1
  • Top SQL
    • Active Session History report 1
  • transactions and data 1
  • trickle rollout strategy 1
  • tuning
    • and bottleneck elimination 1
    • and proactive monitoring 1
    • latches 1 , 2
    • resource contention 1
    • shared server 1
    • sorts 1
    • System Global Area (SGA) 1

U

  • undo management, automatic mode 1
  • UNIX system performance 1
  • user global area (UGA)
    • shared servers 1 , 2
  • user interface 1
  • users
    • interaction method 1
    • interfaces 1
    • location 1
    • network speed 1
    • number of 1
    • requests 1
    • response time 1

V

  • V$ACTIVE_SESSION_HISTORY view 1
  • V$BUFFER_POOL_STATISTICS view 1
  • V$DB_CACHE_ADVICE view 1
  • V$EVENT_HISTOGRAM view 1
  • V$FILE_HISTOGRAM view 1
  • V$JAVA_LIBRARY_CACHE_MEMORY view 1
  • V$JAVA_POOL_ADVICE view 1
  • V$LIBRARY_CACHE_MEMORY view 1
  • V$LIBRARYCACHE view
    • NAMESPACE column 1
  • V$QUEUE view 1
  • V$ROWCACHE view
    • performance statistics 1
  • V$SESSION_EVENT view 1
  • V$SESSION_WAIT_CLASS view 1
  • V$SESSION_WAIT_HISTORY view 1
  • V$SESSION_WAIT view 1
  • V$SESSION view 1 , 2
  • V$SESSTAT view 1
  • V$SHARED_POOL_ADVICE view 1
  • V$SHARED_POOL_RESERVED view 1
  • V$SYSSTAT view
    • redo buffer allocation 1
    • using 1
  • V$SYSTEM_EVENT view 1
  • V$SYSTEM_WAIT_CLASS view 1
  • V$TEMP_HISTOGRAM view 1
  • V$WAITSTAT view 1
  • validating designs 1
  • views 1
  • vmstat UNIX command 1

W

  • wait events
    • buffer busy waits 1
    • classes 1 , 2
    • comparing 1
    • direct path 1
    • enqueue 1
    • free buffer waits 1
    • idle wait events 1
    • latch 1
    • library cache latch 1
    • log buffer space 1
    • log file parallel write 1
    • log file switch 1
    • log file sync 1
    • network communication wait events 1
    • rdbms ipc reply 1
    • resource wait events 1
  • Windows performance 1
  • workloads 1 , 4 , 5