How to Gather stats & Export import stats in Oracle

Hello Friend's, In this post we will see some example for stats gather in oracle database. So Let's get started To gather...

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

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

Scripts to check Memory and Cpu intensive queries

  Hello Friend's, In this post i am giving some queries that will help you find memory and cpu intensive queries. Memory usage by sessio...

Read More

Scripts for tablespace used and free space

Hello Friend's In this post we will discuss about the scripts for getting free and used space in tablespace and datafile For Tablesp...

Read More

Scripts to Monitor Rman restore

Hello Friend's, Below are the scripts will help you to check the status of Rman restore and estimate how much more time will be needed t...

Read More