Kscope16 day 3 (06/29/2016)

Session 13 (8:30am-9:30am) A quick guide of Free Oracle Tuning Tools - Bjoern Rost
Chris:
PLSQLPLUS
SQLCL
WEB-ASH
MOATS
SNAPPER
ORASASH
SQLT
EDB360
SQLD360
TUNAS360

Shane:
?

Session 14 (10:15-11:15) Affordable workflow options for our APEX app - Niels de Bruijn
Chris:
PL/Flow - http://plflow.sourceforge.net old, last updated 2004, easy to install.
Flow Control - https://github/j-sieben/FCT very new, released 06/2016
Camunda - Camunda community edition (java app can run in Tomcat), supports BPMN 2.0 standards

Shane:
?

Session 15 (12:45-13:45) Release the brakes: Why is my APEX app slow - Peter Raganitsch
Chris & Shane:



Session 16 (14:00-15:00) APEX security: exposing your application to the internet - Nathan Catlow
Chris:
-He did a google search and found about 3000 APEX applications.
-Keep your infrastructure up to date (APEX version, Apache Tomcat version, Apache HTTPD version, ORDS version).
-Remove builder and SQL workshop (runtime only)
-Use the ORDS validation function
-Make sys and system passwords different than ORDS users.



Shane:
?


Session 17 (15:15-16:15) Instrumentation for Oracle DB development - Alex Nuijten
Chris:
LOGGER, newer versions support recording parameters.

Shane:
?

Session 18 (16:30-17:30) Writing SQL that sucks less - Bjoern Rost
Chris & Shane: