Home » Page 84

Oracle Apps Interview Questions with Answers

This is a compilation of the most commonly asked 50 oracle apps interview questions and answers Question 1 What is the difference between AD_BUGS & AD_APPLIED_PATCHES Answer AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that …

Oracle Apps Interview Questions with Answers Read More »

Oracle Weblogic 12c/11g Interactive Guide

Oracle Weblogic is the leading Application server in the industry.It delivers security, performance, scalability and reliability. Its provide lot of feature to manage the demanding transaction processing system. Oracle weblogic is also used in Oracle EBS Release 12.2 , Oracle Enterprise Performance management and many other products.Oracle provides the interactive guide to go through all …

Oracle Weblogic 12c/11g Interactive Guide Read More »

How to check degree of parallelism in oracle & Default Parallelism

Suppose we execute the below parallel query in Oracle database select /*+ PARALLEL(JN) */ count(*) from ar.RA_INTERFACE_LINES_ALL jn; Here we can see , we have not specified the degree of the parallelism.Now there are two cases i. if we have defined degree at the table level, then that degree will be used for parallel processing …

How to check degree of parallelism in oracle & Default Parallelism Read More »

How to migrate Oracle database from Non ASM to ASM storage

Oracle Database can be migrated Non ASM to ASM storage using RMAN command, asmcmd and dbms_file_transfer. With 12c onwards, we can even migrate using the online move datafile command to minimize the downtime. Here in this post, I am concentrating on RMAN methods. How to migrate Oracle database to ASM storage using RMAN There are …

How to migrate Oracle database from Non ASM to ASM storage Read More »

Scroll to Top