Oracle library cache tuning – A Real Case Study.

I have made a few comments in previous posts about the latch: library cache and playing with cursor parameters that can introduce surprises; Here is another one library cache tuning – A Real Case Study. Scenario : Users started complaining about very poor application performance, hung and incomplete transactions. Some severity one ticket for immediate […]

Read the rest of this entry »

Oracle Hanganalyze Performance Problems “sqlplus -prelim”

Hanganalyze / Librarycache contention Last week I was called up to  help to resolve one of the production database hung issue. This totally screwed the database by all means  [ Database connections were hanging, Connections on the server using SQL*Plus as sysdba was also hanging, EM grid was spinning ] Dammn totally stuck …. you […]

Read the rest of this entry »

Oracle 11g New Feature Causes AMM to Restart

This post is from one of the emails I have recieved from my friend Mackenzie D’Cruz, he experienced this issue on his production environment. This information is published by Don Burleson at http://www.dba-oracle.com. So this is just a copy to let our readers know about this issue. Beware, following new upgrades to 11gR2, you can […]

Read the rest of this entry »

Oracle DBA Silver Bullets – Performance Queries

Just thought to share few queries from my repository. It may be useful for all new DBAs. Of course these are quite old ones and you can do most of them through Enterprise Manager, still we DBAs always like command line Show sessions that are blocking each other : select ‘SID ‘ || l1.sid ||’ […]

Read the rest of this entry »

Real Application Testing Oracle RAT 11g

What is the critical concern when we need to make a change in the production database ?  The biggest concern is the risk of the change – “mess up” something. Even the most minor changes can have an awful effect, eventually producing a visible impact. In Oracle Database 11g, We have a new feature called […]

Read the rest of this entry »

Tips to Maximize performance and scalability of Oracle E-business Suite 11i

Application Tier: Forms Forms performance issues may arise when dead connection persists on the server and consuming the server resources. Enable the forms dead client connection can eliminate the dead connection. FORMS60_TIMEOUT=10 (recommended value and value specified in minutes) Do $ ps –ef| grep f60webmx and terminates f60webmx processes for dead clients. Enable Forms Abnormal […]

Read the rest of this entry »

Oracle Fusion Applications

Oracle Announces Oracle Fusion Applications Oracle Applications Strategy Oracle Fusion Applications Oracle Fusion Applications Design Principles Oracle Fusion HCM Oracle Fusion CRM Oracle Fusion Financials Oracle Fusion SCM Oracle Fusion Project Portfolio Management Oracle Fusion Procurement Oracle Fusion GRC Oracle Images and Screenshots on Flickr

Read the rest of this entry »

Oracle Application Server Vs. Oracle WebLogic Server

Are you working with Oracle Application Server ? If you are familiar with the architecture of Oracle AS then a comparison study would be easy to grasp the Weblogic concepts. Here are some of my observations during my Weblogic study phase – This way it is easy to remember basics. Architecture Comparison In Oracle AS […]

Read the rest of this entry »

How to change ASM SYS Password and Creating SYSASM user 11g.

Things tried: SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We can not change the password for ASM databases via alter user command.Because passwords are managed through password file […]

Read the rest of this entry »

Oracle WebLogic Server 11g – JVM Diagonostics – Sun JVM & JRockit JVM

Java Virtual Machine (JVM) : The Java Virtual Machine (JVM) is a virtual “execution engine” instance that executes the bytecodes in compiled Java class files. Java programs are compiled into a form called Java bytecodes. To the JVM, a stream of bytecodes is a sequence of instructions. Tuning the JVM to achieve optimal application performance […]

Read the rest of this entry »

Fusion Middleware Overview – Become a Fusion DBA

Fusion Middleware – Portfolio of Oracle Middleware Products Here are the Fusion Middleware  family of products Application Server – Java EE 5.0  Containers SOA Suite – Integration and Process Management User Interaction – Web Center and Portal Identity Management Suite – Broad range of IM products Business Intelligence – Platform for BI and Data Warehousing […]

Read the rest of this entry »

Oracle Application Integration Architecture (AIA) Foundation Pack

Oracle Application Integration Architecture ( AIA) FP: Oracle Application Integration Architecture (AIA) Foundation Pack to integrate heterogeneous application portfolio to build cross-functional business processes. Foundation Pack will help to overcome the most common yet critical application integration challenges by providing you with a set of prebuilt enterprise objects and services, application integration management infrastructure and […]

Read the rest of this entry »