High Tech Oracle DBA Blog

Database DBA help and Support

June 5th, 2014 :10:36 AM

How to Tune Full Table Scan?

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 […]

May 27th, 2014 :10:08 AM

What is Workspace in Oracle?

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 […]

November 24th, 2013 :11:55 AM

Oracle Database 12c New Features

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 […]

September 5th, 2013 :12:26 PM

Oracle 12c Database Installation

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 […]

April 4th, 2013 :03:21 AM

Solutions Associated With Oracle Backup and Recovery

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 […]

March 6th, 2013 :11:55 AM

Oracle Advanced Compression

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 […]

November 29th, 2012 :09:39 AM

Transparent Application Failover-Oracle RAC

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 […]

November 29th, 2012 :09:28 AM

Exception:TNS-04414: file error in DBCA or NETMGR

Hi Friends, Today we are discussing about error “Exception:TNS-04414: file error”. Generally TNS-04414 errors occurred with exception message using GUI tools like DBCA or NETMGR. Cause of TNS-04414 error: Due to found some mysterious character in network file. While DBCA or NETMGR utility is trying to save network file like sqlnet.ora, tnsnames.ora or listener.ora that […]

September 25th, 2012 :02:30 AM

Oracle Data Mining – An Introduction

What is Oracle Data Mining? “A short and solid introduction of data mining concept in Oracle” Oracle Data Mining is one of the most impressive features of the new Oracle Database system. It has been designed with the purpose of discovering new functionality within the data on the system and thus provides new and unique […]

August 26th, 2012 :03:07 PM

Why oracle database is more popular?

Why oracle database is more popular? Oracle is the shining start in computer database solution providers. Their products such as oracle 8i, 9i up to the 11g are designed to provide effective and efficient database management solutions. A number of other solutions providers such as Microsoft with their SQL products are chasing Oracle product for […]