0 Comments

How to Find ROLE Creation Date in Oracle 5 (1)

How to Find Role Creation Date in Oracle In this article, we will prepare an SQL command for How to Find ROLE Creation Date in Oracle. View DBA_ROLES doesn’t have a column for ROLE creation date however we fetch other information about ROLE after creation. To achieve it we use the base table SYS.USER$ of […]

 177 Total Views,  1 Views Today

0 Comments

Validate Applied Patches in Database Oracle 19c 5 (1)

Validate Applied Patches in Database Oracle 19c In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using various methods/options including container & pluggable database. Validation becomes important before and after the patch apply. Let’s begin practical. 1. Validation in ORACLE HOME First, […]

 215 Total Views,  1 Views Today

0 Comments

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 schema. To fulfill this request either we can grant SELECT privileges on all tables to requestor which are owned by specific application schema or create […]

 429 Total Views

0 Comments

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 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 […]

 455 Total Views,  1 Views Today

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 […]

 2,965 Total Views,  4 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 […]

 345 Total Views

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 […]

 740 Total Views

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 […]

 476 Total Views

Spread the Knowledge!

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 […]

 722 Total Views,  1 Views Today

0 Comments

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 everyone on a windows machine to get entry to this without a set off for password. This form of requirement generally comes from the Window […]

 807 Total Views,  1 Views Today