R
Rob Fitzpatrick
Guest
The -rusage param isn't just geeky, it's important for determining whether you're tuning correctly. It will cause (11480) and (11483) messages to be written to stdout and the db log file, for each area processed, telling you how much I/O was done to temp files (-T or -SS). Example: DBUTIL : (11480) Temporary sort file at /u/db/11.5/pac used up 0K of disk space. DBUTIL : (11483) A total of 0K of temporary sort disk space was used for area 6. If these numbers are larger than 0 KB then you are doing extra disk I/O: write I/O during the data scan/key build phase, read/write during the sort/merge phase, and read I/O during the b-tree insertion phase. That's a very small amount of RAM, especially for a DB this size. Is this a VM? Can you bump it up temporarily?
Continue reading...
Continue reading...