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

 96 Total Views,  3 Views Today

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

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

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

 388 Total Views,  5 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 […]

 303 Total Views,  3 Views Today

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

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

 571 Total Views,  3 Views Today

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

 924 Total Views,  12 Views Today

4 Comments

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

 995 Total Views,  4 Views Today

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

 628 Total Views,  3 Views Today