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
Subscribe to:
Posts (Atom)