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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SGA sizing on HP-UX 11i running on Oracle 9i RACK

Status
Not open for further replies.
msmy

msmy

Technical User
May 12, 2002
11
MY
Hi,
Currently we have our database running on rack with only 1 instance. Our server both have 2 CPU & 8G Memory. We want to create many instances using this rack so we can cntol the instances.
My question is how can I configure at kernel parameter SHMMAX,SEMMNS,SEMMNI,SEMMNU & SHMSEG to fit our database requirement? and How can calculate the SGA size for the instances (shared pool,db_blocl_size,db_block_buffers , log_buffers and etc). Let say we want to create 10 instances in the rack, is it enough to cater to our environment. Please advise .


thanks & regards
 
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
599
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
217
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
245
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
274
Livia8
Livia8
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
184
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top