Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
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
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
This SQL tutorial provides explanations, examples for NULLIF function in Oracle NULLIF function is very useful function .It compare two values and return null if the values are same , else return the first value expr1 : it is the source values or expression which is going to be compared with expr2 expr2 : It is also the source value which is compared with expr1 … Continue reading NULLIF function in Oracle
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
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
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
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
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
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
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
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
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