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

funoracleapps -

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

Read more

Remove Hidden Parameter from SPFILE

funoracleapps -

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

funoracleapps -

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

funoracleapps -

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

funoracleapps -

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

funoracleapps -

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

Read more