Deleting rows reduces a table's contents while leaving capacity available inside its allocated storage. When you investigate space ...
Read the full lessonOctober 03, 2026
Oracle DBA Lesson 45A — Measure a Table's Allocated Storage
Allocated storage answers how much space Oracle has assigned to a segment . A segment's extents provide capacity for row values, in...
Read the full lessonOctober 03, 2026
Oracle DBA Lesson 44A — Choose Where Application Data Belongs
A tablespace's purpose, an account's default placement, and its allocation allowance answer different operational questions. Ch...
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 45B — Where Does Space Go After DELETE?
Deleting rows reduces a table's contents while leaving capacity available inside its allocated storage. When you investigate space ...
