A quick overview of diff_table*

10.2.0.4 came with some 11g features, an extended dbms_stats package. I had made some basic demonstraions below.

Parallelism Partitioning CBO issue

Parallelism and partitioning are two excellent features of Oracle. What is the relation between CBO and these two guys? Well I catch some issues. First of all lets create a table with range partitioning:

SQL> select version from v$instance;
VERSION
—————–
10.2.0.1.0

CREATE TABLE part_table
PARTITION BY RANGE (c1)(
PARTITION p1 VALUES LESS THAN (100000),
PARTITION p2 VALUES LESS THAN (200000),
PARTITION p3 VALUES [...]

After another workshop of OracleTurk

I had my 2 presentation this weekend. It was a fantastic book of Lewis, CBO optimizer. I had met possible future interns of Turkcell. After nearly 10 session they got really confused . During my first session, “Selectivity issues”, I showed my own examples. Since the topic is issues, we really dealt with lots [...]

Nested Loop / Hash / Merge over Event 10053 trace file

One of my colleague asked me about how he can write better SQL. Despite he is a java developer, I appreciate his will to understand database. When I said, “I really can not teach you this in ten minutes”, he lost his will. Any way, Lets talk about 10053 trace file. Oracle dumbs its execution [...]

chapter 2 – calc_mbrc.sql

rem
rem Script: calc_mbrc.sql
rem Author: Jonathan Lewis
rem Dated: March 2002
rem Purpose: [...]