Company build server Linux redhat 6.5 install oracle 11 g, do their own development process system database server,
The current workflow to run this SQL: SELECT T1. WFPrcId, T1. WFTaskCod, T1. WFItemId, T1. WFItemUsrCod, T1. WFItemStsAct, T2. WFTaskCls, T1. WFItemRolCod, T1. WFItemRscAsgType, T1. WFStsCod, T1. WFItemPrvSta FROM (WFWrkItems T1 INNER JOIN WFTask T2 ON T2. WFPrcId=T1. WFPrcId AND T2. WFTaskCod=T1. WFTaskCod) WHERE T1. WFItemId=1028476813 ORDER BY T1. WFItemId FOR UPDATE OF T1. The WFItemUsrCod, T1. WFItemRolCod, T1. WFItemRscAsgType, T1. WFStsCod, T1. WFItemPrvSta NOWAIT
Will be stuck, oracle server process CPU utilization ratio to 99%,
But moving the database into a Windows system environment in all normal, SQL execution without stuck phenomenon, hope to help to troubleshoot, some professional analysis to problem, thank you very much

CodePudding user response:

As well as a table structure on Windows and Linux? Including indexes on tables
Amount of data as well?
Sentences SQL execution?

CodePudding user response:

Try to collect statistics

CodePudding user response:

On Windows from the Linux database is my use expdp guide in the past, right, this is the SQL from the application background I find out the error of SQL, I sentence execution, on Linux is jammed, 99% CPU that session,

CodePudding user response:

reference aboutdo reply: 3/f

on Windows from the Linux database is my use expdp guide in the past, right, the SQL is I find from the application background of error, the SQL sentences, I stuck on Linux, 99% CPU that session,

Stuck on the base of execution plans to look at, if use PLSQL developer, press F5.