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 statistics is […]

Popularity: 6% [?]

read more from this topic.....

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 (JVM) including Database.
AD4J Console listen […]

Popularity: 5% [?]

read more from this topic.....

 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 users […]

Popularity: 5% [?]

read more from this topic.....

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 server […]

Popularity: 8% [?]

read more from this topic.....

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 […]

Popularity: 8% [?]

read more from this topic.....

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 and enable the schedule […]

Popularity: 13% [?]

read more from this topic.....

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 to rebuild […]

Popularity: 6% [?]

read more from this topic.....