Timeout

[latifa]

Thank you Erman.

Yes it's a custom object. I'll ask developpers about it.

Regards,
Latifa

[latifa]

Hi Erman,

How did you see that there is a full scan of the table ? I don't know how to read this out puts :)

By the way, May I have a Doc Id to learn how to read the out put of explain plan please ?

Thank you in advance Erman for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

In explain plan at step 8, we see the following ->

" TABLE ACCESS STORAGE FULL | HZ_PARTIES  "

Here is a good document for you -> http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf

[latifa]

Hi Erman,

Thank you very for the Doc Id.

Concern the bug, the patchis already applied in the our system.

Still getting feedback of developpers about the view XXNCV_HZ_CUSTOMER_PARTY_FIND_V.

Regards,
Latifa

[ErmanArslansOracleBlog]

Okay, but send the whole query to your developers as well..
Let's see their return.