[thesite] t.e.o. updates

[Dean Mah]

The System Global Area (SGA) was fragmented.  The "BAMIMA: Bam buffer"
in the SGA is used during the compilation of PL/SQL into pcode form.

Apparently a large enough contiguous chunk could not be allocated when
the SQL was executed.

I've flushed the shared pool which should make this work on the first
execution.  We should think about pinning the RAND stored proc. into
memory so that allocation/de-allocation fragmentation occurs less
frequently.

Dean


.jeff writes:

> rudy (and dean),
> 
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > From: .jeff
> >
> > yeah.  tried that [...]
> ><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 
> nevermind, i got it working.  i just had to reload the page.
> 
>     SELECT content.contentid
>          , content.keyphrase
>          , content.contentname
>          , content.synopsis
>          , content.datemod
>          , content.replies
>          , content.rating
>          , content.ratings
>          , users.userid
>          , users.who
>          , categorys.category
>          , categorys.categoryid
>          , rand.random AS rank
>       FROM content
>          , users
>          , categorys
>      WHERE categorys.categoryid = content.categoryid
>        AND content.userid = users.userid
>        AND content.signoff = 1
>        AND content.categoryid NOT IN (1, 23, 26, 9741)
>        AND content.datemod < '#DateFormat(DateAdd("yyyy" , -1, Now()))#'
>      ORDER BY rank
> 
> dean, any thoughts on why that error occurred to begin with?