You can also view the Oracle application post in more ordered manner at below link
New Optimizer Feature with 11g (1) Invisible indexes With an 11g release, the index can be made invisible. They will be maintained all the time and can be made visible at any time alter index K invisible; Optimizer will not use the index if it is invisible alter index K visible; If want one query …
New Optimizer Feature with 11g,12c and 19c Read More »
In this post, we will talk about one of the useful things that administrator often has to use. The topic is How To Get environment variables of running process Linux. Let’s first start with what is environment variable and then find out How To Check Environment Variables for a Running Process in different flavours of Unix system …
How to Get environment variables of running process in Linux 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 …
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 …
Types of jobs and their resolutions .odf files : -odf files are there to create tables, indexes and views etc.-If encountered locking, identify the session that holds the lock and kill the session. Do not skip the job because of locking. Sometimes odf failed to drop the index. then you can manually drop the index …
Troubleshooting adpatch/adop failed job Read More »
