Re: tkprof interpreatation question

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Mar 2007 13:30:33 -0800
Message-ID: <1172871033.421995@bubbleator.drizzle.com>

harvinder76_at_gmail.com wrote:

>> 1. Oracle version and operating system

> Oracle 10.2.0.1 on RHAT4

>> 2. Whose ODBC driver?

> Oracle ODBC 10.2.0.2

>> 3. Why ODBC and not a more robust technology?

> Need to support multiple RDBMS and doing connection at ODBC and also
> not much involved in this process

>> 4. Optimizer related initialization parameters

> SESSION_CACHE_CURSOR=3000
> CURSOR_SHARING = SIMILAR

>> 5. What SQL statement?

> Nothing special about SQL, more interested in interpreting the numbers

>> 6. What is it that attracted you to this other than the number 5?

> Need to understand these 2 parameters, nothing special about 5 or this
> particular sql and just posted some sample data for one of the query :
> Misses in library cache during parse
> Misses in library cache during execute
>
> Thanks
> --Harvinder

Without a specific issue and a lot of information ... the number of misses has no meaning.

It would seem your time might be better spent purchasing and reading the latest books by Tom Kyte and Jonathan Lewis. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Mar 02 2007 - 15:30:33 CST