DBA Tools

Oracle Compress Table Block Format (3)

    The compress block format seems not so much complex as I expected. After spent few hours, I can get the same dump information from AUL as dump datafile command do. Left side comes from Oracle dump datafile command,...

Posted on November 1, 2007 3:19 PM

Oracle Compress Table Block Format (2)

    In previous test, I just create table with two columns, how about for a table with a lot of columns? The basic block format does not change, the key is how to extract the rows. I get one...

Posted on October 30, 2007 10:38 PM

Oracle Compress Table Block Format (1)

    Oracle compress table is an new feature since Oracle 9i, it could save you a lot of storage, I have seen this new feature used in data warehouse. In oracle 9i, compress table have some bugs, for example...

Posted on October 30, 2007 9:26 PM

lslog -- read basic information form archived log file

    How to get the first SCN, next SCN, first time, next time of archived log? the first way should be check rows from V$LOG_HISTORY or V$ARCHIVED_LOG, but these view just keep information of few latest archived logs, it...

Posted on October 10, 2007 11:08 AM

Using UltraEdit macro to format the HTML when bloging.

    When posting scripts or query result to blog (Many DBAs have personal blogs), I always use an UltraEdit macro to format it, it will give us good text align. The macro defination is very simple, first step is...

Posted on September 8, 2007 2:05 PM