Oracle EBS is set of many application. The technology stack consists of Application filesystem, database and IAs server. We often need to patch it either to fix a bug or upgrade it. This article we are presenting the basics of patch and how patching is done in Oracle EBS environment What is patch ? When […]
Oracle patching: Adpatch Complete Overview Read More »
AD Utilities(adadmin, adrelink ,adident,ADMRGPCH) are integral part of Apps DBA job. These are required in managing the EBS instance as per the requirement and needs. I will be discussing Four AD Utilities in this section adadmin, adrelink ,adident,ADMRGPCH There are various other AD Utilities line adctrl,adpatch,adop ,I have written seperate articles for each of them as
AD Utilities(adadmin, adrelink , adident, ADMRGPCH) Read More »
The good php File Manager allows you to manage your site through HTTP rather than an FTP tool or other third-party application. You can upload, create or delete files, organize files in folders and change file permissions. Folders and files may be displayed in a hierarchical tree based on their directory structure. Some php file
Awesome 10 good php file manager Read More »
ORA-27154 is a quite a common error which many DBA face in day to day activites.I am trying to share what i have learned to resolve it .We are starting the Oracle database and We receive below error while starting up the database SQL> startup ORA-24323: value not allowed ORA-24323: value not allowed SQL> startup;
ORA-27154 / ORA-27146 Read More »
What is Nested Loop Join in Oracle -For each row in the first row source access all the rows from the second row source.-The NESTED LOOPS Join is a join operation that selects a row from the selected beginning row source and uses the values of this row source to drive into or select from the
Nested Loop Join in Oracle 11g Read More »
What is hash Join in Oracle? Hash joins are used when the joining large tables or when the joins requires most of the joined tables rows. This is used for equality joins only Algorithm for Oracle Hash Join 1) The optimizer uses smaller of the 2 tables to build a hash table in memory.Small table
Hash join in Oracle with example Read More »
