Category Archives for performance

OAM server gets shut down automatically : fork: Resource temporarily unavailable

Hi All, Today I ‘m very happy to share some information regarding a show stopper issue which I faced few days back in production box. The issue was  when the load gets increased in the server , OAM server gets shut down Automatically. For more information, Please go through below : Problem Description: We are […]

Read More

Use nested groups with caution in Oracle Access Manager for authorization

One can specify which users/groups can be authorized to access an application using Oracle Access Manager. In general there are 3 types of group memberships allowed in the directory server: Static group membershipIn this type of group, each user is explicitly defined as a member. Dynamic group membershipThis type of membership is defined by an […]

Read More

Real Application Testing Oracle

1.       Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then it was back ported to other version including oracle 9i .  In our Eaga specific scenario we have oracle 9.2.0.7 EBS database and we have 11g database with OEM grid cntrol . The real advantage […]

Read More

Custom Schemas are not analyzed when Gather Schema Statistics are submitted.

Concurrent –> Request –> Submit Request –> Gather Schema statistics (Paramerters “ALL”)The above request gathers statistics for all schemas , however it skips custom schemas registered in Oracle Applications.Explaination : Whenever Custom schemas are registerd in Oracle Applications , the entries are done in 2 tables ie FND_ORACLE_USERID and FND_APPLICATIONS_TL However , when Gather schema […]

Read More

JADE / AD4J – Application Diagnostics for Java : Architecture / Installation and Configuration

AD4J – Application Diagnostics for Java JADE – Java Application Diagnostics Expert Application Diagnostics for Java (AD4J aka JADE – Java Application Diagnostics Expert) is lightweight application to diagnose performance issues in Java Applications (including Database Tier) . AD4J Architecture 1. AD4J Console : is web based console to setup/monitor performance of Java Virtual Machine […]

Read More

Which Diagnostic Tool should I use for Fusion Middleware Performance Tuning ?

 Today’s post is little different from my other posts as I need your help to identify right diagnostic tool for performance issues in Oracle Fusion Middleware (10g & 11g). Issue : My client is using Oracle Fusion Middleware; 10g R2 (Portal/SSO/OID), 10g R3 (custom J2EE application) and 11g R1 (SOA on WebLogic). Application response time is acceptable for approx. 200 concurrent […]

Read More

Oracle Exadata Storage

Oracle Exadata Storage Server The HP Oracle Exadata Storage Server is a storage product highly optimized for use with the Oracle database. Exadata is a combination of software and hardware used to store and access the Oracle database. It provides database aware storage services, such as the ability to offload database processing from the database […]

Read More

JVM Tuning (Garbage Collection) in Oracle Apps 11i

There are some good notes on JVM tuning from Mike Shaw on Steven Chan’s blog  here , here and here and some good Metalink notes at end of this post.                      Important thing missing from all these notes (for some one like me who is new to Java) is basics of Garbage Collection, Generation and how to […]

Read More

AWR (Advance workload Repository)Report in Oracle 10G

AWR is an enhancement/upgradation of statspack, which help us to tune the database. Oracle Database 10g uses a scheduled job, GATHER_STATS_JOB, to collect AWR statistics. This job is created, and enabled automatically when you create a new Oracle database under Oracle Database 10g. GATHER_STATS_JOB, to collect AWR statistics every 1 hour . We can disable […]

Read More

Validating and rebuilding large and fragmented indexes in 11i

You can have various methods to identify the large or fragmented indexes in 11i or you can just configure the Oracle Alert to receive a mail. This alert is scheduled to check the situation periodically say daily at mid night. The alert ‘Indexes too large or fragmented‘ is pre-defined alert. There are three possible ways […]

Read More
[i]
[i]
[i]
[i]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]