Re: Table access slow

Hi! Sorry for my delay!

    I misreported my Oracle version: 7.3.2.3.15. (Yes I'm in trouble because Oracle won't support it)

    I regenerated all indexes and analyzed the table, but some problems still remain. If it is a small report (a few hundreds big) results come out almost OK, but time increases exponentially when report is about 1000 or 2000 and it requires join operations. Reports that used to last 2 minutes are 8 hours long now!

    Executing an explain plan has no use for me because reports are generated by a damn obsolete application and I can't modify them. Reports have to come out just the way they used to.

    After analyzing the table (table ACTAS in the report below), everything seems normal or, at least similar to other tables of similar size.

 select table_name,initial_extent,next_extent,num_rows,blocks,empty_blocks from dba_tables where blocks > 0
TABLE_NAME INITIAL_EXTENT NEXT_EXTENT NUM_ROWS BLOCKS EMPTY_BLOCKS
---------------- -------------- ----------- ---------- ----------

CANDCOMITES              204800      102400       7059        194     
      5
CANDDELEGADOS            204800      102400      30758        524     
     25
ELECTCOMITES             204800      102400       3114        174     
     25
ELECTDELEGADOS           204800      102400      21804        544     
      5
AFILIADOS                204800      102400      53946       8628     
     20
DELEGADOS                204800      102400      61817       4444     
      5
ACTAS                    204800      204800      25327       4544     
     60

    Can anybody give me a hint, please? Received on Mon Feb 09 2004 - 02:57:07 CST