SCRIPTS

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application…

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 Setup Passwordless SAMBA Share in Linux for Windows Server Access 0 (0)

Setup Passwordless SAMBA Share in Linux for Windows Server Access In this article, we will perform the required steps to setup Passwordless SAMBA Share on Linux Server. This can permit…

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…