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
AWC Association for Women In Computing
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
EMEA Harmony Conference
FMW Fusion Middleware SIG
GOUB Groupo de Usarios Oracle Brasil
HOUG Hungarian Oracle Users Group
HIOUG Hawaii Oracle Users Group
LAD Latin America Tour 2010
MbOUG Manitoba 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 Grp
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
PEOUG Peru Oracle Users Group
PSOUG PSOUG Database SIG
RMOUG Rocky Mountain Oracle Users Grp
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 WSA Security SIG
WWOUG Western Washington OUG
Group/Date Presenter Topic
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
  • Challenges in a World of Large Databases and Business Intelligence
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
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 & Hans Forbrich
Morgan's Library
  • 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 & Hans Forbrich
Morgan's Library
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 Daniel Morgan
Morgan's Library
and
Kevin Closson, Oracle
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
Daniel Morgan
UKOUG 12/08 Daniel Morgan
University of Washington
PSOUG 11/08 Kevin Closson, Oracle
Daniel Morgan, UW
Mogens Norgaard, Miracle A/S
  • 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
Database 9/07 Daniel Morgan
University of Washington
PSOUG 6/07 OracleDay 2007
Oracle 11g Preview
Presenter: Daniel Morgan, University of Washington
Add the Adjective "Rich" to your PeopleSoft User Experience
Presenter:
Jim Marion, Chelan County Public Utility District
 
PSOUG 3/07 Daniel Morgan
University of Washington
Data Guard Concepts
FMW 2/07 Daniel Morgan
University of Washington &
John Bossert, HubSpan
Application Server Installation
PSOUG 1/07 Victoria Whitlock, Empria and Daniel Morgan
University of Washington 
Data Warehousing
and
Oracle's TimesTen in-memory database
FMW 1/07 Daniel Morgan
University of Washington and
John Bossert
Application Server Installation
PSOUG 12/06 Daniel Morgan
University of Washington
Cursor Sharing
UKOUG 11/06 Daniel Morgan
University of Washington
Change Data Capture PowerPoint slides
Demo source code
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 09/06

Daniel Morgan
University of Washington
he 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 08/06 Daniel Morgan
University of Washington
 DBMS_PREDICTIVE_ANALYTICS

PSOUG 07/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 06/06

Daniel Morgan
University of Washington
The first installment of Oracle Gems:

owa_util.who_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 03/06 Daniel Morgan
University of Washington
Oracle Streams: Change Data Capture
PSOUG 01/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 10/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 Conference

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 09/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 06/05 Daniel Morgan
University of Washington
10g flashback capabilities

Flashback Database
Flashback Query
Flashback Table
Pseudocolumns
PSOUG 05/05 Daniel Morgan
University of Washington
Files of Interest
Expression Filters and DBMS_EXPFIL
BOUG 05/05 Daniel Morgan
University of Washington
Presentation not online
WSASec 05/05 Daniel Morgan
University of Washington
Presentation not online

OSWOUG 05/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 01/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 09/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 08/04 Daniel Morgan
University of Washington
Bulk Collection and FORALL
Block Dumps
DBMS_ROWID Built-in Package
PSOUG 07/04 Daniel Morgan
University of Washington
InterMedia Audio
InterMedia Video
NWOUG 07/04 Daniel Morgan
University of Washington
Introduction to Streams and Advanced Queuing in Oralce 9i and 10g
NoCOUG 05/04 Daniel Morgan
University of Washington
Click Here ... and scroll down to May, 2004.
PSOUG 04/04 Daniel Morgan
University of Washington
Partitions
Transportable Tablespaces (tablespaces)
Transportable Tablespaces (dbms_tts)
PSOUG 03/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 02/04 Daniel Morgan
University of Washington
Online redefinition withDBMS_REDEFINITION
PSOUG 01/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 09/03 Daniel Morgan
University of Washington
DDL Triggers
System Triggers
SYS_CONTEXT Function
PSOUG 07/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-2014 Daniel A. Morgan All Rights Reserved