Re: Onload is too slow

I think your problem is about the amount of indexs on your table why don't you remove some or all of your index and (re)create the indexs after you finish, Juan Enrique Flores jeflores@ref.pemex.com Raghava Ponnapalli <kponn@worldnet.att.net> wrote in article <6p0s3l$3q8@bgtnsc03.worldnet.att.net>... > Hello, > > We have 1.2 G database that's taking about 2-3 hrs to load using onload > from a flat file. I turn off logging when I onunload. This is 7.13 UC2 on > Solaris 2.4. Here are some of our settings for onload: > > LRU_MAX_DIRTY = 5 > LRU_MIN_DIRTY = 4 > BUFFERS = 131072 > CLEANERS = 7 > PHYSFILE = 58000 > CPU VPs =6 (= # of CPUs) > RA_PAGES = 32 > RA_THRESHOLD = 16 > AIO = 2 > KAIO = 6> > Check points are still taking too long (85 to 300 secs) since PHYSFILE is > reaching 75 % too quickly. This PHYSFILE (58000) is our max . Can someone > tell me how I can speed this up. > > onstat -g ioq tells me that each KAIO's maxlen is around > 140 except for> one (which is still 32). Is it time to buy more CPUs. For 1.2G, this seems > a lot of time? Does TAPESIZE parameter has anything to with this ? > > Thanks for your help in advance. > > > -- > Keith Ponnapalli >