Presentations
 
Home

Community
Events
Evening Workshops
Training

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

General
Contact Us
About Us
Legal Notices & Terms of Use
Privacy Statement


Presentations Google Map

Presentations Key
BOUG Boeing Oracle Users Group
CLOUG Chilean Oracle Users Group
COLLAB Collaborate
CLOUG Chilean Oracle Users Group
FMW Fusion Middleware SIG
HIOUG Hawaii Oracle Users Group
NoCOUG Northern California Oracle Users Grp
NWOUG Northwest OUG
ODTUG Oracle Developer Tools User Group
OOW Oracle OpenWorld
OSWOUG Oregon-Southern Washington OUG
OUGF Oracle User Group Finland
OUGN Oracle User Group Norway
PSOUG PSOUG Database SIG
RMOUG Rocky Mountain Oracle Users Grp
UKOUG UK Oracle Users Group
UTOUG Utah 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
Date Presenter Topic
University of
Canterbury
 03/10
Daniel Morgan
Morgan's Library
  • Under Discussion
NZOUG 03/10 Daniel Morgan
Morgan's Library
  • New Features in Database 11gR2 You Will Not Hear About From Oracle
  • Edition Based Redefinition
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
CLOUG 04/09 Daniel Morgan
University of Washington
OUGN 03/09 Daniel Morgan
University of Washington
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
Database5/08 Daniel Morgan
University of Washington
Database 4/08 Daniel Morgan
University of Washington
&
Caleb Small, Camosun College
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
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
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
FMW 5/07 Caleb Small
RAC War Stories
Click Here
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
PSOUG 11/06 Caleb Small
Camosun College
Export and Import are Deprecated: Learn DataPump
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:
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

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 05/06 Caleb Small
Camosun College
Real Application Clusters (RAC) Case Study
PSOUG 03/06 Daniel Morgan
University of Washington
Oracle Streams: Change Data Capture
PSOUG 01/06
Imperva
Daniel Morgan
University of Washington
Security and SQL Injection
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 07/05 Kent Stroker
Adv. Tech. Serv.
Live Grid Control Demos
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

Kent Stroker
Adv. Tech. Serv.
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
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
Cory Franzmeier
Oracle Corp.
Kent Stroker
Oracle Corp.
Daniel Morgan
University of Washington
 RAC ... and why you should be using it
 
10g Grid Control
 
Online redefinition withDBMS_REDEFINITION
PSOUG 01/04 Daniel Morgan
University of Washington
Workshpace 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 is site maintained by Dan Morgan. Last Updated: Contact Us Legal Notices & Terms of Use  Privacy Statement