Techgoeasy - Page 3 of 47 - Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running

Comment

SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running set echo on set timing on set feedback on set pagesize 132 set linesize 100 col name form a30 col queue_table form a30 col enqueue_enabled form a7 col dequeue_enabled form a7 col retention form a20 — select name, queue_table, enqueue_enabled, dequeue_enabled, retention from dba_queues where owner = ‘APPLSYS’ and … Continue reading SQL to check the AQ setup and Workflow Agent Listener/WF Java Deferred Agent Listeners are running »

Concurrent Request Phase and Status

Comment

Last updated on June 12th, 2019 at 04:46 am FND_CONCURRENT_REQUESTS table contains the Concurrent Request Phase and Status of each concurrent request. Here are the information about Concurrent Request Phase and Status Values and Meaning for Status code SELECT LOOKUP_CODE STATUS_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ‘CP_STATUS_CODE’ AND ENABLED_FLAG = ‘Y’ AND VIEW_APPLICATION_ID = 0 ORDER BY LOOKUP_CODE STATUS_CODE MEANING A Waiting B Resuming … Continue reading Concurrent Request Phase and Status »

R12.2/R12/11i Common log file locations

Comment

Last updated on June 11th, 2019 at 07:12 pmI have worked on Oracle Apps Version 11i, R12.0 , R12.1 and R12.2. Each of these has fixed location for log files. Apps DBA is supposed to know those location so that troubleshooting and monitoring can be done. I am giving here the logfile location for all these version which can be lot of help to APPS … Continue reading R12.2/R12/11i Common log file locations »

Coalesce Function in Oracle

Comment

Last updated on June 11th, 2019 at 07:04 pmCoalesce Function is a useful function in oracle and it is very useful when we want to return first non null values in the list.This SQL tutorial provides explanations, examples for Coalesce Function in Oracle expr1 : This is returned if it is not null expr2: This is returned if it is not null and first expression … Continue reading Coalesce Function in Oracle »

NVL2 function in Oracle

Comment

Last updated on June 11th, 2019 at 07:08 pmThis SQL tutorial provides explanations, examples for NVL2 function in Oracle NVL2 function is a nesting function .It examines the first impression, if the the first impression is not null ,then NVL2 function returns the second expression. if the first impression is null, then it return the third expression. expr1: it is the source values or expression … Continue reading NVL2 function in Oracle »

NVL function in Oracle

Comment

Last updated on June 11th, 2019 at 07:10 pmThis SQL tutorial provides explanations, examples for NVL function in Oracle NVL function is a nesting function which is used to substitute null values with certain values In the above syntax expr1 : it is the source values or expression which may contain null. You can provide column name,function on the column name expr2 : It is … Continue reading NVL function in Oracle »

How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2

Comment

Last updated on June 28th, 2019 at 03:18 amWe often need to find out what all patches are applied to the EBS instance. Now this vary as per the EBS instance version. We have different queries for R12.1 and R12.2. For R12.0/R12.1 ad_bugs tables contains the information for all the patches applied to the system. we can used below query to find out the patch … Continue reading How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2 »

How to change Priority for Concurrent Program

Comment

Last updated on August 6th, 2019 at 04:09 amMany times in Oracle Apps env,user complain there request get stuck or takes time to start processing. Majority of time Support team can’t do anything, unless waiting or asking Oracle DBA to check the server performance. There is couple of option you can try , if you know a demanding user and there request name( Concurrent Program) … Continue reading How to change Priority for Concurrent Program »

Oracle Wait Events That Everyone Should Know

1 Comment

Here are some of the Common Oracle wait events that everyone should Know. Wait events You can find which event session is waiting for it by following query select event from V$session_wait where sid=&1 I am trying to explain few common Oracle wait events ,there causes and resolutions enqueue The process is waiting on an enqueue (a lock you can see in v$lock). This commonly … Continue reading Oracle Wait Events That Everyone Should Know »

JDBC connection scripts for Oracle Applications R12

Comment

Last updated on May 31st, 2019 at 03:44 amThis article is part of EBS tutorials and provides different JDBC connection scripts for Oracle Applications R12 Oracle OC4J connect to Oracle database using JDBC connection. Here is the list of some good scripts on JDBC connection The OC4J JVM process id can be found using the below opmnctl command opmnctl status -l A) To find total … Continue reading JDBC connection scripts for Oracle Applications R12 »

How to find the High Water mark of the Oracle Table

Comment

Last updated on May 29th, 2019 at 05:38 pmHigh Water Mark of Oracle table High water mark is a term used in oracle table to show the blocks which has been ever used in the life cycle of the oracle table. So basically if the oracle table block is flat structure, it is right most block in the structure. This is used by Oracle process … Continue reading How to find the High Water mark of the Oracle Table »