Flashcards for Oracle Database 12c Storage and Space Management

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/15

flashcard set

Earn XP

Description and Tags

Practice flashcards covering key vocabulary and concepts related to storage and space management in Oracle Database 12c.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

16 Terms

1
New cards

Tablespace

The highest level of logical storage structure in Oracle Database 12c that consists of one or more data files.

2
New cards

Data file

A physical file associated with a tablespace, used to store the actual data.

3
New cards

Database block

The smallest unit of logical storage; a fixed number of bytes.

4
New cards

Extent

A contiguous set of database blocks allocated for storing data.

5
New cards

Segment

A database object like a table or index that requires storage.

6
New cards

PCTFREE

A storage parameter that specifies the amount of space to reserve in each block for future updates.

7
New cards

PCTUSED

A storage parameter that defines when a block becomes eligible for new row inserts.

8
New cards

BIGFILE tablespace

A tablespace that uses a single large data file that can be much larger than the traditional data files.

9
New cards

SMALLFILE tablespace

A tablespace that can have multiple small data files and is limited in size compared to bigfile tablespaces.

10
New cards

Automatic Segment Space Management

An Oracle Database feature that manages space for segments more efficiently, using bitmaps instead of free lists.

11
New cards

Segment Advisor

A tool that identifies segments with significant free space and provides recommendations for reclaiming wasted space.

12
New cards

Resumable space allocation

A feature in Oracle that allows a session to pause when space-related errors occur, allowing administrators time to resolve the issue.

13
New cards

Row Movement

A property that allows rows to be relocated within a table; required for certain operations like shrinking space.

14
New cards

Compression

A feature in Oracle Database that reduces the size of data blocks either at the data loading stage (basic) or during regular DML operations (OLTP compression).

15
New cards

SPACE Management

The methods and strategies used to effectively manage physical and logical storage in the database.

16
New cards

Undo Tablespace

A special tablespace that stores undo segments used for rolling back transactions.