In this benchmarking test, the objective was to compare the query performance between an internal relational table and an external table (created from a Parquet file in OCI Object Storage) in Oracle ADW The Parquet file contained 1 billion records, and the same data was loaded into both an internal ADW table and an external table using the Parquet file as the data source. Queries were executed using SQL Developer SET TIMING ON; -- Query to count rows in the internal table SELECT COUNT(*) FROM internal_table; -- Query to count rows in the external table (Parquet-based) SELECT COUNT(*) FROM BIG_EXTERNAL_TABLE; Execution Plans Internal Table Execution Plan: • Operation: TABLE ACCESS STORAGE FULL — Oracle retrieves data directly from its optimized storage. • resourceCost: 4329 • Result Cache: Enabled, allowing Oracle to cache the result for faster retrieval in subsequent queries. • Parallelism: Automat...
Introduction In today's fast-paced digital world, High Availability and Disaster Recovery (HA/DR) are not just technical jargon but essential strategies for safeguarding your data and business continuity. If you're using Oracle Autonomous Transaction Processing (ATP) databases, you're in luck. Oracle offers an array of HA/DR options, which can be easily managed from the ATP console itself. In this blog post, we'll delve into these options, their costs, and key performance indicators like Recovery Time Objective (RTO) and Recovery Point Objective (RPO). Most importantly, we'll guide you through best practices for setting up and testing these HA/DR configurations. Your HA/DR Options in Oracle ATP - At a Glance Here's a summary table outlining the available HA/DR options for Oracle ATP databases: Best Practices for HA/DR Setup 1. Evaluation Before implementing any HA/DR solution, perform a thorough assessment of your business needs, budget, and risk tolerance. The ...