Recovery Manager Architecture

Recovery Manager Architecture The Recovery Manager environment consists of the various applications and databases that play a role in a backup and recovery strategy. Component Description RMAN client The client application that manages backup and recovery operations for a target database. The RMAN client can use Oracle Net to connect …

Read More »

Verifying Security Access with Auditing

Verifying Security Access with Auditing What Is Auditing? Auditing is the monitoring and recording of selected user database actions, from both database users and non database users. You can base auditing on individual actions, such as the type of SQL statement executed, or on combinations of data that can include …

Read More »

Managing Resources with Profiles

Managing Resources with Profiles A profile is a named set of resource limits and password parameters that restrict database usage and instance resources for a user. You can assign a profile to each user, and a default profile to all others. Each user can have only one profile, and creating …

Read More »

Managing Security for Oracle Database Users

Managing Security for Oracle Database Users About User Security Each Oracle database has a list of valid database users. To access a database, a user must run a database application, and connect to the database instance using a valid user name defined in the database. Oracle Database enables you to …

Read More »

Database Links

Database Links The central concept in distributed database systems is a database link. A database link is a connection between two physical database servers that allows a client to access them as one logical database. What Are Database Links? A database link is a pointer that defines a one-way communication …

Read More »

Distributed Database Concepts

Distributed Database Concepts Distributed Database Architecture A distributed database system allows applications to access data from local and remote databases. In a homogeneous distributed database system, each database is an Oracle Database. In a heterogeneous distributed database system, at least one of the databases is not an Oracle Database. Distributed …

Read More »

Managing Indexes

Managing Indexes About Indexes Indexes are optional structures associated with tables and clusters that allow SQL queries to execute more quickly against a table. Oracle Database provides several indexing schemes that provide complementary performance functionality. These are: ■B-tree indexes: the default and the most common ■B-tree cluster indexes: defined specifically …

Read More »

Managing Index-Organized Tables

Managing Index-Organized Tables What Are Index-Organized Tables? An index-organized table has a storage organization that is a variant of a primary B-tree. Unlike an ordinary (heap-organized) table whose data is stored as an un ordered collection (heap), data for an index-organized table is stored in a B-tree index structure in …

Read More »

Oracle 10G Recylce Bin Features

What Is the Recycle Bin? The recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until …

Read More »

Automatic Memory Management

Automatic Memory Management The simplest way to manage instance memory is to allow the Oracle Database instance to automatically manage and tune it for you. To do so (on most platforms), you set only a target memory size initialization parameter (MEMORY_TARGET) and optionally a maximum memory size initialization parameter (MEMORY_MAX_TARGET). …

Read More »
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.