Oracle Application Express is upgraded to version 19.1c (19.1.0.00.15) and license and documentation links in Amazon Marketplace were updated accordingly. For more details: see Product Overview at https://aws.amazon.com/marketplace/pp/B07QC2LMM2
Whenever you want just to try the newest APEX for only one hour or you need hundreds of APEX instances for months – with the AWS Cloud (and us :)) – you can! Full pre-configured stack of software: Oracle DB, APEX, ORDS, Tomcat and Nginx on dedicated secured instance is ready for you in less than 10 minutes.
We’ve been waiting a very long time but finally it is:
New version of Oracle XE: Oracle XE 18c is available for download (only for Linux now).
What is even more important:
– limits are extended to 12GB of user data, 2GB of RAM and 2 cores
– a lot of new options disabled in 11g XE are now available for example: compression, spatial, partitioning, multitenant/pluggable databases, advanced analytics
If you have read Part 1 and Part 2 of this series, you are now ready to observe parsing (soft and hard), bind peeking, influence them, and observe how Adaptive Cursor Sharing tries to fix it.
Literals vs Bind Variables
We can say, that variables used inside PLSQL block are “Automatic Bind Variables”. So it means they are considered as bind variable and are not causing parse operations. That it is better to run stored PLSQL block then a lot of single SQL queries from application (from database point of view) Continue reading →