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
These articles will be really help in understanding the oracle products and getting started on Oracle system
What are Concurrent Managers Concurrent Managers are the controllers of background processing for Oracle Applications. The main function of Concurrent Managers is to regulate and control process requests based upon a set of rules. It is a technique used to execute non interactive, data-dependent programs simultaneously in the background. Oracle Applications comes with predefined managers, …
Top 30 Most Useful Concurrent Manager Queries Read More »
What is Port Pool in Oracle Apps? Oracle Applications 11i/R12.0/R12.1/R12.2 uses the concept of a port pool. A port pool is a preconfigured set of unique port assignments for every E-Business Suite technology stack component that requires network connectivity. So multiple Release 12 environments can coexists on the same machine,provided you have configured each of …
How to check if Port pool is free in Oracle applications R12 Read More »
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 …
I 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 …
This 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 …
This article contains the most commonly asked top 80 oracle dba interview questions and answers oracle database administrator interview questions 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. …
Oracle dba interview questions and answers Read More »
