Oracle E-Business Suite 11i to R12 Quick Transition

Here are some capsules for Oracle E-Business Suite 11i to R12 knowledge transition. Tech Stack Client Sun 1.5 Plug-in Middle Tier Application Server 10.1.3 Application Server 10.1.2 $ORACLE_HOME version (prev 8.0.6): /orachat/product/tech_st/10.1.2 $ORACLE_HOME version (prev 8.1.7): /orachat/product/tech_st/10.1.3 RDBMS Tier Oracle 10g R2 XDK XDB Scripts Also you can refer my previous post @ onlineappsdba …….. […]

Read the rest of this entry »

Tuning indexes on RAC environments-4

Excessive undo block shipment and contention for undo buffers I have seen this scenario in one my projects where  Oracle EBS workload is high. When a select statement needs to read a block with active transactions, it has to cleanout the block and undo the changes to create a CR version. If the active transactions […]

Read the rest of this entry »

Tuning indexes on RAC environments-3

Reversing the index key This is accomplished by executing the following SQL statement: ALTER INDEX <index_name> REBUILD REVERSE; A reverse key index will invert the bytes of the index key column, so that values originally stored in the same block may be spread across multiple index leaf blocks. That will reduce buffer busy contention especially […]

Read the rest of this entry »

Oracle Dictionary – DBA Views – Quick Reference

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE ‘DBA_%’ ORDER BY TABLE_NAME; TABLE_NAME COMMENTS —————————— —————————————————————————————————- DBA_2PC_NEIGHBORS – information about incoming and outgoing connections for pending transactions DBA_2PC_PENDING – info about distributed transactions awaiting recovery DBA_ADVISOR_ACTIONS – DBA_ADVISOR_COMMANDS – DBA_ADVISOR_DEFINITIONS – DBA_ADVISOR_DEF_PARAMETERS – DBA_ADVISOR_DIRECTIVES – DBA_ADVISOR_FINDINGS – DBA_ADVISOR_JOURNAL – DBA_ADVISOR_LOG – DBA_ADVISOR_OBJECTS – DBA_ADVISOR_OBJECT_TYPES – […]

Read the rest of this entry »

New patch required after installing PSU 11.1.0.7.1 to ASM environments

An ASM Regression issue has been reported with 11.1.0.7.1 PSU. A Mandatory patch is being recommended to resolve the ASM regression issue. There is very high possibility of running into the ASM regression issue with 11.1.0.7.1 PSU. No action is required if ASM is not being used in the environment Some of the symptoms are: […]

Read the rest of this entry »

Oracle Support – Useful Metalink References

Patch Set Updates for Oracle Products [ID 854428.1] Quick Guide to Avoid Issues in Creating DB Control Using EMCA [ID 750768.1] Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1] Oracle E-Business Suite Recommended Performance Patches [ID 244040.1] CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1] Cloning Oracle Applications Release 11i […]

Read the rest of this entry »