Oracle Backup & Restore Concepts

-- * The database administrator’s duties are to: -- * Protect the database from failure wherever possible -- * Protect critical components by redundancy -- * Minimize the loss of data -- * Increase the mean time between failures (MTBF) -- * Decrease the mean time to...
Oracle Auditing

Oracle Auditing

-- * A secure system ensures the confidentiality of the data that it contains. -- * There are several aspects of security: -- 1. Restricting access to data and services -- 2. Authenticating users -- 3. Monitoring for suspicious activity -- Audit Types: -- 1. Mandatory...
Oracle Lock Management

Oracle Lock Management

-- * Shared and Exclusive Locks -- * Exclusive lock: -- The first session to request the lock on the row gets it, -- Any other sessions requesting write access must wait. -- Read access is permitted, though if the row has never been updated by the locking session, --...
Oracle Undo Management

Oracle Undo Management

-- * ACID (aka ACID test) -- In computer science, ACID (atomicity, consistency, isolation, durability) -- is a set of properties that guarantee database transactions are processed reliably. -- * Atomicity -------------- -- The principle of atomicity states that all...
Oracle Advenced Storage Management

Oracle Advenced Storage Management

  Migration and Chaining -- * Migration, Chaining And PCTFREE / PCTUSED (Block Parameters) -- * Migration --------------- -- * Occurs only during updates -- * when row < block size -- 1. On update: Row length increases, exceeding the available free space...
Managing Oracle Storage

Managing Oracle Storage

-- STORAGE - Logical & Physical -- 1. Database -------------- Database --> Tablespace -- Tablespace : -- Within a database the tablespace is the largest logical storage structure -- Every database must consist of one or more tablespaces. -- Every tablespace...