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
Where to Get Documentation
Documentation Accessibility
Where to Get Training
Where to Get Support
Legal Notices