Finally with help of the community i configure oci client on mac os sql developer client:
Testing the Instant Client located at /Applications/ora/client/instantclient_19_8
Testing client directory ... OK
Testing loading Oracle JDBC driver ... OK
Testing checking Oracle JDBC driver version ... OK
Driver version: 19.8.0.0.0
Testing testing native OCI library load ... OK
Success!
But when i worked on windows sql developer after you enable oci client it starts to execute multiple query same time so if you run one query that's work few minutes you still can do query in another worksheet.
On mac os now i see no different with jdbc or oci client - it's still use only one connect, for example:
- I opened new worksheet and run: exec dbms_lock.sleep(180);
2)I opened new worksheet and run select * from dual;
While dbms_lock.sleep is working i can't get result of select from dual. Also i can't open tables list in schema browser and so on.
How can i change this behaviour? I want to increase pool of connections for sql developer.