Posts by Arun Kumar

Oracle Database Diagnostic and Tuning Pack Usage

Introduction: Oracle database always comes up with additional licensing for extra features and most prominent feature is Diagnostics and Tuning pack. These packs are controlled by database parameters and some…

Read More

Oracle Multitenant explained in simple terms

Many of us would have come across the word “Multitenant Architecture” in Oracle world. By the time, we read this, some of us feel boring to go in detail and…

Read More

Working Efficiently with Oracle Support

As an Oracle consultant, there will be many times you will need to raise Oracle support for multiple issues. When there is tight schedule, you will look for quicker responses…

Read More

STANDBY LOG NOT APPLYING IN STANDBY DATABASE

Issue: We found standby log was not applying in standby database and the difference count was keep increasing. Media recover process also not starting up. Cause: Upon receiving such alert…

Read More

SQLTXTRACT and SQLTEXECUTE -Revealing Confusion

SQLT XTRACT is the easiest report to create because it does not require the execution of the SQL at the time of the report generation. The report can be collected…

Read More

Oracle ETRM

The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of database design and dependency information for Oracle E-Business Suite. Earlier it was available in online in the…

Read More

tkprof multiple trace files

Introduction:  There are many times where DBA has to run tkprof for multiple trace files at one time and get them uploaded in Oracle SR.  Here, I will be sharing…

Read More

Easy way to find SID in database using basic information

There are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request.  To capture the session quickly with the information what we get is really…

Read More

Which type of Database release customer should follow? Long Term Release and Innovation Release?

Long Term Release:   Oracle Database Long Term Releases offers highest  level of stability including lot of bug fixes developed over the period of years. It typically has highest premier…

Read More

Oracle Cloud Shell – Configuration and its uses

Oracle Cloud Shell is web based terminal access from Oracle Cloud console. It is free to use and provides access to Linux shell. Cloud shell is a small VM running…

Read More