fbpx

How to Identify OS PID from SID in Oracle Database

Identify OS PID from SID

We want to find out OS PID against sid in the Oracle database to check the performance related to OS and Database. In the Linux platform, every process has its process ID (PID) and a user can easily get PID from SID (Identify OS PID from SID). Query to check PID from sid in Oracle … Read more

Rman full database backup script

rman full database backup script

In this article, we are going to learn how to create rman full database backup script step by step. RMAN (Recovery Manager) is a popular tool to create Oracle Database backups. Using RMAN we can create two types of backups listed below. Full Database Backup Incremental Database Backup So, here we are going to learn … Read more

crosscheck archivelog all

crosscheck archivelog all

In this article, we are going to learn, why we need to run crosscheck archivelog all commands. You must read this article carefully and follow all steps. Why we run crosscheck archivelog all? Rman utility is a very powerful utility that is used for creating Oracle Database backup. The crosscheck command only verifies the existence … Read more

How To Find CPU And Memory Information Of Oracle Database Server

Hello friends, In this article, we are going to find CPU and memory information of the oracle database server. How do I find CPU and memory information in Linux? The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt. How do I check … Read more

How To Find Execution History Of An sql_id

Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is Empty

How To Get Tablespace Quota Details Of An User In Oracle

Get Tablespace Quota Details Of An User In Oracle

In this article, we are going to show you how to get tablespace quota details of a user in oracle. What is tablespace quota in Oracle? In the Oracle database when we set the quota for a user, that means we set the limit of data storage for particular schemas objects in the specified tablespace. … Read more