HOW TO FIND ALL SESSIONS HOLDING A TABLE LOCK
Query to check table lock in Oracle database.
HOW TO MATCH OS PROCESS WITH ORACLE SESSION
What is a particular OS Oracle process (PID) executing in an Oracle database?
HOW TO FIND WHO AND WHAT SQL IS USING TEMP TABLESPACE?
A query to know which sessions are currently using temporary space in the Oracle Database, and how much space each session consumes.
HOW TO FIND ALL OBJECTS PRIVILEGES GRANTED TO A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object privileges that a particular user or a role has. It also displays if a privilege is transferred directly or through a role.
HOW TO FIND SYSTEM, ROLES AND OBJECTS PRIVILEGES THAT HAVE BEEN GRANTED TO A USER
How to find the privileges that have been granted to a user by querying data dictionary views.
HOW TO QUERY THE HIDDEN PARAMETERS IN AN ORACLE DATABASE
A query to view all the hidden parameter and their default values.
HOW TO FETCH THE CURRENT ORACLE DATABASE STATUS
A query to fetch a current status of an Oracle Database.
HOW TO IDENTIFY BLOCKED AND BLOCKING SESSIONS IN ORACLE DATABASE
A query to identify blocked and blocking sessions in an Oracle Database.