Presentations by Oracle ACE Director Daniel Morgan
Presentations

Home

Resources
Library
How Can I?
Presentations
Links
Book Reviews
Downloads
User Groups
Humor


General
Contact
About
Services
Legal Notice & Terms of Use
Privacy Statement


Presentations Google Map

Presentations Key
ASUOC Asociación De Usuarios Oracle De Colombia
AWC Association for Women In Computing
AZOUG Arizona Oracle Users Group
BGOUG Bulgarian Oracle Users Group
BOUG Boeing Oracle Users Group
CLOUG Chilean Oracle Users Group
COLLAB Collaborate
COUG Calgary Oracle Users Group
DOAG German Oracle Users Group
DOUG Dallas Oracle Users Group
ECOUC East Coast Oracle Users Conference
ECOUG Ecuador Oracle Users Group
EMEA Harmony Conference
FMW Fusion Middleware SIG
GLOC Great Lakes Oracle Conference
GOUB Groupo de Usarios Oracle Brasil
GOUG Guatemala Oracle Users Group
HOUG Hungarian Oracle Users Group
HIOUG Hawaii Oracle Users Group
IOUG Independent Oracle Users Group
INOUG Indianapolis Oracle Users Group
IGGOUG Intl. GoldenGate Oracle Users Group
MBOUG Manitoba Oracle Users Group
MOUS Michigan Oracle Users Summit
NEOOUG North East Ohio Oracle Users Group
NoCOUG No. California Oracle Users Group
NWOUG Northwest Oracle Users Group
NYOUG New York Oracle Users Group
NZOUG New Zealand Oracle Users Group
OBUG Oracle Benelux Users Group
ODTUG Oracle Developer Tools User Group
OOUG Ottawa Oracle Users Group
OOW Oracle OpenWorld
OraUGCRC Costa Rica Oracle Users Group
ORCAN Oracle User Group Sweden
OSWOUG Oregon-Southern Washington OUG
OUGF Oracle User Group Finland
OUGN Oracle User Group Norway
OUGTH Oracle User Group Thailand
OraUGPTY Panama Oracle Users Group
PEOUG Peru Oracle Users Group
PSOUG PSOUG Database SIG
RMOUG Rocky Mountain Oracle Users Group
SOUG Suncoast Oracle Users Group
SVOUG El Salvador Oracle Users Group
TCOUG Twin Cities Oracle Users Group
UKOUG UK Oracle Users Group
UTOUG Utah Oracle Users Group
UYOUG Uruguay Oracle Users Group
USN United States Navy
VanOUG Vancouver BC Oracle User Group
VicOUG Victoria BC Oracle User Group
WSASec WA Software Assoc. Database SIG
WWOUG Western Washington OUG
Group/Date Presenter Topic
TCOUG 04/17 Daniel Morgan, Morgan's Library
  • What's New in 12.2?
  • Native Compilation in PL/SQL
  • Oracle Multitenant: Live in SQL*Plus
HOUG 04/17 Daniel Morgan, Morgan's Library
  • Oracle Insert Statements for DBAs and Developers
  • Oracle Database Performance Tuning: The Not SQL Option
AZOUG 03/17 Daniel Morgan, Morgan's Library
UTOUG 03/17 Daniel Morgan, Morgan's Library
UNYOUG 08/16 Daniel Morgan, Morgan's Library
CLOUG 08/16
PEOUG 08/16
AROUG 08/16
UYOUG 08/16
GOUB 07/16
Daniel Morgan, Morgan's Library
GLOC 05/16 Daniel Morgan, Morgan's Library
INOUG 05/16 Daniel Morgan, Morgan's Library
DOUG 04/16 Daniel Morgan, Morgan's Library
SOUG 4/16 Daniel Morgan, Morgan's Library
TCOUG 04/16 Daniel Morgan, Morgan's Library
UTOUG 03/16 Daniel Morgan, Morgan's Library
GAOUG 03/16 Daniel Morgan, Morgan's Library
RMOUG 02/16 Daniel Morgan, Morgan's Library
TCOUG 01/16 Daniel Morgan, Morgan's Library
BIWA 01/16 Daniel Morgan, Morgan's Library
SEMOP 11/15 Daniel Morgan, Morgan's Library
NEOOUG 11/15 Daniel Morgan, Morgan's Library
NOUG 11/15 Daniel Morgan, Morgan's Library
TCOUG 10/15 Daniel Morgan Morgan's Library
MBOUG 09/15 Daniel Morgan, Morgan's Library
NYOUG 09/15 Daniel Morgan, Morgan's Library
ECOUC 09/15 Daniel Morgan, Morgan's Library
INOUG 09/15 Daniel Morgan, Morgan's Library
ASUOC 08/15 Daniel Morgan, Morgan's Library
ECOUG 08/15 Daniel Morgan, Morgan's Library
ORAUGPTY 08/15 Daniel Morgan, Morgan's Library
SVOUG 08/15 Daniel Morgan, Morgan's Library
GOUG 08/15 Daniel Morgan, Morgan's Library
DB Tech Showcase
06/15
Daniel Morgan, Morgan's Library
OUGN 03/15 Daniel Morgan, Morgan's Library
IOUG / Chicago
03/15
Daniel Morgan, Morgan's Library
  • Meeting the Challenge of Moving to Oracle's Next Generation12c Database
