Re: OPTIMIZE: help please - simple sql runs slow

• Post for FREE via your newsreader at post.usenet.com ****

Hi Holger

> Sure, there is. It's called sql_trace although what you really want
> is sql_trace including waits which can be easily achieved by
> issuing
>
> sql> alter session set events '10046 trace name context forever, level 4';

Level 4 is for bind variables.... if you want waits, use level 8 or 12.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=