0 Comments

RMAN Full Database Backup Scripts in Oracle 5 (1)

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 along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do […]

 48 Total Views

2 Comments

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 conclusion that SGA is undersized. Below are both options to increase SGA_MAX_SIZE and SGA_TARGET size using pfile & spfile. in our environment, it’s running using […]

 920 Total Views,  6 Views Today

0 Comments

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 created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for […]

 119 Total Views,  1 Views Today

0 Comments

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

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 a long time. Below is the query to check the long-running jobs/queries in the database where: SOFAR:-  Total block Processed. TOTAL WORK:- Total work Block […]

 167 Total Views,  1 Views Today

0 Comments

How to Check Retention Period of AWR Snapshot in Oracle 0 (0)

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 with maintains statistics of database performance. Below is the SQL command to Check the Retention Period of AWR Snapshot in Oracle. We always encourage the technical […]

 165 Total Views

Spread the love

0 Comments

How to Find User’s Privileges in Oracle 0 (0)

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 important to perform day-by-day activities according to their roles & responsibilities. System Privileges Role PrivilegesObject Privileges  Privileges are authentication to execute any activities in the database […]

 325 Total Views

0 Comments

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

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 due to performance issues, statistics locked on the table, disable statistics in the database, before/after manual analyze on tables or gather statistics, before/after migration, etc. […]

 403 Total Views,  2 Views Today

2 Comments

Basic Linux Commands For Daily Usage 4.7 (3)

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 a computer program to perform a specific task. To use this Operating System we need to get familiar with the commands to navigate between directories, […]

 733 Total Views

0 Comments

How to check the last 10 startup times of the database along with timezone 5 (1)

The last 10 startup times of the database along with timezone. Sometimes we have to find when the database is started with which timezone especially when the database is getting reboot unknowingly. The below query gives the output of the last 10 start times of the database along with the timezone, Click here for sample […]

 512 Total Views,  1 Views Today

0 Comments

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

To Find Sessions In RAC All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to monitor application connected sessions, etc. Here we are going to show various scenarios to find connected sessions in RAC databases. Here we have a two-node RAC to […]

 941 Total Views,  1 Views Today