IOUG / Irvine CA
11/14
Daniel Morgan, Morgan's Library
  • Meeting the Challenge of Moving to Oracle's Next Generation12c Database
NZOUG 11/14 Daniel Morgan, Morgan's Library
OUGTH 11/14 Daniel Morgan, Morgan's Library
University of Manitoba
10/14
Daniel Morgan, Morgan's Library
MBOUG 10/14 Daniel Morgan, Morgan's Library
  • oRCAle World: Root Cause Analysis
  • Insert Statements for DBAs and Developers
  • Coding Practices for Security and Data Security
  • Oracle Gems for SQL, Java and Dot Net Developers
  • Database 12c New Features You Won’t Hear About From Oracle
OpenWorld/IGGOUG
9/14
Daniel Morgan, Morgan's Library
NYOUG 8/14 Daniel Morgan, Morgan's Library
ECOUG 8/14 Daniel Morgan, Morgan's Library
PEOUG 8/14 Daniel Morgan, Morgan's Library
ORAUG-CRC 8/14 Daniel Morgan. Morgan's Library
ORAUG-PTY 8/14 Daniel Morgan, Morgan's Library
INOUG 7/14 Daniel Morgan, Morgan's Library
SrOUG 5/14 Daniel Morgan, Morgan's Library
COUG 3/14 Daniel Morgan, Morgan's Library
Hans Forbrich, Forbrich Computing
UTOUG 3/14 Daniel Morgan, Morgan's Library
OOUG 1/14 Daniel Morgan, Morgan's Library
AWC 1/14 Daniel Morgan, Morgan's Library
VanOUG 11/13 Daniel Morgan, Morgan's Library
  • oRCAle Open World: A dive into Root Cause Analysis. You know it is not right ... but how do you deter mine why?
ACOUG 11/13 Daniel Morgan, Morgan's Library
  • One Day Class:
    The Oracle Database for Java and Dot Net Developers
  • Developing and Deploying Insanely Large Databases with Oracle 11gR2
OUGN 04/13 Daniel Morgan, Morgan's Library
Hans Forbrich, Forbrich Computing
  • One Day Class:
    The Oracle Database for Java and .NET Developers
  • Integrating Oracle Database Appliances with the Sun ZFS Storage Appliance to Create an Ideal Database Environment
  • New Features in Database 12c you won't hear about from Oracle
OUGF 04/13 Daniel Morgan, Morgan's Library
  • Keynote:
    The Oracle Database for Java and .NET Developers
  • Integrating Oracle Database Appliances with the Sun ZFS Storage Appliance to Create an Ideal Database Environment
  • New Features in Database 12c you won't hear about from Oracle
UTOUG 03/13 Daniel Morgan, Morgan's Library
RMOUG 02/13 Daniel Morgan, Morgan's Library
OOUG 11/12 Daniel Morgan, Morgan's Library
  • Oracle Database 12c Preview
  • Integrating Oracle Database Appliances with the Sun ZFS Storage Appliance to Achieve Highly Available Secure Applications
  • The Oracle Gems for SQL, Java and Dot Net Developers
  • Developing and Deploying Insanely Large Databases with Oracle 11gR2
VanOUG 11/12 Daniel Morgan, Morgan's Library
AWC 11/12 Daniel Morgan, Morgan's Library
OpenWorld 10/12 Daniel Morgan, Morgan's Library
Hans Forbrich, Forbrich Computing
VicOUG 06/12 Daniel Morgan, Morgan's Library
  • ODA = 42
VanOUG 06/12 Daniel Morgan, Morgan's Library
  • ODA = 42
Harmony Latvia 06/12 Daniel Morgan, Morgan's Library
Harmony Finland 05/12 Daniel Morgan, Morgan's Library
OBUG 04/12 Daniel Morgan, Morgan's Library
  • Developing and Deploying Insanely Large Databases
