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...

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-l
Received on Fri May 16 2014 - 01:16:31 CEST

Original text of this message