After this lesson, you can identify a cached executable child, compare two observations of its activity, and select a useful next inves...
Read the full lessonOctober 04, 2026
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...
Read the full lessonOctober 04, 2026
Oracle DBA Lesson 57B — Find TEMP Consumers
A tempfile supplies temporary storage for many successive operations. Its catalog size can remain after a sort finishes, while the allo...
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 7C — Compare V$SQL Observations for Cursor Reuse
After this lesson, you can identify a cached executable child, compare two observations of its activity, and select a useful next inves...
