Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: One Database, Multiple Apps

Re: One Database, Multiple Apps

From: Don Jerman <>
Date: Mon, 12 Mar 2001 14:48:53 -0800
Message-ID: <>

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:
> --
> Author: Paul Drake
> 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: (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

Original text of this message