Re: way to hard parsed sql in sharepool

From: Yong Huang <yong321_at_yahoo.com>
Date: 13 Feb 2002 11:09:26 -0800
Message-ID: <b3cb12d6.0202131109.7d253975@posting.google.com>

How about a library cache dump:

alter session set events 'immediate trace name LIBRARY_CACHE level 10';

Level 10 may be too much. Experiment with a lower level.

Yong Huang
yong321_at_yahoo.com

tedchyn_at_yahoo.com (Ted Chyn) wrote in message news:<44a19320.0202121552.5c751505_at_posting.google.com>...
> all,
>
> Is there another way find out hard parsed sql's in the sharepool beside
> count the sqls which contain the same beginning strings from sql_text ?
>
> thnx ted chyn
Received on Wed Feb 13 2002 - 13:09:26 CST