Danger: Sparse Datafiles Ahead

You may have read my advice not to use sparse tempfiles on Solaris UFS, but did you know that datafiles can be sparse too? Direct and concurrent I/O is very important for Oracle database performance, so there can be a dramatic impact when database operations switch to buffered and blocking I/O.  (Eg RMAN section size … Continue reading Danger: Sparse Datafiles Ahead

Advertisements

Sparse UFS Tempfiles vs Direct IO

In a previous post I found that direct and concurrent I/O was disabled when restoring a certain type of backup with RMAN on UFS. A similar issue disables direct and concurrent I/O when writing to sparse tempfiles.  I haven't seen any advice on this specific issue, but it must be common because tempfiles on Solaris … Continue reading Sparse UFS Tempfiles vs Direct IO