oracle developer monthly - juli 2015
TRANSCRIPT
Copyright © 2014 Oracle and/or its affiliates. All rights reserved.
Oracle Developer Monthly Datenbank-Update für Anwendungsentwickler Juli 2015
Carsten Czarski Business Unit Database Oracle Deutschland B.V. & Co KG
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Umfrage: Developer Monthly July 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Wichtige Termine
• 17.07.2015 5. Webinar der APEX 5.0 Summer School 2015
• 31.07.2015 Letztes Webinar der APEX Summer School 2015
• 21.07.2015 DOAG Regio Freiburg/Baden: SQL Developer
• 05.08.2015 Oracle DBA Monthly – August 2015
• 11.08.2015 Beginn der Webinar-Reihe #12cjetzt
• 21.08.2015 Nächster Oracle Developer Monthly – August 2015
• 17.09.2015 DOAG "Big Data Days": SQL meets Big Data
• 15.10.2015 #12cjetzt: "Treffen Sie das Oracle12c-Team" – Köln
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
http://tinyurl.com/orclapexsummerschool
331
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
APEX Summer School
Technologie-Trends 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Umfragen der APEX Summer School 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Umfragen der APEX Summer School 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Umfragen der APEX Summer School 2015
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
https://plus.google.com/u/0/b/113477770489820681894/113477770489820681894/videos
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
http://tinyurl.com/12cjetzt
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
http://www.doag.org/de/events/konferenzen/doag-2015.html
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Aktuelle Software Release und Patchstände
• Oracle Datenbank 12.1.0.2
• SQL Developer 4.1.1
• SQLcl 4.2.0.15 (Release Candidate)
• SQL Developer Data Modeler 4.1.1
• node-oracledb 0.6
• Application Express 5.0.1
• Oracle Rest Data Services 3.0.1
• Recommended Patch Advisor auf MyOracle Support nutzen
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
APEX 5.0.1 - Patchset
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Oracle12c Standard Edition: Der Stand der Dinge
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Critical Patch Update – July 2015
http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Feature des Monats: PL/SQL Native Compilation
• PL/SQL Code kann "native" oder "interpreted" ablaufen
create or replace FUNCTION fib (n number) RETURN number IS BEGIN IF (n = 1) OR (n = 2) THEN RETURN 1; ELSE RETURN fib(n - 1) + fib(n - 2); END IF; END fib; / sho err select fib(32) from dual /
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
PL/SQL Native Compilation
• Session-Parameter PLSQL_CODE_TYPE
• Standardmäßig auf INTERPRETED
– PL/SQL-Prozedur wird in "Bytecode" übersetzt
– Ausführung des Bytecode durch "PL/SQL VM"
• Native-Compilation mit NATIVE
– Bytecode wird transparent und direkt in Native Code für die Plattform des DB-Server übersetzt
– Keine C-Compiler nötig – keine Erzeugung von C-Code
SQL> show parameter plsql_code NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ plsql_code_type string INTERPRETED
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
PL/SQL Native Compilation: So geht's
• PLSQL_CODE_TYPE einstellen - PL/SQL Objekt neu kompilieren
SQL> select name, type, plsql_code_type from user_plsql_object_settings; NAME TYPE PLSQL_CODE_TYPE ------------------------------ ------------ -------------------- FIB FUNCTION INTERPRETED : : : SQL> alter session set PLSQL_CODE_TYPE=NATIVE; SQL> alter function FIB compile; SQL> select name, type, plsql_code_type from user_plsql_object_settings; NAME TYPE PLSQL_CODE_TYPE ------------------------------ ------------ -------------------- FIB FUNCTION NATIVE : : :
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
PL/SQL Native Compile: Effekt
• INTERPRETED vs. NATIVE
Effekt abhängig von ...
• Inhalten des PL/SQL Objekts
– SQL <-> PL/SQL
– I/O auf Tabellen, Filesystem, Netzwerk
• Verwendeten Datentypen
• PL/SQL Optimize Level
SQL> select fib(32) from dual; FIB(32) ---------- 2178309 Abgelaufen: 00:00:01.82
SQL> select fib(32) from dual; FIB(32) ---------- 2178309 Abgelaufen: 00:00:01.04
INTERPRETED
NATIVE
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
PL/SQL Optimizer – Parameter PLSQL_OPTIMIZE_LEVEL
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
PL/SQL Native Compilation: Eine weitere Optimierung
• Data Types: BINARY_FLOAT, BINARY_DOUBLE, SIMPLE_INTEGER
create or replace FUNCTION fib (n simple_integer) RETURN simple_integer IS BEGIN IF (n = 1) OR (n = 2) THEN RETURN 1; ELSE RETURN fib(n - 1) + fib(n - 2); END IF; END fib; / sho err select fib(32) from dual /
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Datentyp-Effekte ...
INTERPRETED NATIVE - OPTLEVEL 2 NATIVE - OPTLEVEL 3
NUMBER 1.90 0.97 0.81
BINARY_DOUBLE 1.75 0.89 0.72
BINARY_INTEGER 1.53 0.62 0.40
SIMPLE_INTEGER 1.44 0.54 0.31
z.B. Subprogram
Inlining
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
OTN Aktuell: Oracle Developer Choice Awards
https://community.oracle.com/community/database/awards
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Neues Blog: JSON, REST und die Oracle-Datenbank
http://json-rest-oracledb.blogspot.com
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. Audio via Computer: Audio Integrated Voice Conference Join Conference
Nächster Oracle Developer Monthly
21. August 2015 – 11:00 Uhr
Nächster Oracle DBA Monthly
5. August 2015 – 14:00 Uhr
Fragen und Diskussionen auf Twitter
#oradevmonthly
http://tinyurl.com/oradev-monthly