What is duplicate using the Active database : Active database duplication copies the target database over the network to the destination and then creates the duplicate database. Only difference is you don’t need to have the pre-existing RMAN backups and copies. The duplication work is performed by an auxiliary channel. This channel corresponds to a […]
RMAN DUPLICATE DATABASE CLONING WITH ACTIVE DATABASE Read More »
To Troubleshoot Workflow Notification Mailer issues, we need to understand how outbound and inbound processing works Outbound Notification Processing – -Creation of Workflow notification raises oracle.apps.wf.notification.send event.-This event is deferred immediately and placed on the WF_DEFERRED agent.-Workflow Agent Listener on the WF_DEFERRED queue processes the deferred subscription.-Subscription to this event calls the Generate function (WF_XML.Generate)
Troubleshooting Workflow Notification Mailer issues Read More »
R12.1/R12.2 is a pretty big and time-consuming upgrade. We need to find all the long-running sql to resolve the R12.2 upgrade performance issues. Since each iteration takes a lot of time, it is important, that we try to find out the performance issues in fewer iterations and fix them accordingly Here are Top AWR useful queries to
Top AWR useful queries for R12.2/R12.1 Upgrade Read More »
What is Virtual Index in Oracle ? A virtual index is a “fake” index whose definition exists in the data dictionary, but has no associated index segment. Many time sql tuning advisor recommends you creating new index and you want to test the new index. In this case It can take good amount of time
How to use Virtual Index in Oracle Database Read More »
How to check logs in adop The adop log files are located on the non-editioned file system (fs_ne), under: s_ne_base/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log For example, if s_ne_base was /u00/app/TECHGO/fs_ne, the session ID was 10, and the <CONTEXT_NAME> was techgo_server, the path to the adop log files from 1th May 2016 would resemble this: /u00/app/TECHGO/fs_ne/EBSapps/log/adop/10/apply_20160501_101121/techgo_server Each cycle of adop
adopscanlog log analyzer utility in R12.2 Read More »
How Incremental statistics works Incremental global statistics work by storing a synopsis for each partition in the table. A synopsis is a statistical metadata for that partition and the columns in the partition. Each synopsis is stored in the SYSAUX tablespace. Global statistics are then generated by aggregating the partition level statistics and the synopses
Incremental Statistics Gathering Read More »
