Protected: Shell Script to get EMAIL alerts for ABENDED PROCESSES in Oracle GoldenGate
There is no excerpt because this is a protected post.
Oracle DB Admin
Oracle 18C new feature: Private Temporary Tables
Dear Readers, In this article we will focus on new feature that has been introduced in Oracle 18C that is “Private Temporary Table”. Private temporary tables are temporary database objects that are dropped at the end of end of a session or transaction depending on… Read More
Oracle 18C new feature: Cancel SQL instead of killing session
Dear Readers, In this article we will focus one of the most remarkable feature that has been introduced in Oracle 18C that is “now you can cancel SQL statement without killing session”. Prior 18C, DBA’s had to kill a DB sessions to get rid of… Read More
Oracle 18C new feature: Schema Only Account
This article focuses on Oracle 18C new feature: Schema Only Account. This allows schemas can be created without a password from Oracle Database 18C. BACKGROUND: Schema is a collection of objects, while DB user is an account to connect to instance. Till Oracle 12C, Oracle… Read More
Oracle 18C New Initialization Parameters
Dear Readers, In this article we will focusing on new initialization parameters that have been introduced in Oracle 18c. Below is the list of such parameters along with its significance: ADG_ACCOUNT_INFO_TRACKING This parameter has been introduced to control failed login attempts by users on Active… Read More
Installation of Oracle database 18c(18.3.0.0.0) On Linux
Installation of Oracle database 18c(18.3.0.0.0) On Linux In this article we will see steps to Install Oracle database 18c(18.3.0.0.0) on Linux x86-64 Environment. Follow below steps Click below link to install Linux x86-64 Oracle 18c software binaries for Linux x86-64 Create vm and install linux operating system… Read More
Installation of Oracle database 18c(18.3.0.0.0) On Windows
In this article, we will see Installation of Oracle Database 18c(18.3.0.0.0) On Windows. Click on below link to download 18c software binaries for windows platform Software binaries for oracle 18c Once you downloaded the file unzip and double click on setup.exe application file. Step 1 :… Read More
Protected: Automating drop partitions for set of Partition tables(Retention based on Selected Dates)
There is no excerpt because this is a protected post.
Protected: Shell script to EXPDP / SCP and IMPDP
There is no excerpt because this is a protected post.
Protected: Automating drop partitions for set of Partition tables(Retention based on No OF DAYS)
There is no excerpt because this is a protected post.
