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.