Oracle perfromance with many columns

From: Bart News <bartb_at_allinson-ross.com>
Date: Thu, 6 Jan 2000 15:41:12 -0500
Message-ID: <157d4.1054$S64.35053_at_nnrp1.uunet.ca>

[Quoted] I am having serious performance problems with Oracle when using batch programs (PRO*C or PRO*COBOL), that need to travers (read from top to bottom) fairly wide tables, i.e.
tables with around 200 columns (table is about 1000 characters wide).

I have plenty memory(1 GB), a fast, 8 CPU, UW7 machine, RAID disk, but compared to reading the same file in C-ISAM mode, performance is more than 7 to 10 times slower. As far as I can tell, my system is configured well.

Using Oracle 8 too, which allows up to 1024 columns.

Any suggestions, pointers to papers ?

Bart Blom Received on Thu Jan 06 2000 - 21:41:12 CET