RMAN List Command   To list all existing backups : RMAN> LIST BACKUP;   To list all…

Static listener and Dynamic listener What is a Listener? Listener is used to listen…

Query  to list invalid objects select decode(object_type, 'PACKAGE BODY', …

Query: SELECT     distinct user_concurrent_program_name,     responsibility_name,  …

We can use below script to find the workflow service log file name and location. Scri…

We can use below script for finding the archive log generation per hour on each day. …