Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2GB+ memory for SGA in 10g database ?

Status
Not open for further replies.
johnpau80

johnpau80

IS-IT--Management
Jul 16, 2005
165
US


Couple of quick questions about 2GB+ SGA in Oracle datbase:

We have an Oracle database 10g in windows 2000 server and have around 15 users connecting to the database. We used to have 1.5GB of SGA allocated to the Oracle 10g database.


Now we have moved to windows 2003 enterprise edition server and we will be moving even the Oracle 10g database. And to have more than 2GB+ SGA we had to do some changes in the initialization parameter(USE_INDIRECT_DATA_BUFFERS).

And I cannot use the new db_cache_size paramter and I have to use the old tradition db_block_buffers parameter.

So wondering if all the Oracle databases with more than 2GB+ SGA needs to have the above parameters set.

Is this how everyone has there db set for SGA (2GB+ ) ?



---Thanks
SAM

 
Status
Not open for further replies.

Similar threads

KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
288
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
208
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
704
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
284
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
323
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top