Author Archives

Unusable index

After table maintenance, like move or split partition, underlying indexes are marked as unusable.
This boils down to segment reorganisation, not dictionary change.
For instance :

CREATE TABLE t(x NUMBER)
PARTITION BY RANGE(x)
(PARTITION p1 VALUES LE…

Did you forget to run root.sh?

Not easy to detect, and depending on the product (agent/database), it may have only limited side effects.
Like external jobs not running, operating systems statistics not collected.
But it is not always easy to diagnose.
For instance if you patch from…

Happy new year

I just added a few features to WordPress, please report any bug and test your comments here.
Thanks

anonymous cypher suites for SSL (and a 12c pitfall)

If you configure your listener for encryption only, you do not really need authentication.
It works pretty fine until 11.2.0.2, I wrote multiple posts on ssl.
You add SSL_CLIENT_AUTHENTICATION=FALSE to your server sqlnet.ora and listener.ora and spec…