How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1)   Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > …

Fixing a “Failed” worker  Whenever  a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. …

RapidWiz log files for Oracle Applications Release 12   During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, …

Oracle AD Controller ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities. ADCTRL is …

List of All active Transactions

Oracle RMAN Commands List Here is the list of key most RMAN commands that are used for Backup and related activities:   LIST Commands LIST Commands are generic RMAN commands …

PL/SQL Code For Dropping All Objects in Schema   DECLARE v_itemcount INTEGER; BEGIN SELECT Count(*) INTO   v_itemcount FROM   all_objects AO WHERE  AO.owner = USER AND AO.object_type NOT IN ( ‘INDEX’ ) AND AO.object_name NOT LIKE ‘BIN$%’; WHILE ( v_itemcount > 0 ) LOOP FOR v_cmd IN (SELECT ‘drop ‘ || AO.object_type || ‘ ‘ || AO.object_name || Decode(AO.object_type, ‘TABLE’, ‘ CASCADE CONSTRAINTS’, ”) AS DROPCMD FROM   all_objects AO WHERE  AO.owner = USER AND AO.object_type NOT IN ( ‘INDEX’ ) AND AO.object_name NOT LIKE ‘BIN$%’) LOOP …

ERROR

Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its …