Re: High Buffer gets after server migration.

1. Have you check these sqls and confirm they are the same sql?
2. Have you check their execution plan on both side? What's the differences?
3. You only mentioned that you migrated from hpux pa to hpux ia platform, haven't say what method do you using for migration, such as exp/imp, rman, storage level, etc?

Thanks very much.

Best Regards,
Milo

From: Veerabasaiah C
Date: 2014-05-16 07:16
To: oracle-l_at_freelists.org
Subject: High Buffer gets after server migration. 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