Posts by Arun Kumar

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

Maximum Security Zone in Oracle Cloud

Maximum Security Zones provides both preventative and detective security controls for cloud environment. Maximum Security Zones is the preventative control, designed to stop from making bad implementation choices that would…

Read More

Oracle Cloud Guard

Oracle Cloud Guard, a new Oracle Cloud Infrastructure (OCI) service designed to  maintain a strong security in OCI. Cloud Guard is just one of the new services that are part…

Read More