No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48572 | Total active users | 1389 | Act. users last 24h | 3 | Act. users last hour | 0 | Registered user hits last week | 108 | Registered user hits last month | 299 |
|
Go up
Peformance got Degreded after cross platform migration from aix to linux 12c
Subject: |
Peformance got Degreded after cross platform migration from aix to linux 12c |
Author: |
mdsamiuddin shaikh, India |
Date: |
Oct 02, 2020, 07:26, 113 days ago |
Error info: |
below is anylize report snip
Top User Events DB/Inst:
Avg Active
Event Event Class % Event Sessions
----------------------------------- --------------- ---------- ----------
free buffer waits Configuration 30.02 5.68
db file sequential read User I/O 10.02 1.90
CPU + Wait for CPU CPU 9.16 1.73
log file sync Commit 8.14 1.54
SQL*Net message from dblink Network 4.28 0.81
-------------------------------------------------------------
Top Background Events
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
SQL*Net break/reset to client Application 10.57 2.00
db file async I/O submit System I/O 10.32 1.95
log file parallel write System I/O 2.92 0.55
LGWR any worker group Other 1.03 0.20
------------------------------------------------------------- |
Message: |
Hi Friends,
we have done cross platform migration from aix to linux, after migration the performance of database is highly degraded hence need your immediate suggestion on this.
- Database -- oracle 12c
- Migrated from AIX to linx
- Database size 7tb
i have done below steps for increase the performance but still issue persist.
1- Data dictionary objects stats was stale. I have gathered it.
2- increase the sga from older value of 6gb to 19gb.
3- below is analyze report for reference
Top User Events DB/Inst:
Avg Active
Event Event Class % Event Sessions
----------------------------------- --------------- ---------- ----------
free buffer waits Configuration 30.02 5.68
db file sequential read User I/O 10.02 1.90
CPU + Wait for CPU CPU 9.16 1.73
log file sync Commit 8.14 1.54
SQL*Net message from dblink Network 4.28 0.81
-------------------------------------------------------------
Top Background Events
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
SQL*Net break/reset to client Application 10.57 2.00
db file async I/O submit System I/O 10.32 1.95
log file parallel write System I/O 2.92 0.55
LGWR any worker group Other 1.03 0.20
-------------------------------------------------------------
Regards,
Sami |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
Subject: |
Re: Peformance got Degreded after cross platform migration from aix to linux 12c |
Author: |
Michel Cadot, France |
Date: |
Oct 02, 2020, 08:46, 113 days ago |
Message: |
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=92286
|
Your rating?: |
This reply is Good Excellent |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
Subject: |
Re: Peformance got Degreded after cross platform migration from aix to linux 12c |
Author: |
mdsamiuddin shaikh, India |
Date: |
Oct 02, 2020, 09:55, 113 days ago |
Message: |
Hey Michel,
Sorry for not giving feedback.
will note it !!:)
Need your valuable suggestion/inputs on the current issues.
Appreciate your past support and hope you will be continue.
Regards,
Sami
|
Your rating?: |
This reply is Good Excellent |
Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|