Re: Chache??

Marc,

Its not clear exactly what info you're refering to. I suspect you mean the data and that after the first run you're seeing fewer phy io.

Oracle does cache data blocks in memory. How many is determined by your DBA. I only know two ways to clear this:

1. Bounce the database (sure thing)
2. Run a huge query (dependent on buffer size and LRU)

Oracle will also cttempt to cache and reuse the SQL stamt itself. This might show up as reduced parsing in tkprof. You can force it to not reuse the SQL by physicallyt changing the SQL (e.g. upper/lower case, more white space).

Ken F.

Marc Zinzen <mzinzen_at_genese.de> wrote in message news:<3D916F19.E011F9B1_at_genese.de>...
> Hi.
>
> This is the situation.
> I did:
> Create table
> (
> prKey integer
> Str Varchar2(30)
> bVar Smallint
> );
> I filled this Table with 100.000 unique rows.
> Then I did the following select 10* : select * from t_ind_unt where
> prKey < 1000
> I traced it by settting alter session set sql_trace = true and got my
> report over tkprof. It seems that it after the first time i do this
> select, Oracle stores this information somewhere. I need to do some
> testing though. So here's my question.
> Where does Oracle store what info from my select-query and How can I get
> Oracle to quit doing that. I need clean results, not from cache or from
> any temp table.
>
> Thanks for your help
> Marc
Received on Wed Sep 25 2002 - 09:44:36 CDT