We can find the various patch levels using the table ad_trackable_entities in Oracle Apps R12.2. In this post, we will see How to find ad and txk patch levels, how to check the delta level in r12, how to check fwk in r12.2 Here is the definition of the Table ad_trackable_entities How to find ad …
How to find ad and txk patch level Read More »
The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as a post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it …
We may get a failure while running the managed backup on the ExaCS system. Let’s see How to troubleshoot backup Failures in ExaCS (1)Identification of the error We need to first find out what is the error for the backup. We can check those in the backup log files. You can find the backup log …
Oracle Provides Automatic Managed Backup Service on ExaCS Machine. Oracle completely managed the Backup of the database on the customer’s behalf. It stores the backup in DBaaS tenancy, not the customer tenancy How to configure Automatic Managed Backup Step 1Open the navigation menu. Choose your Compartment.Step 2Under Oracle Exadata Database Service on Dedicated Infrastructure, click …
How to configure Automatic Managed Backup on ExaCS Read More »
Statistics played in key role in Oracle performance tuning. Oracle Optimizer creates the execution plan based on the statistics of the Oracle table involved in the SQL queries. You may want to lock statistics in an Oracle table in some cases, for example There could be many more cases where we want to lock statistics …
How to find the table where statistics are locked in Oracle Read More »
We often need to find and delete duplicate rows from the Oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to delete duplicate rows but keep the original.I will be showing off a few faster methods to achieve it in …
delete duplicate rows from Oracle Read More »
