Oracle DataBase - Basics

First acquaintance with Oracle DataBase:

• First acquaintance with Oracle DataBase

Basics:

• Oracle Database startup and shutdown modes

Oracle Database Architecture:

• Oracle Database Instance
• Oracle Database Files
• Oracle Memory Structures
• Oracle Database Processes

Managing Tablespaces:

• Oracle Tablespaces
• Creating Tablespaces
• Extending Tablespaces (creating additional files for tablespaces)
• Segments > Extents > Blocks
• Commands for analyzing UNDOTBS usage

Indexes:

• Oracle Indexes

Users, schemas and their sessions to Oracle Database:

• Oracle Schemas
• System and object privileges of users in Oracle Database
• Sessions to Oracle Database

Transactions:

• Simple Oracle Database Transaction