Category Archives: Performance & Tuning

SQL, instance & server Tuning, statistics, locks,etc

Exadata workshop – impressions and notes

I have read articles and specs on Exadata before, but now I have had the opportunity to assist to an Exadata Hands-On workshop. I’m writing these impressions without talking too much about the specs, they are everywhere, some links here. … Continue reading

Posted in High-Availability, Oracle Server, Performance & Tuning | Tagged , , , , | Leave a comment

Oracle Widgets for the Grid Control / Oracle Enterprise Manager

Oracle desktop Widgets for the Grid Control Continue reading

Posted in Monitoring, Oracle Server, Performance & Tuning | Tagged , , , , , , | Leave a comment

Finding a locking session

How to identify lockers This article will explain about locks on rows and on objects in ORACLE. Locks on rows can cause performance problems or even impede a transaction from finishing, when there are processes running for long time we … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , , | 4 Comments

Oracle Unveils Exadata Version 2: The First Database Machine for OLTP

The new Exadata 2, full with the SUN branding on it now brings new technology like theĀ  Sun FlashFire cards: “Exadata Smart Flash Cache addresses the disk random I/O bottleneck problem by transparently moving hot data to Sun FlashFire cards. … Continue reading

Posted in High-Availability, Oracle Server, Performance & Tuning | Tagged , , | 1 Comment

Tips for DBMS_STATS (Part 2/2)

The second part of this post includes taking statistics on partitioned objects and how aggregated statistics work. If you want more detail on DBMS_STATS go to the first part of this post, where you will find info on stale statistics … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , , , , | 15 Comments

Tips for DBMS_STATS (part 1/2)

Taking statistics and have them updated is a very important task on most Oracle databases, the CBO (Cost Based Optimizer) evaluates the cost of several Execution Paths, this cost is mainly based on physical and logical Disk IO, CPU use … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , | Leave a comment

Main parameters to setup a Transparent Gateway connection to SQL Server

Hi, I would like to share with you the parameters that worked out for me when connecting to a SQL Server database. Please consider that I am not explaining in detail how to set up a transparent gateway connection to … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , , , | Leave a comment