Tag: dba

can you lock part of a table ?

I should stress that this is all well covered in the documentation, but it was something I stumbled upon just recently. Its common knowledge that you can lock a table: SQL> create table T 2 ( x int ) 3 partition by range (…

Its not about the outage

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m not going to blog about that.  One thing I’ve learnt from many client sites is that people will understand and forgive things like outages,…

Lob CACHE vs NOCACHE – impact on flashback logging

I was doing some work for a client, and LOB processing seemed incredibly slow. After some poking around, it appears that LOB processing is quite sensitive when it comes to flashback mode in the database. Test bench is a simple table with three clobs….