DBA Tools

Get Oracle DDL Script

    A lot of DBAs are extracting DDL (table create) script with Toad and PL/SQL Developer utilities. But a lot of database are running on Linux or Unix hosts, and connections directly from desktop are not allowed, then it...

Posted on December 24, 2007 7:26 PM

Get Oracle space usage information in AnySQL

    You can get the table and it's indexes' or lob segments' size by "ORA SIZE" command easily. ASQL> ora size sh.t_lobtest OWNER SEGMENT_NAME              SEGMENT_TYPE SIZE_MB INIEXT MAXEXT ----- ------------------------- ------------ ------- ------ ------ SH    T_LOBTEST                 TABLE         0.0625  65536 SH    SYS_IL0000012006C00001$$  LOBINDEX      0.0625  65536 SH    SYS_LOB0000012006C00002$$ LOBSEGMENT    0.0625  65536...

Posted on December 24, 2007 7:07 PM

Drop 4TB table on dictionary managed tablespace

    I got a chance to drop a 4TB size table on dictionary managed tablespace (DMT), this table comes from a very old design, and the partition design is not good for data purge, and delete cannot catch up...

Posted on December 22, 2007 5:30 PM

Describe tables with indexes structure information

    When describe a talbe to get the structure information, I also hope to display the indexes information. In AnySQL, I wrote the DESCRIBE command with this feature. It really save me a lot of time to write SQLs...

Posted on December 20, 2007 10:09 PM

What's Oracle 11G's compress table support for OLTP system?

    Before Oracle 11g, the data will not be compressed by normal insert statement even if the table is created with compress option. If you want to compress a tables data, you need to move table as compressed, or...

Posted on November 16, 2007 6:43 PM

ALTER TABLE ... MODIFY DEFAULT ATTRIBUTES ...

    When doing transportable tablespace, we get the following errors when run the TTS set check procedure. SQL> EXECUTE dbms_tts.transport_set_check('USERS', TRUE, TRUE); PL/SQL procedure successfully completed. VIOLATIONS -------------------------------------------------------------------- Default Partition (Table) Tablespace USERS for ... not contained ... Default...

Posted on November 2, 2007 4:40 PM

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

Poor SUN CPU speed for Oracle compress table

    We are thinking to use Oracle compress table for data archiving via TTS, by creating a single table for every month, and then moving it to a cheaper storage. Since the history data will not be modified any...

Posted on October 30, 2007 11:28 AM