Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sort statistics in 8.1.6

Sort statistics in 8.1.6

From: Maciej Sobczak <maciej_at_maciejsobczak.com>
Date: Sun, 08 Jun 2003 21:16:41 +0200
Message-ID: <bc01u1$dug$1@SunSITE.icm.edu.pl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US