Sorting TO_CLOB

The performance consequences of sorting the result set from SQL using TO_CLOB are not easily found on the internet, so this is a brief note that might help make sense of AWR or ASH reports if the symptoms match.

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