Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import of BLOBs slow?

Re: import of BLOBs slow?

From: NetComrade <netcomrade_at_netscape.net>
Date: 18 May 2002 12:38:05 -0700
Message-ID: <ab810584.0205181138.13f0d60f@posting.google.com>


netcomrade_at_netscape.net (NetComrade) wrote in message news:<ab810584.0205180205.451a1ef4_at_posting.google.com>...

> 2. I tried disabling logging on LOBs, but that made things even
> worse!!!
> 'control file parallel write' waits and such became 70% of the
> waits.. Apparently Oracle is busy keeping track which files are not
> 'recoverable'
> Another great article by Steve Adams:
> http://www.ixora.com.au/tips/event_10359.htm
> Suprise!! even mentioned on Metalink!
> Too bad stinking events need a db reboot.

execute dbms_system.set_ev(178,40962,10359,1,'')

this worked. Received on Sat May 18 2002 - 14:38:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US