HOW TO FIND REDO LOG MEMBERS, REDO LOG FILE SIZE, AND REDO LOG FILE STATUS
Fetching redo log details by querying data dictionary views
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…
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 RETRIEVE AN OBJECT DDL OR A USER DDL USING PL/SQL
How to extract metadata of users, tables, views, triggers, and other Oracle database objects by using the…
HOW TO BACKUP AN INITIALIZATION PARAMETER FILE BY QUERYING A DATABASE VIEW
A query to list all of the parameter values currently used by an instance.
HOW TO QUERY THE HIDDEN PARAMETERS IN AN ORACLE DATABASE
A query to view all the hidden parameter and their default values.
SQLPLUS : DYNAMIC NAME FOR A SPOOL FILE
The post provides a way to change the spool file name dynamically during a SQL script execution.
WHAT ORACLE_HOME WAS USED TO START UP A DATABASE INSTANCE?
A query to get the ORACLE_HOME path in an Oracle Database.