Re: Hunting got CPU Cost

From: AndreaG <no_at_tin.it>
Date: Mon, 11 Jun 2007 20:38:10 +0200
Message-ID: <f4jrde$9m4$1@nnrp.ngi.it>

Terminator ha scritto:
> Is there any tool which helps in oracle other the OEM to measure the
> CPU and its cost for the query for which it is being utilized in
> Oracle 10g R2.
>

v$sesstat and v$sessions help you..

SELECT SID,VALUE FROM V$SESSTAT WHERE STATISTIC# = '12' it shows a list of every sessions and own cpu time usages (but the values are cumulative) Received on Mon Jun 11 2007 - 13:38:10 CDT

This message: [ Message body ]
Next message: AndreaG: "Re: Using db files on another server"
Previous message: Mladen Gogala: "Re: Excellent SPAM"
In reply to: Terminator: "Hunting got CPU Cost"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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