AUTOMATED TABLESPACE POINT IN TIME RECOVERY

I have seen people using Flashback Technology more often to restore tables to an earlier point in time. Automatic tablespace point in time recovery is an other option which we can use to recover one or more tablespaces to an earlier point in time at the same time retaining other tablespaces and objects as it […]

Read the rest of this entry »

Getting hold with Oracle Database 11gR2 RAC

Oracle Database 11gR2 MOS Notes Doc ID 1232802.1 RAC One — Changes in 11.2.0.2 Doc ID 1312225.1 Things to Consider Before Upgrade to 11.2.0.2 Grid Infrastructure Doc ID 1267828.1 SYS Password Management with RAC and Data Guard Doc ID 1276368.1 Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2 Doc ID 341880.1 How to […]

Read the rest of this entry »

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 Universal Content Management (UCM) Upgrade from 10g to 11g

Step by step process to upgrade UCM 10g to 11g i.e to fusion infrastructure. These steps are exact replica from the upgrade that I performed prior implementation at customer site. 1.   Install Webcenter 11g Suite Install 11g Webcenter Suite and create a domain for UCM and check whether UCM 11g Admin console is coming up […]

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 »

Oracle 8i to 11g – hidden features.

Every release contains many new features and enhancements that are not highlighted in the marketing material. Oracle assumes all customers will move on to new versions when they are released. Here are few examples of those – New  features failed to spot. DBMS_SYSTEM.KSDWRT undocumented package installed in all databases Used to write messages to trace […]

Read the rest of this entry »

Fusion DBA Certifications

Here are certifications to take up and get ready for the emerging market of Fusion DBA / SOA Admin / Fusion Architect 1Z0-108 : Oracle WebLogic Server 10g System Administration 1Z0-541 : Oracle WebCenter 11g Essentials 1Z0-545 : Identity Administration and Analytics 11g Essentials 1Z0-451 : Oracle SOA Foundation Practitioner 1Z0-543 : Oracle Application Integration […]

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 »