An Oracle Database is a relational database management system (RDBMS) designed to handle large amounts of data and is scalable for enterprise use. It supports structured data, SQL querying, and multi-user access.
The SGA is a shared memory region that contains data and control information for one Oracle database instance. It includes shared pool, buffer cache, and redo log buffer.
A tablespace is a logical storage unit in Oracle that contains datafiles. It allows for database data to be stored in a segmented manner.
Datafiles are physical files that store database data. Each tablespace is made up of one or more datafiles, and they contain data such as tables and indexes.
A control file is a small binary file that records the structure of the database. It contains essential information such as database name, timestamp, datafile locations, and redo log file details.
Redo log files store all changes made to the database. They are essential for database recovery in the event of a system failure.
An Oracle instance consists of memory structures (SGA) and background processes that allow users to interact with the Oracle database.
A data block is the smallest unit of storage in an Oracle database. It contains the actual data that users access via SQL queries.
Oracle Listener is a service that listens for incoming client connections and directs them to the appropriate database instance.
ALTER modifies the structure of database objects like tables or columns, while UPDATE modifies the data stored within tables.
Oracle ASM simplifies storage management by providing an abstraction layer that manages data storage, allowing DBAs to manage data across disks without needing to configure RAID.
Oracle RAC (Real Application Clusters) is a high availability solution that allows multiple instances to access a single Oracle database, ensuring load balancing and redundancy.
Data Guard is an Oracle feature that ensures high availability and disaster recovery by maintaining standby databases that mirror the primary database.
RMAN is an Oracle utility for performing backup and recovery tasks. It allows full, incremental, and archive log backups and automates the recovery process.
Partitioning divides large tables or indexes into smaller, more manageable pieces called partitions, improving performance and manageability.
A snapshot in Oracle is a point-in-time copy of the data. It is used in replication and read-only environments for reporting and analysis.
A full backup copies the entire database, while an incremental backup only copies data that has changed since the last backup.
Flashback allows DBAs to quickly recover from errors by providing mechanisms to view past states of the database or undo changes.
A schema is a collection of database objects like tables, views, indexes, and procedures owned by a specific user.
AWR collects, processes, and maintains performance statistics for problem detection and tuning in the Oracle database.
