Tags » Partitioning

Gossip-based partitioning and replication for Online Social Networks

Our work got accepted at #ASONAM2014


Online Social Networks (OSNs) have been gaining tremendous growth and popularity in the last decade, as they have been attracting billions of users from all over the world. 211 more words

My Conference Presentations on Slideshare

The Oracle OpenWorld 2014 just finished yesterday, but unfortunately I was not able to attend this great conference this year. Perhaps next year – who knows… 108 more words


Sherlock Holmes and Partition Exchange

In my job as an Oracle consultant I sometimes feel like Sherlock Holmes. It’s not always easy to find the evidence or even a logical explanation for a strange behavior of SQL. 690 more words


Partition Exchange and Interval Partitioning

Last week I got an interesting question from a former colleague: How can interval partitioning in Oracle 11g be combined with partition exchange? 758 more words


More about Incremental Statistics

A few months ago I wrote in a blog post that incremental statistics cannot be combined with a small value for estimate_percent. Because this problem is still an issue for one of my customers (who runs a quite big Data Warehouse) I was looking for some additional information about this subject and found an excellent overview in the blog of Randolf Geist:  35 more words


Incremental Statistics - A Mixed Blessing

Incremental statistics are an interesting feature of Oracle 11g to reduce the time for gathering global statistics. But are they a feasible option in large Data Warehouse environments? 814 more words


OLTP Compression, Drop Column, Partition Exchange

With Basic Compression, you cannot drop a column.

create table t1
(col1 number
,col2 number)
table T1 created.

alter table t1 drop column col2;

SQL Error: ORA-39726: unsupported add/drop column operation on compressed tables
39726. 594 more words