What is Optimizer Mode Optimizer is the mind of the Oracle engine and it decides the execution plan of the sql queries to be executed. Optimizer has different mode and Optimizer Mode in the parameter which is used to specify the different modes Set in the Init.Ora Can be changed via ALTER SESSION CHOOSE, FIRST_ROWS, …
Oracle ASM Diskgroups Once the disks are discovered, a diskgroup can be created that will encapsulate one or more of these disks. It is collection of disks that can managed as logical unit.A diskgroup, which is the highest-level data structure in ASM, is comparable to a LVM’s volume group.The creation of a diskgroup involves the …
Oracle ASM Diskgroups : Create and Alter diskgroup Read More »
What is Active Session History(ASH) Active Session History (ASH) was introduced in Oracle 10g. It samples the activity of each active database session every second. The data is held in a buffer in memory in the database.The design goal is to keep about an hour (your mileage will vary). If a session is not active …
10 Useful queries Active Session History(Oracle ASH) Read More »
how to send output of concurrent program through email With R12.1.3, we can configure delivery option while submitting concurrent request.Delivery options could be the mail of the user which submitted the request. So user will get notified on completion of request Following need to be set to enable delivery optionSet the profile options “FND:SMTP Host” …
Delivery Option while Submitting Concurrent Request In R12.1.3 Read More »
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 …
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 »
