SCRIPTS

RMAN Full Database Backup Scripts in Oracle 5 (2)

RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile…

Step by Step How to increase SGA size in Oracle 4.3 (3)

Step by Step How to increase SGA size in Oracle I was facing a memory issue in my environment after validating the AWR  and ADDM reports and came to the…

How to Check PGA information in Oracle 0 (0)

How to Check PGA full information in Oracle.   A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory…

How to Check Long Running Job in the Oracle Database 4.5 (2)

How to Check Long Running Job in the Oracle Database Sometimes in the database, few queries are taking a long time to complete the query, to validate which query taking…

How to Check Retention Period of AWR Snapshot in Oracle AWR (Automatic Workload Repository) is a key to diagnose the performance of Oracle database, AWR collects various types of processes along…

How to Find User’s Privileges in Oracle 3 (2)

How to Find User’s Privileges in Oracle In this article, we are going to find all forms of privileges of users in Oracle.  Commonly users have the below types of access in databases which are…

How to Find Last Analyzed date on Tables, Partition, and Subpartition in Oracle 5 (1)

Find Last Analyzed date on Tables, Partitions, and Subpartitions in Oracle Here we are going to demonstrate how to find the last analyzed date on tables in Oracle. Some time…

Basic Linux Commands For Daily Usage 4.8 (4)

A Handy Guide for Basic Linux Commands Linux, an open-source Operating System is one of the most popular operating systems which takes inputs in the form of commands to direct…

The last 10 startup times of the database along with timezone in Oracle Sometimes we have to find when the database is started with which timezone especially when the database…

How to Find Sessions in RAC Oracle All in One 5 (3)

How to Find Sessions In RAC Oracle All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to…