High Tech Oracle DBA Blog

Database DBA help and Support

February 13th, 2018 :09:48 AM

Fragmentation in Dictionary Managed Tablespace in Oracle Database

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

February 13th, 2018 :09:25 AM

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

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

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