High Buffer gets after server migration.
From: Veerabasaiah C <veeracb_at_gmail.com>
Date: Fri, 16 May 2014 11:16:31 +1200
Message-ID: <CAKE9HuPNyGx+4P=bdxGKe_3rJ0oPHeZ0U5U9ShG4sZnXUDXhCw_at_mail.gmail.com>
Hello guys need help here...
Date: Fri, 16 May 2014 11:16:31 +1200
Message-ID: <CAKE9HuPNyGx+4P=bdxGKe_3rJ0oPHeZ0U5U9ShG4sZnXUDXhCw_at_mail.gmail.com>
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" -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 16 2014 - 01:16:31 CEST