Oracle Logbook

September 17, 2007

PL/SQL New Features and Enhancements in 11g

Filed under: Uncategorized — Helio Dias @ 5:23 pm
  • Enhancements to Regular Expression Built-in SQL Functions
  • SIMPLE_INTEGER Datatype
  • CONTINUE Statement
  • Sequences in PL/SQL Expressions
  • Dynamic SQL Enhancements
  • Generalized Invocation
  • Named and Mixed Notation in PL/SQL Subprogram Invocations
  • Database Resident Connection Pool
  • Automatic Subprogram Inlining
  • PL/Scope
  • PL/SQL Native Compiler Generates Native Code Directly
  • DBMS_APPLICATION_INFO

    Filed under: Uncategorized — Helio Dias @ 5:14 pm

    Good article about monitoring PL executions on v$session_longops

    http://www.oracle-base.com/articles/8i/DBMS_APPLICATION_INFO.php

    Blog at WordPress.com.