Recent Articles

Fragmentation in Dictionary Managed Tablespace in Oracle Database

Fragmentation in Dictionary Managed Tablespace in Oracle Database

February 13, 2018 | By | Add a Comment

Prevent fragmentation in a tablespace is most crucial part of database administration. It degrades performance and wastes disk space. The article explains how fragmentation occurs in dictionary managed tablespace in Oracle database. Tablespace fragmentation is fairly common in most databases, and to a certain degree, it is almost inevitable, unless specific steps are taken to […]

Read More

Right Source To Know About The Real Market Share Value Of Database

Right Source To Know About The Real Market Share Value Of Database

February 13, 2018 | By | Add a Comment

The database is really the most important one for any organization to store any kind of data. Choosing the right database will help you to store the entire data of your organization with complete security. RDBMS is nothing but a relational database management system where there are many professional database providers in this IT market. […]

Read More

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