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 moregather_table_stats granularity
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 moreSQL Developer and database links through Oracle Gateways
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 moresqlplus history
If you are for some reason moving your database from 32-bit to 64-bit server, a simple copy-paste is not enough. PL/SQL packages are compiled with one word size on 32-bit server and need to be recompiled on 64-bit or the following error might appear: ORA-06553: PLS-801: INTERNAL ERROR . Metalink note 62290.1 describes in detail … Read moreMoving between 32-bit and 64-bit server