Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

Top 40 Oracle Interview questions : Basics , Oracle SQL

Last updated on June 17th, 2019 at 07:10 pmThis article contains Top 40 Oracle Interview questions : Basics , Oracle SQL asked in various interview. I hope it should help in interviews Question 1.  What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. Question 2. What is exists … Continue reading Top 40 Oracle Interview questions : Basics , Oracle SQL »

How to find table where statistics are locked

Last updated on June 16th, 2019 at 07:39 pmStatistics played in key role for Oracle performance tuning. Optimizer creates the execution plan based on the statistics of the oracle table involved in the Sql queries. You may want to lock statistics in a oracle table in some cases, for example a)   you don’t want a table to be analyzed by schedule  statistics job but want … Continue reading How to find table where statistics are locked »

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 »

Top 40 oracle dba interview questions and answers

Last updated on June 16th, 2019 at 06:59 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 June 12th, 2019 at 04:49 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 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) he/she always want in priority,then … 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 »