No question at this time
DBA Top 10
1 M. Cadot 11200
2 A. Kavsek 6000
2 B. Vroman 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 2000
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48559
Total active users1398
Act. users last 24h3
Act. users last hour0
Registered user hits last week55
Registered user hits last month810
Go up

Peformance got Degreded after cross platform migration from aix to linux 12c
Next thread: Dbca hangs at 59%
Prev thread: Oracle Fail-safe

Message Score Author Date
Hi Friends, we have done cross platform migrati...... mdsamiuddin shaikh Oct 02, 2020, 07:26
https://www.dba-village.com/village/dvp_forum.Op...... Michel Cadot Oct 02, 2020, 08:46
Hey Michel, Sorry for not giving feedback. wil...... mdsamiuddin shaikh Oct 02, 2020, 09:55

Follow up by mail Click here


Subject: Peformance got Degreded after cross platform migration from aix to linux 12c
Author: mdsamiuddin shaikh, India
Date: Oct 02, 2020, 07:26, 53 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, 53 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, 53 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