Home » SQL & PL/SQL » SQL & PL/SQL » Cache memory
Cache memory [message #186271] Mon, 07 August 2006 04:26 Go to next message
Messages: 24
Registered: October 2004
Junior Member
I want to know how Oracle works with the cache memory.

I know that there is a parameter called DB_CACHE_SIZE with the reserved cache memory.

How does this memory work when I run a sql??

I think that first time I run the sql Oracle read data from disk, but next time this data are
in cache memory, is right??

If this data is in cache memory in which moment Oracle delete this data from cache??

I suppose that when I run sql1, sql2,..., sqln when cache memory is full Oracle delete sql1 results data, is right??

Other question: is it possible to delete cache memory??, I need to delete it, to make some perfomance tests.
I don't have dba privileges.

Any help about cache memory will be greatly appreciated.

Thanks in advance
Re: Cache memory [message #186421 is a reply to message #186271] Mon, 07 August 2006 22:03 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Read this, especially Basic Memory Structures, SGA, and PGA, but the previous sections include required knowledge.

I also found this after a quick search.

Ross Leishman
Previous Topic: ORA-00939: too many arguments for function
Next Topic: execute immediate
Goto Forum:

Current Time: Thu Jul 27 18:20:30 CDT 2017

Total time taken to generate the page: 0.12618 seconds