Issue : Form did not come up after cloning. FRM-40010: Cannot read form FND_TOP/forms/US/FNDSCSGN Solution : 1. Stop the application tier services 2. Take a backup of context file and…
Read MoreCause : Oracle doesn't allow direct access to root on cloud machines. sudo is the only option users have to access the root privileges. Solution for the above issue: 1.…
Read MoreQuery Clause In Expdp(DATAPUMP): ================================ QUERY clause can be used in expdp or impdp to export/import subset of the data or data with specific conditions. Export dump of a table…
Read MoreREUSE_DUMPFILES Parameter In EXPDP: =================================== If we try to export a dump file with the name, which is already present in that directory. then we will get the error like…
Read MoreFind user commits per minute in oracle database: =================================== Below script is useful in getting user commit statistics information in the oracle database. user commits is the number of commits…
Read MoreENABLE_PARALLEL_DML Hint In Oracle 12c: ======================================= Till Oracle 12c, For doing DML transactions in parallel, we need to enable PDML (parallel DML) at the session level. I.e before any DML…
Read MoreIN-MEMORY In Oracle 12c ======================= How to check whether inmemory is enabled or not: SQL> show parameter inmemory NAME …
Read MoreMONITORING LONG RUNING QUERY ============================== using the v$session_longops view, you can view any SQL statement that executes for more than 6 seconds. select s.inst_id, SQL.SQL_TEXT as…
Read More