ECSCDAP1P > select host_name,instance_name,round((sysdate-i.startup_time)*100)/100 up_days,
  2  A.Value Disk_Sorts,
  3         A.Value/to_number(sysdate-i.startup_time)/24 disk_sorts_per_hour,
  4         B.Value Memory_Sorts,
  5         ROUND(100*A.Value/
  6         DECODE((A.Value+B.Value),0,1,(A.Value+B.Value)),2)
  7             Pct_Disk_Sorts
  8    from V$SYSSTAT A, V$SYSSTAT B, v$instance i
  9   where A.Name = 'sorts (disk)'
 10     and B.Name = 'sorts (memory)';

HOST_NAME            INSTANCE_NAME       UP_DAYS DISK_SORTS DISK_SORTS_PER_HOUR MEMORY_SORTS
-------------------- ---------------- ---------- ---------- ------------------- ------------
csprdcdadb11         CSCDAP1               78.54          0                   0    113398750