Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 PSOUG Presentations Jump to:  
Date

Presenter

Topic

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
Database 5/08 Daniel Morgan
University of Washington
Database 4/08 Daniel Morgan
University of Washington
and
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

PSOUG 5/07

Joe Celko

"Thinking In Sets"
Here's the first installment of Joe's Slides

More coming soon.

FMW 5/07 Caleb Small
RAC War Stories
Click Here
PSOUG 4/07 Arun Sethi
Oracle Corp.
Grid Control 10.2.0.3 Live Demo
PSOUG 3/07 Daniel Morgan
University of Washington
Data Guard Concepts

PSOUG 2/07

Mark Veatch
Oracle Corp.
This incredible presentation was all white-boarded to no slides or presentations materials are available. Mark was supported by Angela Littrell and Ross Kemp from Network Appliance.

If you missed it ... you need to make sure you see the follow-up presentation at OracleDay 2007 in June.
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
FMW 12/06 Tony Milan
Oracle Corp.
Application Server Overview
PSOUG 11/06 Caleb Small
Camosun College
Export and Import are Deprecated: Learn DataPump
FMW 11/06 Peter Stapleton
Oracle Corp.
Fusion Middleware Overview
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
gv
gv

set linesize 121
col program format a30
col service_name format a30

SELECT username, program, service_name
FROM gv;

col name format a30
col value format a30

SELECT name, value
FROM gv
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
David Alexander
Oracle Corp. Portland
 
Daniel Morgan
University of Washington
XML Publisher
 
 
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
OracleDay 2006  
PSOUG 03/06 Daniel Morgan
University of Washington
Oracle Streams: Change Data Capture
PSOUG 02/06 Presentation not online
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 11/05
Don Young
InPowerSoft
Daniel Morgan
University of Washington
InPowerSoft Forms
 
Clustering Factor
 

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 08/05 Holly Willey
Oracle Corp., Bellevue WA
10g Release 2 New Features
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
v

VICOUG 04/05

Daniel Morgan
University of Washington

Kent Stroker
Adv. Tech. Serv.
Oracle RAC Live Demo plus:
Pseudocolumns
Drop Table Purge
Flashback Table
Recyclebin
ORA_ROWSCN
Virtual Indexes
Procedures & AUTHID
DBMS_WARNING Built-in Package
DBMS_XPLAN Built-in Package
Sorted Hash Clusters
Bulk Binding (FORALL)
Advanced Rewrite (DBMS_ADVANCED_REWRITE)
PSOUG 04/05 Catherine Johnson
Oracle Corp. Portland OR
Application Developer Framework for JDeveloper
OracleDay 2005

Track 1: PL/SQL Developer

10g New Features for Developers
by: Daniel Morgan, University of Washington
Partitioning: Real-time creation and management of partitions and subpartitions
by: Caleb Small, Instructor, Camosun College
Webcentric Development with HTML_DB
by: Holly Willey, Database Solution Specialist, Oracle Corp., Bellevue
Clusters and Sorted Hash Clusters, ORA_HASH and ORA_ROWSCN
by: Daniel A. Morgan, Instructor, University of Washington

Track 2: DBA

RMAN and DataPump
Caleb Small, Camosun College
RAC On Mac: Hosting Oracle on the 64bit Apple Macintosh with OS X
by: Kent Stroker, Principal, Advanced Technology Services
Managing Badly Behaved Applications with new 10g features
by: Daniel Morgan, Instructor, University of Washington
DBA Disaster Diary: Real-world Oracle failures, how they were resolved, and how they could have been prevented
by: Jeremiah Wilton, Principal, ORA-600 Consulting
Track 3: Tools
Improving Database Performance with Storage Virtualization
Steve Daniel, Network Appliances
Hardware and Operating Systems
by: Paul Kitwin, Field Technical Consultant, Avnet Partner Solutions
Oracle Warehouse Builder (OWB)
by: Nicholas Goodman, Principal, Bayon Technologies
Harnessing the power of Oracle Logs
Computer Associates
by: Ben Scheerer, Computer Associates
Track 4: Application Server
Oracle Application Server 10g Release 2 Overview
Margaret Mei Lee, Principle Product Manager, Oracle Corp.
J2EE Development for Forms and Designer Users
by: Jonas Jacobi, Principal Product Manager, Oracle Corp.
Visual and Declarative J2EE Development with Oracle JDeveloper 10g and Oracle ADF
by: Jonas Jacobi, Principal Product Manager, Oracle Corp.
Install, Configure a Highly Available Scalable and Secured Enterprise Application Deployment Environment
by: Greg Sowa, Senior Product Manager, Oracle Corp.
PSOUG 03/05 Daniel Morgan
University of Washington
Sarbanes-Oxley and HIPPA
PSOUG 02/05 Nicholas Goodman
Bayon Technologies
Oracle Warehouse Builder
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 Jack Cline & 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 05/04 Kent Stroker
Oracle Corp., Bellevue WA
10g ADDM
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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 58 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?