PL/SQL (MOSC)

MOSC Banner

Cancelling queries against a remote/cloud database with an Oracle Wallet

edited Sep 14, 2020 1:37PM in PL/SQL (MOSC) 3 commentsAnswered

I (we, actually) are having an odd issue with cancelling a long running query against a remotely located database (external to our organization), and utilizing an Oracle Wallet.

Of a group of about ten people, the following outcomes happen

  • A few can cancel a query, it cancels right away successfully, and they can run another query (For our testing, we picked a "select count(*) from ...." query against a view that predictably takes about one minute to run.  They use SQL Developer, connect via JDBC, and don't have a wallet configured (JDBC lets you connect without that), and their installed Oracle driver is 11g, 11.2.0.1 I believe.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center