Re: (long and boring) "SQL AREA" and "LIBARARY CACHE" size?

2003-09-30 Thread Tanel Poder
An expert is the one who fully understands all of the important relationships between different parts of a system, I have a long way to go for getting there. But my sources are Oracle docs, Ixora, Internet, few training materials and of course Oracle server itself with awesome tracing and debuggin

Re: (long and boring) "SQL AREA" and "LIBARARY CACHE" size?

2003-09-29 Thread Paul Baumgartel
"No expert"? Hardly! Tanel, just how the heck do you KNOW all this stuff? --- Tanel Poder <[EMAIL PROTECTED]> wrote: > Hi! > > As I understand, when shared pool heap is allocated, half of it's > memory is > actually "hidden" at first. Oracle just allocates one big permanent > type > chunk for

Re: (long and boring) "SQL AREA" and "LIBARARY CACHE" size?

2003-09-28 Thread Tanel Poder
Hi! As I understand, when shared pool heap is allocated, half of it's memory is actually "hidden" at first. Oracle just allocates one big permanent type chunk for that. The rest of memory is put on shared pool freelist. Initially this is just one big free chunk as well, but starts shrinking as spa