Main-Performance

Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Category archives for: Main-Performance

SQL Server 2008 – Using Query Hashes and Query Plan Hashes

In this post we will discuss SQL tuning methods by using DMV (sys.dm_exec_query_stats and sys.dm_exec_requests) and how to use Query Hashes and Query Plan Hashes in SQL Server 2008.

December 5, 2010 | Posted in Main-Performance, SQL Server, SQL Server - Latest Articles | Read More »

Oracle 11g Performance Features

Oracle 11g brings us many performance related features. In this article we will cover several of these features.

November 13, 2010 | Posted in Main-Performance, Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »

Analyzing Oracle AWR reports – top 5 events

This is the first post related to analyzing AWR reports. We will focus on the “top 5 events” of the page, what is the importance of this part and understanding some of the main wait events.

August 17, 2010 | Posted in Main-Performance, Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »

Shrink Oracle Tables Online

Oracle 10g Supply a new alter table option that enables online table reorganization, this option is shrink

February 7, 2010 | Posted in Main-Performance, Oracle, Tips & Tricks | Read More »