VanOUG 03/12 Daniel Morgan, Morgan's Library
OUGN 03/12 Daniel Morgan, Morgan's Library
University of Oslo
03/12
Daniel Morgan, Morgan's Library
RMOUG 02/12 Daniel Morgan, Morgan's Library
  • Developing and Deploying Insanely Large Databases
WWOUG 01/12 Daniel Morgan, Morgan's Library
Seattle OracleDay
01/12
Daniel Morgan, Morgan's Library
VicOUG 09/11 Daniel Morgan, Morgan's Library
UTOUG 09/11 Daniel Morgan, Morgan's Library
ODTUG KScope 06/11 Daniel Morgan, Morgan's Library
EMEA Harmony 05/11 Daniel Morgan, Morgan's Library
BGOUG 05/11 Daniel Morgan, Morgan's Library
RMOUG 02/11 Daniel Morgan, Morgan's Library
UKOUG 12/10 Daniel Morgan, Morgan's Library
BGOUG 11/10 Daniel Morgan, Morgan's Library
DOAG 11/10 Daniel Morgan, Morgan's Library
OraUGCRC 10/10 Daniel Morgan, Morgan's Library
LAD Brazil (GOUB)
10/10
Daniel Morgan, Morgan's Library
LAD Uruguay (UYOUG)
10/10
Daniel Morgan, Morgan's Library
LAD Chile (CLOUG)
10/10
Daniel Morgan, Morgan's Library
LAD Peru (PEOUG)
10/10
Daniel Morgan, Morgan's Library
OpenWorld 09/10 Daniel Morgan, Morgan's Library
NWOUG 08/10 Daniel Morgan, Morgan's Library
NoCOUG 08/10 Daniel Morgan, Morgan's Library
NZOUG Webinar 07/10 Daniel Morgan, Morgan's Library
NZOUG Webinar 06/10 Daniel Morgan, Morgan's Library
EMEA Harmony 05/10 Daniel Morgan, Morgan's Library
Orcan 05/10 Daniel Morgan, Morgan's Library
University of Oslo
04/10
Daniel Morgan, Morgan's Library
OUGN 04/10 Daniel Morgan, Morgan's Library
University of Canterbury
03/10
Daniel Morgan, Morgan's Library
NZOUG 03/10 Daniel Morgan, Morgan's Library
VanOUG 03/10 Daniel Morgan, Morgan's Library
RMOUG 02/10 Daniel Morgan, Morgan's Library
VanOUG 01/10 Daniel Morgan, Morgan's Library
WWOUG 01/10 Daniel Morgan, Jeremiah Wilton, Rand Bell, Matt Parker, and Terry Golden
  • Panel Discussion on Migrating to Database 11g
UKOUG 12/09 Daniel Morgan, Morgan's Library
VicOUG 11/09 Daniel Morgan, Morgan's Library
WWOUG 11/09 Daniel Morgan, Morgan's Library
OUGF 11/09 Daniel Morgan, Morgan's Library
OpenWorld 10/09 Kevin Closson, Oracle
Daniel Morgan, Morgan's Library
NWOUG 09/09 Daniel Morgan, Morgan's Library
NoCOUG 08/09 Daniel Morgan, Morgan's Library
ODTUG 07/09 Daniel Morgan, Morgan's Library
  • Oracle Audit Vault: Trust but Verify for Enterprise Databases
CLOUG 04/09 Daniel Morgan, Morgan's Library
OUGN 03/09 Daniel Morgan, Morgan's Library
RMOUG 02/09 Mogens Norgaard, Miracle A/S
Daniel Morgan, Morgan's Library
UKOUG 12/08 Daniel Morgan, University of Washington
PSOUG 11/08 Kevin Closson, Oracle
Mogens Norgaard, Miracle A/S
Daniel Morgan, University of Washington
  • Exadata
  • Disaster Avoidance with Oracle 11g
OUGF 10/08 Daniel Morgan, University of Washington
NWOUG 8/08 Daniel Morgan, University of Washington
Oracle Day  2008 Daniel Morgan, University of Washington
Database 4/08 Daniel Morgan, University of Washington
Database5/08 Daniel Morgan, University of Washington
Collaborate 08 Daniel Morgan, University of Washington
  • 11g New Features for Applications DBAs and Developers
