Adop phase prepare is the first phase in Online patching cycle in R12.2 . Adop perform lots of action items in the phase.Here is the sequence of activities 1.Checks whether to perform a cleanup, which will be needed if the user failed to invoke cleanup after the cutover phase of a previous online patching cycle. […]
what happens in the adop phase prepare Read More »
R12.2 upgrade is a big upgrade with lot of technology changes.To save some time during the upgrade process and reduce the downtime, Oracle process few update as part post-upgrade concurrent programs. This article gives description about Isolating post-upgrade concurrent programs R12.2 1)The downtime portion of the upgrade involves the automatic submission of 95 distinct concurrent programs. 2) These
Isolating post-upgrade concurrent programs to a separate manager queue in R12.2 Read More »
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 »
