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

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

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 »

Coalesce Function in Oracle

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

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

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

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 »

Top 40 oracle dba interview questions and answers

Last updated on June 30th, 2019 at 03:47 pmThis article contains the most commonly asked top 40 oracle dba interview questions and answers Question 1. What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated … Continue reading Top 40 oracle dba interview questions and answers »

How to change Priority for Concurrent Program

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

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

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

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 »