Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No warning in SQLDeveloper 4.1.3 when creating an incorrect view

3165999Jan 29 2016 — edited Feb 1 2016

In the newest release of SQL Developer the following incorrect view definition does not give an error/warning.

screen_001557.png

At least in release 4.0.3 and previous releases the behaviour was different.

screen_001558.png

Is this the intended behaviour in 4.1.x?

Comments

Prabodh
Answer
Hi Jan,
I'm wondering what exactly is apex.jdbc.MaxStatementsLimit parameter for and if/how the value should be adjusted.
Documentation says only: Specify the maximum number of statements to cache for each connection. Default = 10>

These are JDBC parameters detailed here http://docs.oracle.com/cd/B19306_01/java.102/b14355/concache.htm#CDEBCBJC

You may change the Max numbers to higher values, but do not reduce them. These have a impact on the memory used, and may not necessarily result in improved performance. You may need to find the right set with some trial and error.

Cheers,
Marked as Answer by jan.navratil · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 29 2016
Added on Jan 29 2016
4 comments
1,003 views