Oracle Single-Column Index Access - Practical Deep Dive Oracle Performance Series Oracle Single-Column Index Access How Oracle deci...
Read the full lessonShowing posts with label dbms_xplan. Show all posts
Showing posts with label dbms_xplan. Show all posts
March 13, 2023 · access paths · autotrace · dbms_xplan · full table scan · index range scan · Index Skip Scan · oracle performance · query tuning
Testing Different Access Paths : With and Without Index
Oracle Different Access Paths - Practical Deep Dive Oracle Performance Series Oracle Different Access Paths How the optimizer choos...
Read the full lesson
Subscribe to:
Posts (Atom)
-
By Gowthami | apps-dba.com | Oracle Administration Series A common issue after Oracle Database 19c patching is a Pluggable Database (PDB) o...
-
By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
-
By Gowthami | apps-dba.com | Oracle Exadata Series If you work with Oracle Exadata, one of the most transformative features you will encou...
Oracle DBA Lesson 58A — Choose How to Grow a Datafile
When a permanent segment needs its next extent, Oracle needs allocatable space in that tablespace. A DBA can increase an existing file...
