RE: 10g on Win32

For those of you that have set up test databases on your laptops or desktops, with around 512Mb of physical RAM:

What settings do you use for your SGA sizes? I suppose the main ones are:

Db_block_buffers/db_cache_size
java_pool_size
large_pool_size
shared_pool_size

I have a totally default installation of 9.2 on my desktop for testing with. I want to install 10g along side it.. Preferably I'd like to have them both up and running at the same time.

Any hints or tips?

NAME                 VALUE


-------------------- ----------

shared_pool_size     50331648
large_pool_size      8388608
java_pool_size       33554432
db_cache_size        25165824

Cheers

Mark  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: 26 March 2004 09:27
To: oracle-l_at_freelists.org
Subject: RE: 10g on Win32

Another titbit from the oui concepts guide that amused me

<quote>
In all cases, the ORACLE_HOME name is taken first from the response file, if specified. If not, then the following convention is used for the name:

Ora<short_marketing_name>_<home_identifier> </quote>

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.643 / Virus Database: 411 - Release Date: 25/03/2004
 



----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------