Scripts

Description,Explanation, Execution and Sample Output	Script
Sync status query to be used on Standby Database	sync_stdby.sql
Objects currently Locked	locked_obj.sql
Tablespace Free Space	ts_free.sql
Session information from Process ID	pid.sql
Database Information	db.sql
Patch applied or not?	patch.sql
RMAN backup information	rman_bkp.sql
Check invalid objects	invalids.sql
Finding Blocking sessions	locks.sql
Sql text running that is running by a Session with an SID	sql_text.sql
Particular Table Size	tab_size.sql
Applications Relese/Version	release.sql
RMAN Backup Status	rman_status.sql
Tablespaces Information	tsinfo.sql
Sync status query to be used on Primary Database	sync.sql
Session information from Session ID (SID)	sid.sql
Sessing currently connected to Database	sess_runnig.sql
Privilege associated with a User	user_privs.sql
Oracle Application Products Version	product_status.sql
RMAN Progress Sofar	rman_sofar.sql
Concurrent Manager Status from Back-end	cm_status.sql
Concurrent Request information from Request ID	cr_info.sql
Concurrent Requests Currently Running	crs.sql
Pending Concurrent Requests Count	pend_crs_cnt.sql
Pending Concurrent Requests Count with Conflict Resolution Manager(CRM)	pend_crs_cnt_crm.sql
Pending Concurrent Requests Count with Standard Manager	pend_crs_cnt_stdm.sql
Pending Concurrent Requests Information with all the Managers	pend_cr.sql
Concurrent Requests Information Pending with Conlict Resolution Manager	pend_crs_crm.sql
Concurrent Requests Information Pending with Standard Manager	pend_crs_stdm.sql