Database 4/08 Daniel Morgan, University of Washington
Database 3/08 Daniel Morgan, University of Washington
UTOUG 3/08 Daniel Morgan, University of Washington
NoCOUG 2/08 Daniel Morgan, University of Washington
RMOUG 2/08 Daniel Morgan, University of Washington
VicOUG 2/08 Daniel Morgan, University of Washington
Database 12/07 Daniel Morgan, University of Washington
OpenWorld 2007
Unconference
Daniel Morgan, University of Washington
Victoria Whitlock, BrightFly
Database 10/07 Daniel Morgan, University of Washington
  • More on virtual columns
  • SecureFiles
  • Transparent Data Encryption
UTOUG
October 2007
Daniel Morgan, University of Washington
NDOUG
October 2007
Jim Scheitel & Eric Olson, KnifeRiver Corp.
Caleb Small, Camosun College
Daniel Morgan, University of Washington
  • Presentations Page
NWOUG
October 2007
Daniel Morgan, University of Washington
NoCOUG
October 2007
Daniel Morgan, University of Washington
PSOUG 9/07 Daniel Morgan, University of Washington
PSOUG 6/07 Daniel Morgan, University of Washington
PSOUG 3/07 Daniel Morgan, University of Washington
PSOUG 3/07 Daniel Morgan, University of Washington
PSOUG 2/07 Daniel Morgan, University of Washington
John Bossert, Hubspan
  • Application Server Installation
PSOUG 1/07 Victoria Whitlock, Empria
Daniel Morgan, University of Washington
FMW 1/07 Daniel Morgan, University of Washington
John Bossert
  • Application Server Installation
PSOUG 12/06 Daniel Morgan, University of Washington
  • Cursor Sharing
UKOUG 11/06 Daniel Morgan, University of Washington
PSOUG 10/06 Daniel Morgan, University of Washington
  • Automated Storage Management (ASM)
OSWOUG 10/06 Daniel Morgan, University of Washington The gv$ views

gv$instance
gv$parameter
gv$session

set linesize 121
col program format a30
col service_name format a30

SELECT username, program, service_name
FROM gv$session;

col name format a30
col value format a30

SELECT name, value
FROM gv$parameter
WHERE isdeprecated = 'TRUE';


dbms_utility.active_instances
dbms_utility.is_cluster_database
dbms_utility.db_version

WITH Clause queries

owa_opt_lock.checksum

owa_util.who_called_me

pipelined table function

conditions - complex IN demo
PSOUG 9/06 Daniel Morgan, University of Washington The third installment of Oracle Gems:
  • CATPLAN.SQL and PLAN_TABLE$
  • DBMS_XPLAN.DISPLAY_CURSOR
  • DISPLAY_MVIEW.EXPLAIN_REWRITE
  • DBMS_ODCI.ESTIMATE_CPU_UNITS
  • DBMS_SPACE built-in package
  • DBMS_SPACE_ADMIN built-in package
  • DBMS_SHARED_POOL built-in package
PSOUG 8/06 Daniel Morgan, University of Washington
  • DBMS_PREDICTIVE_ANALYTICS
PSOUG 7/06 Daniel Morgan, University of Washington The second installment of Oracle Gems:

DBMS_ADVISOR built-in package
  • create_file
  • tuning demo
DBMS_METADATA built-in package
quote delimiters

sample clause

returning clause

  • insert statements
  • update statements
  • delete statements
PSOUG 6/06 Daniel Morgan, University of Washington The first installment of Oracle Gems:

OWA_UTIL.WHOI_CALLED_ME
dbms_ddl_internal.has_alter_any_trigger_priv

dbms_ha_alerts_prvt.instance_startup_timestamp_tz

dbms_utility.actives_instances (as sys)
dbms_utility.db_version (as sys)
dbms_utility.exec_ddl_stmnt (as sys)
dbms_utility.port_string

sys_op_descend
sys_op_lbid
sys_op_map_nonnull
PSOUG 3/06 Daniel Morgan, University of Washington Oracle Streams: Change Data Capture
PSOUG 1/06 Daniel Morgan, University of Washington Included and Excluded Nodes
PSOUG 12/05 Daniel Morgan, University of Washington Heap & Global Temporary Tables
External Tables

DBMS_MONITOR
DBMS_SUPPORT
DBMS_TRACE
PSOUG 12/05 Daniel Morgan, University of Washington More 10g Release 2 Live Demos

Commit
DBMS_PCLXUTIL for Building Partition Indexes
DBMS_REDEFINITION for on-line table structure redefinition
DBMS_LOB for loading BLOBs
UTL_FILE for unloading BLOBs
UTL_COMPRESS for compressing BLOBs
NWOUG Fall 2005 Daniel Morgan, University of Washington 10g Release 2 New Features for DBAs and Developers

