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 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 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...
