Re: Performance of Oracle on read-intensive operations

Mario,
Thanks, I'll try export (not sure whether 7.3.2 has direct export option, I'll look in Utilities Guide).
However, I am not displaying the output in the window. I am either using spool file
with SET TERMOUT OFF or redirect standard output using UNIX pipe

sqlplus / @script.sql | compress -c > file.dat.Z

Im my last test (which took 36 min) sqlplus consumed 15 min 17 sec CPU time and oracle shadow
process (oracleSID) consumed 11 min 59 sec. So the problem is not in the client process (sqlplus),
the problem is with Oracle itself. My question is: Is it normal?

I checked the table for chained rows: it does not have any (because the table is never updated:
rows are inserted and then truncated).

Regards,
Sev

Mario Bucsics wrote in message
<0d24a28c.a9e5d98c_at_usw-ex0102-010.remarq.com>...
>
>This is because oracle needs to display the result to your
>sql-plus window. if you use exp with the direct path
>option ( exp user/pass table=asdfasdf direct=y file=asd )
>then you will see that this method takes only a few minutes.
>
>
> Mario Bucsics
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Sep 20 1999 - 18:10:18 CDT