> > > ORPLSQL-ADV Contenuti dettagliati

Oracle Database 12c: PL/SQL III – Advanced Programming & Tuning (ORPLSQL-ADV)

Contenuti dettagliati del Corso

Advanced Programming: Why Needed & PL/SQL Execution Internals
  • Why Advanced Programming?
  • SQL & PL/SQL Execution Internals
  • SQL & PL/SQL PGA Internals
Advanced Programming: Dynamic SQL
  • Advantages Of Dynamic SQL
  • Native Dynamic SQL
  • Dynamic SQL Using DBMS_SQL()
Advanced Programming: Using Collections
  • About Collections
  • Bulk Bind Using Collections
  • About SQL%BULK_ROWCOUNT()
  • About SQL%BULK_EXCEPTIONS()
  • Collection Methods
  • More About RETURNING Clause
  • Advanced Collection Features
  • IN INDICES OF Clause
  • IN VALUES OF Clause
Advanced Programming: Java & C Interface Methods
  • Advanced Program Interfaces
  • Calling Java Classes
  • Calling C Programs
System-Supplied Packages: DBMS_METADATA() – Part I
  • Why Retrieve Object Definitions?
  • Retrieving Default Metadata
  • Retrieving Customized Metadata
  • Using SET_COUNT()
  • Using ADD_TRANSFORM()
  • Using FETCH DDL()
  • Calling FETCH_DDL()
System-Supplied Packages: DBMS_METADATA() – Part II
  • SET_TRANSFORM_PARAM()
  • GET_QUERY()
System-Supplied Packages: DBMS_METADATA() – Part III
  • FETCH CLOB()
  • SET_FILTER() Dependent Objects
  • SET_PARSE_ITEM()
  • Primary & Dependent Object DDL
System-Supplied Packages: DBMS_REDEFINITION()
  • About Table Redefinition
  • Using DBMS_REDEFINITION()
  • DBA_REDEFINITION_ERRORS
  • CAN_REDEF_TABLE()
  • START_REDEF_TABLE()
  • FINISH_REDEF_TABLE()
  • ABORT_REDEF_TABLE()
  • COPY_TABLE_DEPENDENTS()
  • SYNC_INTERIM_TABLE()
System-Supplied Packages: DBMS_LOB()
  • Working With External BFILES
  • Working With Internal LOBS
  • SUBSTR()
  • INSTR()
  • Dynamic SECUREFILE Options
High-Performance: Advanced System-Supplied Packages
  • COMPRESSION & UTL_COMPRESS()
  • LZ_COMPRESS()
  • LZ_UNCOMPRESS()
  • DBMS_DESCRIBE()
  • UTL_MAIL()
  • DBMS_UTILITY()
  • COMPILE_SCHEMA()
  • DB_VERSION()
  • GET_PARAMETER_VALUE()
  • WAIT_ON_PENDING_DML()
  • GET_TIME()
  • GET_ENDIANNESS()
  • DBMS_FILE_TRANSFER()
High Performance: Programming & Coding Techniques
  • Autonomous Transactions
  • Using NOCOPY FOR Parameters
  • Choosing The Optimum Data Type
  • About NOT NULL
  • Useful PL/SQL Coding Techniques
  • Handling String Literals
  • User-Defined SQL Functions
High Performance: Influencing Oracle Pl/Sql Compilation
  • PL/SQL Compiler Optimization
  • PLSQL_OPTIMIZE_LEVEL
  • Controlling Compilation Messages
  • PL/SQL Native Execution
  • Wrapping Source Code
High Performance: Dynamic Partitioning & Parallelization
  • Dynamic Partitioning (Chunks)
  • Creating & Processing Chunks
  • CREATE_TASK()
  • CREATE_CHUNKS_BY_ROWID()
  • CREATE_CHUNKS_BY_NUMBER_COL()
  • EXECUTE_RUN_TASK()
  • TASK_STATUS()
  • DROP_TASK()
  • Monitoring Chunk Processing
High Performance: Using PL/SCOPE For Code Analysis
  • Configuring PL/SCOPE
  • PLSCOPE_SETTINGS
  • Using PL/SCOPE Data
High Performance: Tuning With The Hierarchical Profiler
  • What Is The Hierarchical Profiler?
  • Configuring The Profiler
  • Managing Profiler Runs
  • Analyzing Profiler Data
  • Interpreting The Results
  • DBMSHP_RUNS
  • DBMSHP_FUNCTION_INFO
  • DBMSHP_PARENT_CHILD_INFO
High Performance: Debugging With DBMS_TRACE()
  • Using The Trace Facility
  • DBMS_TRACE() To Manage Runs
  • Examining The Trace Data
  • EVENT_KIND Values
Application Security: SQL Injection Attacks
  • Understanding The Threat
  • Applying Countermeasures
Application Security: Virtual Private Databases
  • Understanding VPDS
  • Preparing For A VPD
  • Configuring A VPD
  • Managing Application Contexts
  • Managing Policies & Security Rules