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 [...]