One Ora SID vs. Many ORA SID's

From: <Larry.Hughes_at_experian.com>
Date: Tue, 22 Dec 1998 15:46:47 GMT
Message-ID: <75oet6$eo1$1@nnrp1.dejanews.com>

My application has a registration database(series of tables), audit database, and a forsale database. I was considering having each of these in seperate SID's. What are the trade off's vs. have all of the tables in one SID ?

The Foresale is a read only so redo log's are not needed, thus archivemode off would be set if it was in it's own SID. I realize we have more granularity with backup and restore at the database level with multiple SID's.

Do I incur an abundand amount of overhead with the 3 SID's vs. 1 SID? The registration and audit databases should have fairly lighter transaction activity than the Forsale database.

Thank you in advance.

Larry

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 09:46:47 CST