Recent Articles

How to Tune Full Table Scan?

How to Tune Full Table Scan?

June 5, 2014 | By | Add a Comment

Eliminating DB File Scattered Reads of Oracle Wait Event In Oracle, a DB file scattered read normally indicates a full table scan. A DB file scattered read is the same type of wait event as DB file sequential read, except that Oracle is reading multiple data blocks. Depending on the setting for the DB_FILE_MULTIBLOCK_READ_COUNT parameter […]

Read More

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

Oracle Database 12c New Features

Oracle Database 12c New Features

November 24, 2013 | By | Add a Comment

Oracle Database 12c New Features Off course friends, Oracle 12c database has been launched before 2 months back. C stands for cloud computing in Oracle 12c database. Indeed, this new version launched with some new features and fixed with some old known bugs. Every new Oracle release is having some good new features and Oracle […]

Read More

Oracle 12c Database Installation

Oracle 12c Database Installation

September 5, 2013 | By | Add a Comment

Step by Step Oracle 12c database installation Guide – An installation guidance with every screenshot of Oracle 12c database on Windows Platform Presently Oracle 12c database Release 1 is available for 64bit Windows only. It is also available for Linux and Solaris (64bit) sparc and X86 platform. In this article we can see how to […]

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