Sakai Hardware meeting Sept 19, 2007

Sakai hardware meeting.

Table extents need adjustments as in one of the emails.

Also the sga is difference.  Sga max size is large on RAC.  RAC is 64 bit where have max size for sga.  6G is set for the sga on RAC.  2G on Caje.

Using separate temp ? yes.

Build external database on caje with larger initial extents may be the solution.

Test 1.  Work on parameters differences also.  Change the parameter on RAC to match prod.  This is the Optimizer_index_cost_adj parameter. See if this slows down the RAC.   Prabhu did this in the meeting.  Doesn't seem to have affected the RAC.  The initial value on the RAC was 10.  Prabhu changed it to 100 as on prod.

Test 2 create external database from subversion and set initial size and increments, not auto defaults.  Modify the scripts so its.  Do this on Saunders, which is ???.  Point to banner prod logs.  Let the external database fill itself from Banner logs.  Takes 25 minutes. Patrick will show Prabhu how to do this.

Test 3 - increase the database connections to  1500 for min and max.  Do this on Saunders.

Send Thomas the table definitions from the external database *[from Saunders?]* so he can compare with what's in Subversion. 

What about table space? 

Prabhu is not setting initial extent and subsequent extent.

Create the tables before import the data.

Joncarlo: Load balancer fixed. Sakaiprod4 is bound.  All seems well.

Rename Walton next week.

Sakaiprod5 has arrived.  Will do os install this week.

Sent email to SuN re the 6th app server. the PO is in DAFIS but not yet with Sun.