Re: One Database, Multiple Apps

Actually, if you're doing a *lot* of inserts without bind variables, try shrinking your shared pool. You'll be parsing everything anyway and that way it takes less time to fail the hashtable lookup.

I have such a beastie, and this works for me -- it was able to roll over a 200M shared pool in just under 2 minutes, so I never got more than about 3% preparsed queries other than my "select..." statements that were monitoring the pool. At 10M it rarely complains, and the hit rate is about the same (1% is about the same as 3% :-) I gave the rest over to buffer cache and it seems to be a bit more responsive.

Paul Drake wrote:

> Lisa Koivu asked about:
>
> I am thinking of just implementing a schema in my current database
> for this purpose and making the table as quick for inserts as possible
> (no primary key, minimal indexing, PCTUSED set appropriately, etc.)
>
> Lisa,
>
> I recently did the exact same thing:
>
> created a schema for the Tracking App.
> As the tracking app does not use Public Synonyms, there aren't any conflicts
> with the other app running on the same database. One word of caution:
>
> bind variables.
>
> Canned apps frequently have never heard of such creatures.
> 1. Hike up your shared pool - and pay attention to free memory
> 2. enable cursor_sharing
> 3. enable query_rewrite
>
> any thoughts on this, Rachel?
>
> Paul
>
> Paul Drake
> DBA/SysAdmin
> Professional Software Systems
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
> INET: drake_at_psscorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Mar 12 2001 - 16:48:53 CST