Category Archives for performance
[BLOG] Introduction to Performance Tuning In Oracle Database
Are you an Oracle database Admin? Are you worried about your users complaining about the slow online performance of the system? [BLOG] Introduction to Performance Tuning In Oracle Database Visit: https://k21academy.com/tuning11 & learn about Performance Tuning, which is one of the best ways to identify bottlenecks and ensure your infrastructure is equipped to handle increased […]
Read MoreOAM 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 MoreUse 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 MoreReal 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 MoreCustom 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 MoreJADE / 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 MoreWhich 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 MoreOracle 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 MoreJVM 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 MoreAWR (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