Re: Performance of Oracle on read-intensive operations

Sure 7.3.2 exp supports 'direct' option , but sometimes the Server Crashes with ORA-600 ..I think this was fixd in 7.3.3 ..

-Thiru

Vsevolod Afanassiev wrote:

> 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 Tue Sep 21 1999 - 09:39:41 CDT