Commit
New Error Handling with DBMS_ERRLOG
New Additions To DBMS_DDL
New Feature Usage Report
New Feature in DBMS_OUTPUT
PSOUG 9/05 Daniel Morgan, University of Washington 10g Release 2 Live Demos

Conditional Compilation and DBMS_DB_VERSION
New Error Handling with DBMS_ERRLOG
New Additions To DBMS_DDL
New Feature Usage Report
New Feature in DBMS_OUTPUT
Gathering System Statistics with DBMS_STATS
System Statistics

Note: I didn't get to cover it but COMMIT has changed in 10gR2 too. Perhaps next meeting.
PSOUG 6/05 Daniel Morgan, University of Washington 10g flashback capabilities

Flashback Database
Flashback Query
Flashback Table
Pseudocolumns
PSOUG 5/05 Daniel Morgan, University of Washington Files of Interest
Expression Filters and DBMS_EXPFIL
BOUG 5/05 Daniel Morgan, University of Washington Presentation not online
WSASec 5/05 Daniel Morgan, University of Washington Presentation not online
OSWOUG 5/05 Daniel Morgan, University of Washington Oracle RAC Live Demo plus:
ORA_ROWSCN
Tom Kyte's Function Based Index Demo
Virtual Indexes
DBMS_WARNING Built-in Package
DBMS_XPLAN Built-in Package
Sorted Hash Clusters
Bulk Binding (FORALL)
Advanced Rewrite (DBMS_ADVANCED_REWRITE)

Services
DBMS_SERVICE
DBMS_MONITOR
DBMS_SESSION
DBMS_RESOURCE_MANAGER
SYS_CONTEXT

also see
v$session
v$active_session_history
PSOUG 1/05 Daniel Morgan, University of Washington Partitioning and Subpartitioning
PSOUG 12/04 Daniel Morgan, University of Washington utlexcpt.sql
ORA_ROWSCN
DBMS_IOT built-in package
DBMS_ADVANCED_REWRITE
PSOUG 11/04 Daniel Morgan, University of Washington Instead-Of Triggers
On-line Redefinition
Working with User Defined Data Types
Object Views
Fine Grained Auditing
PSOUG 10/04 Daniel Morgan, University of Washington 10g System Privileges
DBMS_ADVISOR - New with 10g
DBMS_SQLTUNE - New with 10g
Overloading
NID Utility
PSOUG 9/04 Daniel Morgan, University of Washington AWR (Automatic Workload Repository)
RDA (Remote Diagnostic Monitor)
DBMS_ODCI Built-in Package
INSERT-WHEN
New Oracle Data Types
Wrap
NaN & New Numeric Functions
Set Operators
PSOUG 8/04 Daniel Morgan, University of Washington Bulk Collection and FORALL
Block Dumps
DBMS_ROWID Built-in Package
PSOUG 7/04 Daniel Morgan, University of Washington InterMedia Audio
InterMedia Video
NWOUG 7/04 Daniel Morgan, University of Washington Introduction to Streams and Advanced Queuing in Oralce 9i and 10g
NoCOUG 5/04 Daniel Morgan, University of Washington Click Here ... and scroll down to May, 2004
PSOUG 4/04 Daniel Morgan, University of Washington Partitions
Transportable Tablespaces (tablespaces)
Transportable Tablespaces (dbms_tts)
PSOUG 3/04 Daniel Morgan, University of Washington DBMS_APPLICATION_INFO
The new 10g MODEL Clause
UTL_INADDR built-in package
10g Drop Table
10g Recycle Bin
10g Table Flashback
PSOUG 2/04 Daniel Morgan, University of Washington Online redefinition with DBMS_REDEFINITION
PSOUG 1/04 Daniel Morgan, University of Washington Workspace management and DBMS_WM
PSOUG 12/03 Daniel Morgan, University of Washington Compressed Indexes
DBMS_STATS built-in package
Defining columns as NOT NULL
Hash Clusters
Index Clusters
PSOUG 11/03 Daniel Morgan, University of Washington DBMS_Profiler Built-in Package
Anonymous Blocks
Autonomous Transactions
DBMS_Utility (Error Stack Calling & Formatting)
Pragma Exception_Init
SYS_CONTEXT Function
Table Triggers
PSOUG 10/03 Daniel Morgan, University of Washington User Defined Operators
Translate & Replace String Function
PSOUG 9/03 Daniel Morgan, University of Washington DDL Triggers
System Triggers
SYS_CONTEXT Function
PSOUG 7/03 Daniel Morgan, University of Washington Coding with Object Relational Features
Improving Performance with Bulk Binding
XML

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved