As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?
In the context of an Autonomous Transaction Processing (ATP) database, different connection services are optimized for various types of workloads. 'TP' and 'TPURGENT' are typically used for high-priority, low-latency OLTP applications. 'HIGH' is generally intended for reporting queries that require significant computational resources. However, for a balanced workload that includes both high concurrency transaction processing and parallel reporting queries, 'MEDIUM' is the appropriate choice. It provides a middle ground, facilitating both transactional throughput and query performance.
high concurrency