feign

I just noticed that gathering statistics on one table partition with above command actually does a full table scan of the whole table (all partitions) instead of gathering only for partition PART2. The command took way too long than it should, which caused me to look at what it was doing. And it appears that … Read more

This wait occurs when there is an unhandled exception in the SQL or PL/SQL code that is being run and en error is being raised. Each error counts as two waits. One for break and the other one for reset.

When using a database link that goes through Oracle Gateways to another vendor database (like SQL Server) you might get an error in SQL Developer that says “Bigger type length than Maximum”. Apparently this is a bug in thin JDBC driver. Workaround is to use thick/OCI driver. Select it in preferences and use TNS to … Read more

The frustration because of lack of command history in sqlplus (or RMAN) finally reached it’s limit. I just couldn’t stand it anymore so with help from google i found this post here which mentions rlwrap utility. rlwrap records history for all lines you enter into a specific program (in our case sqlplus). To use rlwrap, … Read more