Defrag Oracle V6.0 Database (UNIX)

From: Gordon Cain <zgjc01_at_hou.amoco.com>
Date: Tue, 8 Feb 1994 13:10:08 CST
Message-ID: <1994Feb8.131008.17989_at_amoco.com>

An article by Joseph C. Trezzo (The Ultimate Software Consultants) suggests a method of defraging V6.0 tablespaces using a script he includes in paper #27 volume 2 of IOUG proceedings. Basically you create a temp table in a tablespace that is the size of total contiguous free blocks in a tablespace, then drop the temp table. This process is supposed to combine contiguous free blocks into one extent. IT DOESN'T, at least not on UNIX. Is anyone aware of why the examples he gives in his paper cannot be recrea

ted on my UNIX database. I can create objects, and when I drop them they reappear in the blocks listed in dba_free_space, but I cannot create any objects in the table which are larger than any single free extent. i.e. Oracle will not combine adjacent free extents inspite of what Mr. Trezzo claims ????? Received on Tue Feb 08 1994 - 20:10:08 CET

This message: [ Message body ]
Next message: Ramprasad Santhanakrishnan: "Problem with Pro *C"
Previous message: Judy Ko -- Consultant: "Re: Can't see system information on new DATABASE"
Next in thread: Ruth Ann L. Larson: "Re: Defrag Oracle V6.0 Database (UNIX)"
Reply: Ruth Ann L. Larson: "Re: Defrag Oracle V6.0 Database (UNIX)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message