JDB_Fetch performance with AIX Oracle 9.2.0.8

johnk

johnk

Member
Is anybody running with database on AIX 9.2.0.8.0, app on Intel?
ERP 8, SP23_Q1
Spec build and UTB taking loooong time, BOBSPEC build should take 10 seconds or less but is taking approx 30 minutes. Debug log (attached) shows
Apr 27 16:09:08 ** 3852/520 SELECT * FROM JD7334.F98720
Apr 27 16:09:08 ** 3852/520 Entering JDB_GetBufferSize
Apr 27 16:09:08 ** 3852/520 Entering JDB_Fetch
Apr 27 16:09:08 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:09:09 ** 3852/520 Entering JDB_Fetch
Apr 27 16:09:09 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:09:11 ** 3852/520 Entering JDB_Fetch
Apr 27 16:09:11 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:09:13 ** 3852/520 Entering JDB_Fetch
Apr 27 16:09:13 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:09:13 ** 3852/520 Entering JDB_Fetch
Apr 27 16:09:13 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1

then, 29:34 later (this should take less than 10 seconds!!):
Apr 27 16:38:47 ** 3852/520 Entering JDB_Fetch
Apr 27 16:38:47 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:38:47 ** 3852/520 Entering JDB_Fetch
Apr 27 16:38:47 ** 3852/520 ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 1
Apr 27 16:38:47 ** 3852/520 Entering JDB_CloseTable(Table = F98720)
Apr 27 16:38:47 ** 3852/520 Entering JDB_ClearSequencing
Apr 27 16:38:47 ** 3852/520 Entering JDB_ClearSelection
Apr 27 16:38:47 ** 3852/520 ORACLE DBFreeReq conn=0EB65420 requ=0EBFCB40 CLOSE
Apr 27 16:38:47 ** 3852/520 Entering JDB_ClearBuffers
Apr 27 16:38:47 ** 3852/520 Exiting JDB_ClearBuffers with success.
Apr 27 16:38:47 ** 3852/520 ORACLE DBFreeReq conn=0EB65420 requ=0EBFCB40 DROP
Apr 27 16:38:47 ** 3852/520 Exiting JDB_CloseTable(Table = F98720) with Success

Any idea how or why this is happening?
 

Attachments

  • 120170-bobspec_logs.zip
    50.4 KB · Views: 104
Back
Top