RE: One Database, Multiple Apps

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).