We are calling Stored Proc from another region using call statement in our program. SP opens a cursor which is being fetched by our program. DBA has made below plan having two package : - 1. To bind local package & 2. To bind remote package.
I want to understand EXPLAIN(YES) option when you have remote package. My DBA is not certain about this. But we had previous example where Chgman job got fail while plan bind.
I do understand that explain defines the access path but wanted to confirm whether it will work in case of remote package or not. It would be great help if anyone can share his/her comments on this.