Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |