Oracle database is a complex system and objects are inter-related and have dependencies.Like a package may depends on certain oracle table or view or synonym. So objects may go invalid in case of deployments of new objects , alter table command, packages,views, synonyms. Now lets find out how to find the invalid objects in the […]
Oracle Performance tuning Glossary
Here is the glossary on Oracle Performance tuning. It is quite complex and interesting topics. Oracle performance tuning need through analysis and knowledge of all the aspect of Oracle database Autotrace Autotrace is beautiful tool provided by Oracle for getting the explain plan and execution statistics. You need to know the query and its bind variable […]
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 migrate Oracle database to ASM storage
Oracle Database can be migrated 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 two cases […]
Oracle EBS file system(Product Top)
Oracle EBS environment has many product directories inside APPL_TOP and Each Product directories has many directory and files inside them. We have more than 200 product directories and Each of these has similar structure. I have studied them and here is my take on these directories. General Directory Structure of any Product_TOP . I have […]
Socket mode for forms in R12
Introduction Forms by default run in Servlet mode in R12 and above as this is the preferred and recommended deployment model for deploying forms on the web. In this mode, there is a java Servlet called the Forms Listener Servlet, manages the communication between the Forms Java Client and OracleAS Forms Services. The Forms Listener […]
