RE: insert blob slow in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 7 Jun 2007 15:39:21 -0400
Message-ID: <BAY137-W1418030B1283C3934AA1A2EF260@phx.gbl>

Mladen,  

Yes. The ASSM did the trick. Once I switch the tablespace to SPACE MANAGEMENT MANUAL, the performance is back to before. I really appreciate your help. Thanks very much.  

David
> > > Are trying to insert LOB into an ASSM tablespace? ASSM makes things much > more sparse, you need many more writes> for the same LOB.> > -- > Mladen Gogala> Sr. Oracle DBA> Video Monitoring Systems> 1500 Broadway> New York City, NY 10036> Phone: (212) 329-5201> Email: mgogala_at_vmsinfo.com

---

Play free games, earn tickets, get cool prizes! Join Live Search Club.  http://club.live.com/home.aspx?icid=CLUB_wlmailtextlink

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 07 2007 - 14:39:21 CDT