How to update UTL_FILE_DIR in an Oracle E-Business Suite Instance on Oracle Database 19c

How to update UTL_FILE_DIR in an Oracle E-Business Suite Instance on Oracle Database 19c …

Read more

Remove Hidden Parameter from SPFILE

Remove Hidden Parameter from SPFILE A parameter can be removed from an spfile by issuing:…

Read more

ADOP prepare phase failed in R12.2.x with an error message Error calling runSyncFS subroutine

ADOP prepare phase failed in R12.2.x with an error message Error calling runSyncFS subrou…

Read more

Query to Find Concurrent Request Running more than 2 hrs

Query to Find Concurrent Request Running more than 2 hrs Script: set pagesize 1000 set pa…

Read more

How To Flush A Sql Statement From Shared Pool

How To Flush A Sql Statement From Shared Pool If we want a sql query to do hard parsing, …

Read more

Enable and Disable DBMS JOB in Oracle

Enable and Disable DBMS JOB in Oracle Oracle will not attempt to execute the job until th…

Read more