ORATraining Blog

Tweet Click here to download cmclean.sql REM REM FILENAME REM   cmclean.sql REM DESCRIPTION REM   Clean out the concurrent manager tables REM NOTES REM   Usage: sqlplus <apps_user/apps_passwd> @cmclean REM REM REM   $Id: cmclean.sql,v 1.4 2001/04/07 15:55:07 pferguso Exp $ REM REM REM +==============================+ set verify off; set head off; set timing off set pagesize 1000 column manager [...]

Tweet We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Following is the syntax of the same: CONCSUB <APPS username>/<APPS password> <responsibility application short name> <responsibility name> <username> [WAIT=N|Y|<n seconds>] CONCURRENT <program application short name> <program name> [PROGRAM_NAME="<description>"] [REPEAT_TIME=<resubmission time>] [REPEAT_INTERVAL= <number>] [REPEAT_INTERVAL_UNIT=< resubmission unit>] [REPEAT_INTERVAL_TYPE=< resubmission type>] [REPEAT_END=<resubmission end date [...]

Tweet   Table Name: FND_CONCURRENT_REQUESTS Column Name: PHASE_CODE   Value  Meaning  C  Completed  I  Inactive  P  Pending  R  Running   Table Name: FND_CONCURRENT_REQUESTS Column Name: STATUS_CODE   Value  Meaning  D  Cancelled  U  Disabled  E  Error  M  No Manager  R  Normal  I  Normal  C  Normal  H  On Hold  W  Paused  B  Resuming  P  Scheduled  Q  Standby [...]

Tweet /*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases [...]