Oracle Primavera P6 Architecture

Primavera P6 Primavera provides a set of integrated components that meet the project management needs of different areas of an organization. It uses standard Windows interfaces, Web-enabled technology with application server and database support. Primavera P6 can be implemented on a standalone or client/server machine. For the client/server implementation requires the installation and configuration of […]

Read the rest of this entry »

Installing Oracle WebLogic Server 11g

WebLogic Server 11gR1 (10.3.0) Oracle WebLogic Server forms part of Oracle Fusion Middleware portfolio and supports Oracle, DB2, Microsoft SQL Server, MySQL Enterprise and other JDBC-compliant databases. Oracle WebLogic Platform also includes: Portal which includes Commerce Server and Personalization Server WebLogic Integration WebLogic Workshop, an Eclipse IDE for Java, SOA and Rich Internet applications JRockit, […]

Read the rest of this entry »

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 High CPU Consumption on Oracle server

For any performance tuning issue, our strategy in diagnosing the problem is to take a “top-down” approach and follow the trail of highest CPU consumption down to the offending processes, and eventually the offending sessions and query. Verify CPU Consumption on the server is the first step any DBA should do for a top-down approach […]

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 »

Tuning indexes on RAC environments-2

Globally busy buffers due to contention for index leaf and branch blocks As we discussed in previous sessions, because of batch INSERT high concurrency could occur for a relatively small set of index leaf and branch blocks, where index keys are populated with monotonically ascending values.The symptoms are increased frequencies and wait times for a […]

Read the rest of this entry »

Tuning indexes on RAC environments-1

Introduction and Significance of tuning indexes in RAC environments. Oracle E-Business environment with financial modules like AP and GL having large scale payment invoices transaction. Let me take example of one my public sector clients, they do process of 3 million payment instructions every night. Such most insert intensive applications running on RAC the frequency […]

Read the rest of this entry »

Index Performance Tuning Techniques for RAC

It’s been quite some time since my readers are requesting to see some posts on RAC performance tuning concepts and practices. In the process of testing some of the tuning techniques, as well as discussing and interpreting the results, I am preparing a four-day in depth session to understand index performance tuning techniques for RAC. […]

Read the rest of this entry »

adpatch options

adpatch options Few of our dbas are still not clear about the helpful features of adpatch utility with command line options.If you are in a production downtime to do some patching activity, especially for some rollup upgrade, your downtime will end up with series of pre and post patches. In Such a scenario, it is […]

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 »

Gather Schema Statistics with LASTRUN Option does not Clean FND_STATS_HIST Table

After running Gather Schema Statistics concurrent request with (LASTRUN) option to save only the history for last run, then run the concurrent request again for 2 times after that found that (FND_STATS_HIST) tables contains the history for all the 3 requests and it is not cleaned up to keep only last run. Sample steps to […]

Read the rest of this entry »