Tag: Oracle Database 11g

DB_ULTRA_SAFE parameter

DB_ULTRA_SAFE is a new parameter introduced in 11g. It provides an integrated mechanism to offer protection from various possible data corruptions. and provides critical high availability benefits for Oracle Database. Setting DB_ULTRA_SAFE initialization parameter will configure the appropriate data protection block checking level in the database. It will control DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT. DB_BLOCK_CHECKING controls…
Leggi tutto


26 Gennaio 2017 0

Compress table

Scenery: Mass distribution of rich and multimedia content over the Internet, made possible through advancements in broadband technologies, also contributes to the growth in overall data volume. The enormous growth in the volume of data that needs to be retained online makes storage one of the biggest cost elements of most IT budgets. The compression…
Leggi tutto


5 Dicembre 2016 0

A new feature in Oracle 11g: ACTIVE DUPLICATE

Very often we need to make copies of the production database in test environments to be able to perform functional tests which can then be issued on production. To make a copy of the database there are several methods. Some of these are: •    Export / import mode (which uses the utility expdp / impdp…
Leggi tutto


8 Luglio 2013 0