Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Sort statistics in 8.1.6
Hello,
There is a need to find statistics considering sorts using disk, in
particular:
- number of merges
after performing the CREATE INDEX ... PARALLEL (DEGREE 2) statement.
Before running this, the session has:
ALTER SESSION SET EVENTS '10032 TRACE NAME CONTEXT FOREVER, LEVEL 1' The above was found in some docs, but the trace file formatted by TKPROF does not contain the type of info I'm looking for.
Thank you very much for your time,
-- Maciej Sobczak http://www.maciejsobczak.com/Received on Sun Jun 08 2003 - 14:16:41 CDT
![]() |
![]() |