Re: what is statspack 'CPU Time' event

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 10 Feb 2004 08:54:44 -0800
Message-ID: <1ac7c7b3.0402100854.63ce17f0@posting.google.com>

tommy.yan_at_hp.com (Gino) wrote in message news:<8230d425.0402100057.cdfa861_at_posting.google.com>...
> Hi ,
>
> Here's running application on oracle9i hpux. This application does
> sequential reads and writes to database.
> The system is HP Itanium2 hpux11.23 with 16cpu&32G memory.
> It's strange that I saw a 'CPU time' evnet from stapspack top events.
> What does it mean and how can I get rid of it?

Tommy,

set the following to help reduce hard parsing on frequently executed SQL:

*.session_cached_cursors=50

and that should help to reduce CPU spent time on hard parsing.

Pd Received on Tue Feb 10 2004 - 10:54:44 CST