Re: ccol$

And here's a thought from Tom Kyte about why you might have so many of them that the dictionary cache cannot keep them all, and has to keep re-reading them.

If you keep refreshing data by truncating and importing, then some classes of constraints that you have defined will be re-created each time you do the import. Do a quick check on a few tables to see if they have large numbers of the same 'check' constraint.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Connor McDonald wrote in message <3B9908EC.D8F_at_yahoo.com>...


>d.a. wrote:

>>

>> Anyone know what would cause this sql to be executed in a database over 2

>> million times per day?

>>

>> select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1

>>