Login In Oracle Database Service Cloud as root user
Cause : 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 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
REUSE_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
Find 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
ENABLE_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
IN-MEMORY In Oracle 12c ======================= How to check whether inmemory is enabled or not: SQL> show parameter inmemory NAME …
Read MoreMONITORING LONG RUNING QUERY
MONITORING 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