WebAdi Download Is Failing Intermittently performance issue
The download of WEBADI is taking too long and has a Performance issue. It takes 1 minute to 8 minutes when users expect 8 seconds to 30 seconds. The user…
Read MoreUpgrade Excel To 2013 64-bit Error ‘The code in this project must be updated for use on 64 bit systems’ Uploading Data To WEBADI Template
After upgrading Microsoft Excel to version 2013 64bit, when uploading data to the template WEBADI, the template is blank. However when looking at the Excel Macro Information, the following Error…
Read MoreWEB ADI Performance Issue When Data Entry Rows is High
WEB ADI Performance Issue When Data Entry Rows is High While updating the Data Entry Rows in the Lines section to 30000, then the upload takes a long time (10…
Read MoreForms memory consumption
The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…
Read MoreScript to Bounce EBS Middletier in EBS 12.2
In an earlier version of EBS (R12 and 11i) – restarting middle-tier services is quite simple though application running in multiple nodes. Starting from EBS 12.2, OACORE, FORMS and OAFM…
Read MoreScript to collect all the required information for understanding the Concurrent Processing workload on a system
REM HEADER REM $Header: cp_analyzer.sql v1.01 MCOSTA $ REM REM MODIFICATION LOG: REM REM MCOSTA REM REM Consolidated script to diagnose the current status and footprint of Concurrent Processing on…
Read MoreQuery to generate Baseline Script for a SQL_ID in Oracle Database
Please use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreSteps to Export and Import AWR Stats
Please find the steps to export and import AWR stats. Exporting AWR snapshot data:- ***************************** SQL> @?/rdbms/admin/awrextr.sql AWR EXTRACT **************************************************** This script will extract the AWR data for a range of snapshots into a dump file. The script…
Read MoreSteps to Backup and Restore Java Classes and Privileges only in Oracle Database
The following SQL script, when run as user SYS, will generate an ordered script to recreate all the java grants, and java policies, assigned to users. It does not generate…
Read MorePurge AUD$ Table
The AUD$ table growth will impact the performance of database so we want to purge it regularly by using the DBMS_AUDIT_MGMT package Check AUD$ table is not in SYSTEM table tablespace.…
Read More