High Buffer gets after server migration.

  • From: Veerabasaiah C <veeracb@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 May 2014 11:16:31 +1200

Hello guys need help here...

We have recently migrated from a
Hp-UX superdome (PARISC) to hp-ux itanium with the same configuration at
the db side.

Oracle 9.2.0.8

Disks were unmounted and mounted on the otherside and database was brought
up fine.
We have done this before and never caused any issue, but for the current
one we are seeing too many buffergets and all the jobs are getting delayed.

Bfore the migration
     90,625,062          715      126,748.3    1.5  1498.63  13680.14
3353534983
Module: siebmtshmw.exe
SELECT       T33.CONFLICT_ID,       T33.LAST_UPD,       T33.CREA
TED,       T33.LAST_UPD_BY,       T33.CREATED_BY,       T33.MODI

After the migration..

    276,758,210          971      285,023.9    2.4  1610.16  32242.21
3353534983
Module: siebmtshmw.exe
SELECT       T33.CONFLICT_ID,       T33.LAST_UPD,       T33.CREA
TED,       T33.LAST_UPD_BY,       T33.CREATED_BY,       T33.MODI
FICATION_NUM,       T33.ROW_ID,       T33.ROW_ID,       T4.X_SAL
ES_CHANNEL,       T22.X_PARENT_USER_LIST,       T13.X_USERLIST_N
AME,       T4.X_SALES_BRANCH,       T33.X_RAAPP_ID,       T14.CM



Unable to find out what could have caused this change... !!!!


-- 
Veerabasaiah C B
"Only put off until tomorrow what you are willing to die having left
undone. - Picasso"

Other related posts: