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

How to Generate Execution Plan in Oracle

Generate Execution Plan

Knowing how to generate an execution plan optimizer of the SQL statement is an important part of optimizing SQL performance. There are many methods for generating an execution plan. The best option that suits you should be your tuning tool. Execution plan with autotrace When you want to display the SQL execution plan and don’t … Read more

How to find the long running queries in oracle

How to find the long running queries in oracle

Here we are going to learn how to find the long running queries in oracle, sometimes the query takes time to complete. Oracle has a view v$session_longops which is used to tracke these kinds of queries. The view shows the details about the work has donned in percentage, the pending percentage also and sofar completed, … Read more

Querying Tablespace Usage

Querying Tablespace Usage

Hello friends, In this article, we are going to learn how to querying tablespace usage. In Oracle Database the tablespace management is important and Oracle DBA will need to do quite frequently. The below query will help you to get the tablespace usage details. Query to check the tablespace usage The below query will help … Read more

How to check active sessions in Oracle database

How to check active sessions in Oracle database

Check active sessions details in Oracle Hello friends, in this article we are going to discuss how to find the details of the currently active user session with details in the Oracle Database. To check active sessions in Oracle use the below query. Find Active session To check active user connection details in Oracle, we … Read more