Re: Slow database creation and loading

> Free=13177086K Used=10205524K Full=43.65% > > Is this 10 plus hour time the best we can do or can we speed this up > somehow? If we can speed this up please guide me as I am not a DBA > and we do not have a DBA on staff. You should be able to speed this up. > I have been told that we have 4 GB of memory on this box. > BUFFERS 75000 # Maximum number of shared buffers 4 GB available and only 75000*4k=300MB of buffer cache.. i would make this bigger and therefor increase > > PHYSFILE 40000 # Physical log file size (Kbytes) > NUMAIOVPS 36 # Number of IO vps changed CSA 05/3/06Are you using kernel io??? onstat -g ioa will tell.if so decrease NUMAIOVPS if using cooked files then consider raw please > PHYSBUFF 64 # Physical log buffer size (Kbytes) bigger. > LOGBUFF 64 # Logical log buffer size (Kbytes) bigger. During the load it may be interesting to see what the db is doing, so an onstat -p may help... also you state dbimport/???? if load/unload, make sure that indexes are created after data is loaded. Also you could consider generating your own checkpoints setting lrumax and min dirty to 99, check buffer cache if 75 % dirty then do a onmode -c (i have cut load times have in half using this......) Superboer.