Install database components in a pluggable database

  Install database components in a pluggable database If components are missing, they must be installed manually in the pluggable. Below an ...

Read More

Useful scripts for monitoring database

Hello Friend's, In this post i am providing some useful scripts for monitoring database. 1) ------------------Find active ses...

Read More

Creating sql baseline to fix query with better execution plan

Hello Friends, In this post we will discuss creating sql baseline and force query to use better execution plan (plan hash value). ...

Read More

RMAN-06429: RCVCAT database is not compatible with this version of RMAN

Hello Friends, In this post we will discuss the upgradation of recovery catalog. for error RMAN-06429 $ rman target / catalog cgr...

Read More

Script to kill session from sql_id

Hello Friend's In This post I am posting dynamic queries to kill session for particular sql_id . so let's get started Script...

Read More

Install postgres on linux Step by step

Hello Friend's, In this post we will discuss about the postgres software installation database creation etc. *******************...

Read More

Oracle 19c New Features For Dba

 Hello Friend's, In this post we will discuss about the new features of 19c for DBA. Installation and Upgrades RPM Based Installation  i...

Read More

Apply Patch On Oracle 19c Database Release Update 19.8.0.0.0

Hello Friend's, In this post we will look at Database patching from 19.3 to 19.8 Download the patch from oracle metalink. from patch...

Read More

Apply Patch file On Oracle Grid 19c Update from 19.3 to 19.8

Hello Friend's, In this post we will look at Grid patching from 19.3 to 19.8 Download the patch from oracle metalink. from patches a...

Read More