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 |
| CLOUG |
Chilean 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 |
| NoCOUG |
No. California Oracle Users Group |
| NWOUG |
Northwest 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 |
| 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 |
|
| Date |
Presenter |
Topic |
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 |
|
VanOUG
06/12 |
Daniel Morgan
Morgan's Library |
|
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 |
|
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 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 |
|
| 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
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 |
|
|
