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 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 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 metadata API.
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.
HOW TO GET ORACLE NLS SETTINGS DEFINED ON DATABASE, INSTANCE, AND SESSION LEVELS
A database query to fetch Oracle NLS settings defined on a database, an instance, and session levels.
HOW TO FETCH THE CURRENT ORACLE DATABASE STATUS
A query to fetch a current status of an Oracle Database.