88 - [Oracle 19C] Managing Storage Space

 

•  Managing Storage Space

 Space is automatically managed by the Oracle Database server. It generates alerts about potential problems and recommends possible solutions.

 Oracle Managed Files (OMF)
 No need to bother about the file names and storage requirements. Oracle provides a unique file name.
 Eliminates the need for the DBA to directly manage OS files.
 Allows operations to be specified in terms of objects and not files.
 Reduces the chance of overwriting a file. Avoids accidental corruption of data files.

 Free -space management with bitmaps ( (“locally managed managed”)
    note: This is known as Automatic Segment Space Management
    For example, the following statement creates tablespace mytbsmytbs1 with automatic segment segment-space management:

CREATE TABLESPACE mytbs
mytbs1DATAFILE '/u u01 /oracle/data/mytbs mytbs01 .dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL - <<< This means that Oracle will use a bitmaps in order for the space management.
SEGMENT SPACE MANAGEMENT AUTO; - <<< this means that you are using automatic segment space management. Oracle store the data in data blocks and the data blocks is eight kilobyte by default.

 Automatic data file extension
So the files can grow automatically based on the amount of data in the files.

 Proactive space management (default thresholds and server server-generated alerts)