Info for row-space-usage in a table

From: Ralf Brunkhorst <eedrab_at_eed.ericsson.se>
Date: Tue, 11 Jun 2002 14:52:10 +0200
Message-ID: <Pine.LNX.4.44.0206111417060.3769-100000@localhost.localdomain>

Hi,

we have a DB for a complex tool called MATRIX. In the tool-db there is a table LXDESC_1C66A382, here some more info:

Tablename blocks extents size rows

---

LXDESC_1C66A382 680704 267 5318MB 187318 desc LXDESC_1C66A382

Name                                      Null?    Type
----------------------------------------- -------- ---------------------
LXOID                                              NUMBER(38)
LXKIND                                             NUMBER(38)    
LXDESC                                             LONG

There was an inrease of 5000MB (from ~300MB to 5318MB) in 1 week in the table. The problem is, which rows take so much space, how can we find the rows, with the biggest space usage.
With the analyse-package from oracle I get only info for average space-usage. Has someone an idea or a pl/sql-script?
Many thanks for your help.

-- 
Ralf Brunckhorst                    Senior System Administrator, EED/IT
Ericsson Eurolab Deutschland GmbH   Email: Ralf.Brunckhorst_at_eed.ericsson.se
Ericsson Allee 1                    Phone: +49 2407 575 622
D-52134 Herzogenrath                Fax  : +49 2407 575 7289

Received on Tue Jun 11 2002 - 07:52:10 CDT