Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cursor result return
Cris Carampa wrote:
> DA Morgan wrote:
>
>>> Doesn't it depend upon the number of columns selected? It takes 7 >>> seconds here (9.0.1.3 on Linux) for a "select * from 4352-rows-table" >>> and 1/3 second for a "select 1 from same-table". >>> >>> Kind regards, >> >> >> >> Unbelievably slow.
Any time SQL*Plus takes a long time to scroll records there is a simple solution ... either minimize SQL*Plus or ALT-TAB to a static page that obscures SQL*Plus.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Feb 23 2005 - 11:31:54 CST