Protected: SQL Supporting Partition-Pruning

There is no excerpt because this is a protected post.

Advertisements

Leave a comment

Partition Pruning & Interval Partitioning

One very useful feature about partitioning that is available since version 8 is the possibility of partition pruning. That means, that the optimizer during the parse phase of a SQL statement is able to exclude certain partitions from scanning because according to the definition of the partitioned table present in the Data Dictionary, the desired rows […]

Leave a comment

Oracle 11g Synchronous STREAMS step by step:

We are going to perform the table level replication using Oracle STREAMS (Synchronous) methodology the only option available in Oracle Standard Edition. Make sure following parameters on both source and target are set as below ALTER SYSTEM SET  aq_tm_processes = 1 SCOPE=BOTH; ALTER SYSTEM SET  job_queue_processes = 1000 SCOPE=BOTH; SOURCE: SSDEVDB TARGET: TTQADB SSDEVDB (SOURCE) 1. […]

Leave a comment

Oracle High Availability

Oracle HA Architecture A very popular topic in many of my courses is Oracle Database Architecture regarding High Availability (HA). This page is supposed to address this topic with a high level overview, covering “Ordinary” Single Instance Databases, Data Guard, Real Application Clusters (RAC) and Extended RAC (sometime called “Stretched Cluster”). The combination of RAC and […]

1 Comment

Protected: Brief introduction into Materialized Views

There is no excerpt because this is a protected post.

Leave a comment

Brief Introduction into Partitioning in #Oracle

Partitioning is a great way to deal with large tables. This post will give you a quick start with examples that you can reproduce easily for yourself. Focus will be on Range-Partitioning, which is still the most popular kind. First things first: You should only consider to implement partitioning for really large (GB range or […]

Leave a comment