RE: Small database - No. Disks

Depending on the number of users and use made of files in $DBTEMP, it often pays to set DBTEMP to point at a file system not on the system desc, and also not on a disc containing any database tables (unless they are almost never used). 'sar' will show you where any bottlenecks are. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================