Tag: technology

Push algorithm

Pop algorithm

Push-Re label method

Discoverer Route.

AVL trees.

JBL trees

Red-black Trees

Blue-Green Trees

Control file

Extent

Segment

Data file

Log file

Tablespace

ABORT

NORMAL

IMMEDIATE

TRANSACTIONAL

TARGET_REDO_BLKS

FAST_START_IO_TARGET

LOG_CHECKPOINT_TIMEOUT

RECOVERY_ESTIMATED_IOS

LOG_FILE_SIZE_REDO_BLKS

LOG_CHECKPOINT_INTERVAL

Perform I/O

Lock rows that are not data dictionary rows

Monitor other Oracle processes

Connect users to the Oracle instance

Execute SQL statments issued through an application

CREATE USER

CREATE SESSION

CREATE ANY TABLE

IMP_FULL_DATABASE

EXP_FULL_DATABASE

Oracle Managed Files used for this instance.

The COMPATIBLE intialization paramter must be 9.0.0 or higer.

Space within segments is the USER_DATA tablespace is managed with freelists.

Restore the data file and perform incomplete recovery.

Restore the data file and perform point-in-time recover.

Drop the tablespace and lose all data in the tablespace.

Restore the database and lose all data since the last backup.

The control file can grow in size.

The control file can store RMAN scripts.

CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.

The RMAN catalog can exist solely in the control file of the target database.