Re: insert performance problem

Thanh schrieb: > > Dell PowerEdge, PIII 600Mhz CPU, 1 Ultra2 SCSI drive, 128MB RAM. > > > TBLSPACE_STATS 1This should be 0 !! > DBSERVERNAME mensa # Name of default database server > DBSERVERALIASES # List of alternate dbservernames > NETTYPE tlitcp,5,100,CPU # Configure poll thread(s) for nettypeDo you run application and database on same machine ? If yes, configure an alias of type SHM or STR on cpu and switch nettype TLI to NET. Do you really nead 5x100 Network-connections ? > RESIDENT 0 # Forced residency flag (Yes = 1, No = > 0)Should be 1 if supported on your OS. > NOAGE 0 # Process agingShould also be 1 if supported on your OS. > # Shared Memory Parameters > > LOCKS 2000 # Maximum number of locks > BUFFERS 4000 # Maximum number of shared buffersYou are using less then 8 MB of 128. This should be raised if physical memory is available. Look at your free memory (sar, top). > PHYSBUFF 32 # Physical log buffer size (Kbytes) > LOGBUFF 16 # Logical log buffer size (Kbytes)Look at onstat -l. If Pages/io greater then 0,75 for one of them then increase it. > LOGSMAX 32 # Maximum number of logical log files > CLEANERS 4 # Number of buffer cleaner processesCleaners should be greater or equal LRUS. > LRUS 8 # Number of LRU queues > LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit > LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit > LBU_PRESERVE 0 # Preserve last log for log backup For security, not for performance, this should be 1. Frank