In relation to Oracle workflow processes in EBS environments ‘Workflow Background Engine” essentially is a PL/SQL procedure which checks for and executes any deferred or timed out activities that satisfy the arguments of the procedure at the time the procedure is invoked.
1 CommentExpert Oracle Posts
Some of the key reasons which attributes to database performance issues are mentioned below:
Below post is based on Oracle Documentation
1.Bad connection management
The application connects and disconnects for each database interaction. This problem is common with stateless middleware in application servers. It has over two orders of magnitude impact on performance, and is totally unscalable.
Leave a CommentWhen you are faced with any database related performance issue before you begin troubleshooting it is important to first have some basic ground work done. Below are some key points which should be thought upon before doing actual troubleshooting
2 CommentsWe faced one issue in our Oracle EBS R12 where users reported that Concurrent request log and output files are not displaying instantly but are showing up after few seconds of delay.
Same situation was faced when trying to open any manager log files. Since log/out were opening up fine, albeit with some delay, so RRA/FNDWR setup was evidently fine.
Leave a CommentWe had seen one issue in EBS R12 in which simple report porgamrs like “Active users” were throwing erorrs like below:
Enter Password: REP-0118: Unable to create a temporary file. REP-0189: Cannot write to Reports Server cache REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-189: Cannot write to Reports Server cache this is the error in Log file APPLLCSP Environment Variable set to : Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are : American_America.UTF81 Comment
For Apps DBA sometimes it is necessary to decrypt the EBS Application user’s password. Below package can be used to decrypt the FND_USER password. You will need password of “apps” database userid to be able to decrypt the application user’s password.
5 CommentsA) CREATE STAGING TABLE
First Create the staging table which will hold sql profiles to be moved over.
SQL> exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name=>’SQL_STG_TAB’,schema_name=>’SYS’);
(This will create a table SQL_STG_TAB, which will be able to hold the required sql profiles, the structure of this table is exactly same as that of DBA_SQL_PROFILES table)
Leave a CommentOracle Database supports the export and import of SQL plan baselines using the Oracle Data Pump Import and Export utilities. Use the DBMS_SPM package to define a staging table, which you can use to pack and unpack SQL plan baselines.
To import a set of SQL plan baselines from one system to another:
10 CommentsSometime DBAs need to create SQL Baseline for particular SQL_ID for plan stabilization
1) VERIFY CURRENTLY EXISTING SQL PLAN BASELINES
select * from dba_sql_plan_baselines;
7 Comments
Tuning task for specific SQL_ID can be created by SQLTRPT very easily.
Manual way is also documented below:
Leave a Comment