Re: Chache??

From: Marc Zinzen <mzinzen_at_genese.de>
Date: Thu, 26 Sep 2002 14:00:07 +0200
Message-ID: <3D92F6C7.B6DEBE4D@genese.de>

Hi Richard.

Thank you for your exclusive reply. It makes alot of sence and this is actually what i read (except ofcours the alter table flush shared pool). But this is what bothers me. I have ran 4 queries. They are identical over 4 different Cursors on the same table. I then looked at the report TKPROF gives me. The I/O access-numbers go UP, not DOWN. I dont know why. Its amazing.

Any ideas?
What I'm doing this all for: i need to figure out how Oracle works its predicates! Centura DB goes from left to right. So the most discriminating predicate should be the first. I know Oracle does a lot of optimizing. But in case the optimizer doesn't provide the answer. What does Oracle do???

Marc Received on Thu Sep 26 2002 - 07:00:07 CDT