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
Articles related to DBA
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
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,
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
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
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.
Below are the oracle session monitoring scripts for the database version 9i, 10g and above versions.
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