A tempfile supplies temporary storage for many successive operations. Its catalog size can remain after a sort finishes, while the allo...
Read the full lessonOctober 04, 2026
Oracle DBA Lesson 57A — Provide Temporary Space for a Workload
Sorts and hash joins use work areas to hold intermediate results in memory. When an operation needs disk space, Oracle writes intermedi...
Read the full lessonOctober 04, 2026
Oracle DBA Lesson 56B — Create and Verify a Tablespace
A tablespace connects a logical storage name to the data files that hold its segments. Creating it in the intended container establishe...
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 22 Part 2 — Start a Database in Stages
A staged startup turns one large operation into three observable steps. Start the instance, mount the database, then open it. After eac...
