Category: oracle 11g dba

What is Workspace in Oracle?

What is Workspace in Oracle?

May 27, 2014 | By | Add a Comment

Oracle introduced a new idea that narrates to concurrency. The workspace is a transactionally constant view of all the tables in a database that have been permitted for workspace versioning. There is a PL/SQL package called DBMS_WM used for enabling and disabling workspace versioning for tables. The changes that are made in a workspace are […]

Read More

Solutions Associated With Oracle Backup and Recovery

Solutions Associated With Oracle Backup and Recovery

April 4, 2013 | By | Add a Comment

RMAN is only option for OMF and Oracle ASM as Backup and Recovery Tool In the field of Oracle backup and recovery, there exist many solutions that are used for applying various strategies. In this article we will introduce some of these solutions to make you familiar with the terms.   Recovery Manager (RMAN) There […]

Read More

Oracle Advanced Compression

Oracle Advanced Compression

March 6, 2013 | By

Oracle Advanced Compression Oracle Advanced Compression is a fresh annexe that has been liberated with the Oracle Database Management version 11g. It fundamentally is a data density extension which categorizes all varieties of data and diminishes the space necessitated in the database for all the informative-data. Because of affecting of arrangement, amorphous and other backup […]

Read More

Transparent Application Failover-Oracle RAC

Transparent Application Failover-Oracle RAC

November 29, 2012 | By | Add a Comment

Transparent Application Failover TAF in Oracle RAC Transparent Application Failover TAF is an automatic database session re-establishment or reconnection characteristic built into Oracle Call Interface (OCI) in Oracle Network. It is principally aimed for Real Application Cluster RAC environments to re-establish database sessions in case of cluster node failure or instance breakdown, but the utility […]

Read More

Compression in Datapump of Oracle 11g

Compression in Datapump of Oracle 11g

June 25, 2012 | By | Add a Comment

Compression feature of Oracle 11g Datapump The ability to constrict the meta-data associated with a Information Push job was first provided in Oracle Data source 10g Launch 2. In Oracle Data source 11g, this pressure capability has been extended so that desk data can be compacted on trade. Data Pump compression is an in sequence […]

Read More

How to Detect Block Corruption in Oracle?

How to Detect Block Corruption in Oracle?

April 12, 2012 | By | Add a Comment

Block Corruption in Oracle Analysis and Investigation of Corrupt Block in Oracle Database Oracle has four methods for detecting corruption. The analyze commend with the validate structure option can be used to verify the structure of a table, index, or cluster, and to confirm that a table and its indexes are in sync. The external […]

Read More