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