Home
|
Sponsored by:
Knife River Corporation,
MDU Resources & the Puget Sound Oracle Users Group
|
Time
|
Topic
|
|
12:00pm - 12:30pm
|
Welcome Lunch
|
|
12:30pm - 12:40pm
|
Introductions & Keynote
Darlene Hesch,
Chief Technology Officer
Knife River Corp.
|
12:40pm - 1:15pm
Download
Presentation
Slides
|
Real Application Clusters
(RAC) and High Availability
Jim Scheitel, DBA, Knife River Corp.
Jim will discuss High Availability fundamentals with
Oracle RAC components including Interconnect, Shared Storage, Clusterware, OCR, & Voting Disks. Jim will
describe Automatic Workload Management and Connection Management concepts. He will demonstrate VIP failover and Transparent Application Failover
(TAF). Jim will discuss Split Brain condition and
demonstrate Load Balancing methods by creating Load Generation using Oracle's SwingBench utility.
|
1:15pm - 2:15pm
Download
Presentation
Slides
|
Data Guard and Disaster
Recovery
Caleb Small,
Camosun College
Caleb will discuss Disaster Recovery concepts and capabilities with Oracle’s
Data Guard product. Caleb will describe various DR options for Protection Modes
and Replication Methods including Remote Archiving and Asynchronous Redo Logging. He will describe differences
between DR options including Fast-Start Failover observer,
Switchover, and Failover. Caleb will demonstrate various Data Guard Manager
capabilities using Data Guard Broker including configurations, databases, & instances.
-- Shows the
current open mode and role of all
-- instances of the database on which it is run
-- (for example PRIMARY or -- STANDBY). Also shows
the
-- status of the MRP and RFS processes on a standby.
SELECT inst_id, open_mode, database_role
FROM gv$database;
prompt redo apply instance is:
SELECT inst_id, process, status
FROM gv$managed_standby
WHERE process LIKE 'MRP%';
prompt receiving instance(s):
SELECT inst_id, process, client_process, status
FROM gv$managed_standby
WHERE process LIKE 'RFS%'
AND client_process LIKE 'LGWR%'; |
-- status of the
standby redo logs on a standby
-- database
column last_time format a20
SELECT group#, thread#, sequence#, used, status,
last_change#, TO_CHAR(last_time, 'dd-mon-yy hh24:mi:ss')
AS last_time
FROM gv$standby_log
ORDER BY 1; |
-- reports the
maximum archive log sequence used
-- on all instances of a database
SELECT DISTINCT thread#, sequence#
FROM gv$archived_log
WHERE (thread#, next_time) IN (
SELECT thread#, MAX(next_time)
FROM gv$archived_log
GROUP BY thread#)
ORDER BY 1; |
-- current
system Change Number of a database.
SELECT current_scn
FROM gv$database; |
|
2:15pm - 2:45pm
Download
Presentation
Slides
|
10gR3 Grid Control
Eric Olson, DBA, Knife
River, Corp.
Eric will provide a Grid Control Overview and describe Architecture System
Topologies for Service Level Management. Eric will describe features of Enterprise Management for
Provisioning, Monitoring, Administration, Maintenance, Patching and
Upgrades, and
Reporting. He will demonstrate various Database and Operating System capabilities using the Configuration, Change Management, and Diagnostic Packs. Eric will also discuss
Tuning Pack facilities and 3rd-party plug-ins.
|
2:45pm - 5:00pm
Download
Presentation
Slides
|
Oracle 11g New Features
Daniel Morgan, Oracle Ace Director
Oracle Instructor: University of Washington
|
|
Dan, Oracle ACE Director and 11g Beta tester, will offer his
hands-on take on Oracle Database 11g.Dan will provide a tour of new features and new implications of 11g. This
presentation, live in SQL*Plus and presented in PowerPoint-free mode, will feature demonstrations of Virtual
Columns, Invisible Indexes, Flashback Data Archive, Native Compilation, the new table trigger clause, and the
new Result Cache.
|
|
|
|
|
