Oracle Database - Performance

Card Puncher Data Processing

Quote

Embedding a cube-organized materialized view (cache, pre-computation tasks) for your multi-dimensional reporting and analysis might deliver a level of performance that would require an orders of magnitude larger hardware to satisfy the same queries using parallel execution and the detail data records.

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool

ADDM (Automated Database Diagnostic Monitor) is available since Oracle 10g. are useful features for performance tuning and troubleshooting. ADDM reports the most significantperformancinterval between...
Card Puncher Data Processing
Oracle Database - Deadlock

A deadlock can occur when two or more users are waiting for data locked by each other. Deadlocks prevent some transactions from continuing to work. Oracle Database automatically detects deadlock situations...
Card Puncher Data Processing
Oracle Database - Parallel execution in an RAC environment

RAC provides an excellent architecture to incrementally scale your hardware configuration as you require system resources. You can use the additional resources to: support additional users (and hence...



Share this page:
Follow us:
Task Runner