Increase effective_cache_size parameter. An "effective_cache_size=11GB" should be more than enough.
-----Original Message----- From: DM <[email protected]> To: [email protected], [email protected], [email protected] Subject: [ADMIN] Can we load all database objects in memory? Date: Wed, 25 Mar 2009 12:20:08 -0700 Hi All, I have a database of 10GB. My Database Server has a RAM of 16GB Is there a way that I can load all the database objects to memory? Thanks for your time and taking a look at this question. Thanks Deepak
