Re: Get some basic info, but without statpack

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 01 Sep 2006 10:15:09 +0200
Message-ID: <4lq8gdF35l2jU3@individual.net>

On 01.09.2006 08:24, Sylvestre wrote:
> Hello
>
> I want to audit session on 9i database, the info I
> need :
> - duration of session
> - cpu cons
> - Physical I/O
> - SQL of the request
>
> Is there a way to get simply these info, I don't
> want to use statpack reports.

A quick google for "oracle trigger on session start" revealed this http://www.dbasupport.com/oracle/ora10g/session_tracing101.shtml

HTH robert Received on Fri Sep 01 2006 - 03:15:09 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Get some basic info, but without statpack"
Previous message: Patrice: "Re: consolidating deferred transaction queue"
In reply to: Sylvestre: "Get some basic info, but without statpack"
Next in thread: Sybrand Bakker: "Re: Get some basic info, but without statpack"

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