Databases, Instances, and confusion

From: Matthew Ivaliotes <lotus_at_uiuc.edu>
Date: 2000/06/27
Message-ID: <SQ265.856$Il3.18686@vixen.cso.uiuc.edu>#1/1

We're in the process of planning a migration to Oracle from Sybase. I'll be taking the DBA-level training soon, but until then I'm 'fiddling' with Oracle when I can to get a feel for it. I've noticed that when I create a second database, Oracle starts up a second instance of itself in memory. This isn't how things worked in the Sybase world. Have I done something wrong? Each instance of Oracle is chewing up a couple hundred MB of RAM. Rather than have to have aqn instance going for each DB, do I simply need to have more tables in each DB?

Thanks,

Matt I.
speaking only for myself Received on Tue Jun 27 2000 - 00:00:00 CDT