This image shows the JDeveloper BPEL Designer in the background, and the Advanced Query Operations dialog box in the front. The Advanced Query Options dialog box has the following elements:

• A checked check box labeled Maintain Cache

• A checked check box labeled Use Wrapper Policy

• A checked check box labeled Prepare SQL Once

• An unchecked check box labeled Cache Query Results

• An unchecked check box labeled Refresh Remote Identity Map Results

• A drop down menu labeled Pessimistic Locking containing Do Not Acquire. The drop-down is open, and displays the options of Do Not Acquire Locks, Acquire Locks (selected), and Acquire Locks No Wait.

• An obscured field labeled Distinct State

• A Query Timeout area with a checked check box labeled No Timeout and a grayed out field for seconds.

• A Maximum Rows area with a checked check box labeled No Maximum, and a grayed out field for an integer.

On the bottom are the standard Help, OK, and Cancel buttons.