2010 December | dbsnaps

Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Archive for: December, 2010

Oracle 11gR2 New Feature – Deferred Segment Creation

In this DBSNAPS tutorial video we will present you a new feature of Oracle database 11gR2: Deferred segment creation.

December 6, 2010 | Posted in Administration, Oracle, Oracle - Latest Articles, Videos | Read More »

Parallel New Features in Oracle 11gR2

Oracle 11gR2 brings us new features related to parallelism.
The new features are controlled by the PARALLEL_DEGREE_POLICY initialization parameter. Learn how to use these new features to leverage your needs.

December 6, 2010 | Posted in Administration, Oracle, Oracle - Latest Articles | Read More »

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 »