select from long raw very slow

I am installing a 3rd db that is about 3gb big and with a few tables with long raw columns(yeah i know it sucks). After installation, the app preforms extremely slow. Upon investigation, it turns out the app is selecting a lot of data from a 2gb table with long raw.

I tried doing "select *" on that table from sqlplus. It displays about 10 records per 5 seconds (even it only displays one-digit on that long raw column) which I think is extremely slow. Is this normal for long raw? If I do a "select *" on a table with clob, the display is pretty much flying.

Thanks. Received on Wed Feb 04 2004 - 15:43:20 CST