Oracle DBA Lesson 47A — Choose Where Oracle Creates Files

Oracle Managed Files (OMF) separates choosing storage from naming and managing database files . You choose an eligible destination. Or...

Read the full lesson

Oracle DBA Lesson 46B — When Does a Table Get Storage?

Oracle records a table's definition in the data dictionary. A table segment is the allocated storage for that table's data. Wi...

Read the full lesson

Oracle DBA Lesson 46A — Understanding Extra Block Visits

A heap-table row can require more than one block visit to retrieve its values. Row migration leaves a forwarding location behind when ...

Read the full lesson