Re: Detecting xxx fragmentation/corruption?
Date: Thu, 8 May 2008 14:26:48 -0400
All that script does is generate a list of how much free space you have in a given tablespace and how many chunks it's in. That's all. It doesn't really concern itself with what kind of object may be taking up the space that's not free.
FYI stored procedures do not take up any space really. At least not in the form of tablespace space as you're implying.
On 5/8/08, Peter Teoh <htmldeveloper_at_gmail.com> wrote:
> We have this doc (metalink):
> Subject: Script to Detect Tablespace Fragmentation
> Doc ID: Note:1020182.6
> to detect tablespace fragmentation. Can I know if there exists
> another for other space usage resources like stored procedures,
> indexes, clusters? (criteria for fragmentation similarly = blocks +
> block_id = next block ?)
> Where are the stored procedures stored physically? How do I identify
> all the differents blocks belonging to the stored procedures?
> Similarly, how do extract out all the blocks for the indexes? And clusters?
> Is there a way to detect corruption (like using dbv) for each of these
> structures? And perhaps identifying the exact blocks that is
> Peter Teoh