> 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
Received on Fri Mar 02 2007 - 14:49:56 CST
