1.
Index Partition Statistics
Something to be wary of when rebuilding partitioned indexes. When rebuilding a normal index, the statistics for that index are not affected as the example ...
2.
Screaming imports
I think the recordlength defaults to 1k if you don't include it along with the direct=y. It can be as large as 64k. On 8.1.7/NT, I tested it a bit and and ...
3.
Index Partition Statistics
Something to be wary of when rebuilding partitioned indexes. When rebuilding a normal index, the statistics for that index are not affected as the example ...
4.
'java_pool_size' in 9i
The resolution was to drop the size of the java pool down to an appropriate ... The DBMS_CDC_PUBLISH is part of the Oracle 9i data warehousing enhancements ...
5.
www.oracledba.co.uk
A collection of hints, tips and observations about the Oracle database. Maintained by Connor McDonald.
6.
www.oracledba.co.uk
A collection of hints, tips and observations about the Oracle database. Maintained by Connor McDonald.
7.
Bitwise operations
Bitwise operations. There is an undocumented 'bitand()' routine you can call, to do logical AND on two numbers. If you need the others, a little boolean ...
8.
Oracle DBA
A collection of hints, tips and observations about the Oracle database. Maintained by Connor McDonald.
9.
Oracle DBA
A collection of hints, tips and observations about the Oracle database. Maintained by Connor McDonald.
10.
Oracle DBA
A collection of hints, tips and observations about the Oracle database. Maintained by Connor McDonald.