DBA

Articles related to DBA

Latest DML time on a table

In this post we will see how to find the latest DML time performed on the table. For this we are going to use ORA_ROWSCN Pseudocolumn. ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to

ORA-14758: Last partition in the range section cannot be dropped

An error “ORA-14758: Last partition in the range section cannot be dropped” is expected behavior while dropping the last partition in the range section. The high value of the last partition in the range section has an important role in the

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

In Oracle Database 12c, VARCHAR2 and NVARCHAR2 data types supports size up to 32767 bytes. This article explains how to increase maximum size of VARCHAR2, NVARCHAR2 and RAW columns in oracle 12c database using MAX_STRING_SIZE parameter. Prior to 12c version,

How to find free memory of Server and other OS Metrics in Oracle

In this post we will see some of the important OS metrics in oracle. At the start of AWR report you will find Host Name, Platform, CPUs, Cores, Sockets, Memory. Do you know where you can find these details in

Interpreting Oracle Execution Plan

I have found a very nice oracle white paper of interpretation of Oracle Execution Plan. This white paper covers the below topics. Displaying Execution Plan What is Cost Understanding Execution Plan(Cardinality,Access Paths, Join Method, Join Order,Partitioning, Parallel Execution Etc.) Download

List TNS entries from TNSNAMES.ORA using java

I was searching for the java program which should List TNS entries from TNSNAMES.ORA using java. I Google this but not found any satisfactory answer. So I have written the below code to list the tns entries from TNSNAMES.ORA file.

Difference between Oracle Instance and Oracle Database

Today we will see the basic terms regarding the oracle database i.e. Oracle Instance, Oracle Database and Oracle Server. Many peoples are always having confusion between Oracle Instance, Oracle Database and Oracle Server. Below is the simple description for all

Page 1 of 212