This document covers performance for the overall Oracle Instantis EnterpriseTrack configuration architecture. However, factors involved in the database setup play a very important role in performance. The following factors could impact database performance:
- Hardware architecture and operating system
- NIC (number of NICs, speed, duplex settings)
- Number of database instances on a server (dedicated versus shared)
- Disk storage system performance (I/O speed, buffer, mirroring)
- Table space layout and extent sizing
- Table data, index, and lob distributions on table spaces
- Table and index fill factor definition
- Database block sizing
- Connection management (dedicated versus MTS)
- RAM allocations (automatic, SGA, PGA, shared pool, buffer pool, and so on)
- CBO optimizer parameter configuration setting
- Database table and index statistics gathering mechanism and frequency
- Anti-virus software
- Additional database jobs
Introduction
Architecture Overview
Performance and Scalability Considerations
Deployment Considerations
Deployment Categories
Deployment Architectures
Network Bandwidth Estimation
Other Actions that Affect Performance
Legal Notices