Oracle Openworld Directory
just an indexing service

Documents
from MS Word to HTML

Information Integration in a Heterogeneous Environment
Database High Availability Best Practices

Presentations
Note: the list below simply indexes part of the original documents
on Oracle Openworld Directory (often in .zip, rarely .pps), with some very skinny contents page.
See the originals for details!
(for broken links or no more availables ask me)

Basics:
DBA misconceptions
Advanced SQL Tips for Developers and DBAs
Oracle 9i Automatic Tuning: The 7 deadly sins
New Oracle 9i & 8i Features Every i Developer Should Know


Ten Things Every OFA Developer Should Know
Multi-Dimensional Data Warehouse Automation Integrity Framework
USGS NAWQA Program: a case study with Oracle Discoverer and Data Warehouse
Oracle Migration Workbench and Kanji: porting from Sybase to Oracle
Oracle Workflow
Optimizing Dimensional Data Warehouse Design
Oracle Migration Workbench
Building eCommerce Applications Using JDeveloper
Object-Based Development with Forms 9i
eBusiness Architecture and firewall security
BOD and XML
Failover Clustering and Oracle Fail Safe
SAN and Fibre Channel architecture
Oracle 9i Data Guard and Standby Database
Query Tuning using DBMS_STATS
Oracle9i Self Management
Oracle iPortal and Portlets
Oracle eBusiness Suite & performances
Enterprise Manager Key Performance Indicators
eBusiness Suite 11i: a very detailed analysis
XML and Oracle: An Overview
Utilizing Oracle Data Warehouse Functionality in Mainstream Business Intelligence Applications
eBusiness Suite and the business drivers
A closer look at STATSPACK
Finding Your Heterogeneous Zone
Data Transformation, Data Warehousing, Business Intelligence with Oracle 9i
Oracle 9iAS Portal for the Beginner
Recovery with DBMS_FLASHBACK


Information Integration in a Heterogeneous Environment

by Vira Goorah, Oracle Corporation
original here
Information integration
Transparent Gateways
Generic Connectivity
Messaging Gateway
Open System Interfaces
Database High Availability Best Practices
by James Viscusi and Pradeep Bhanot, Oracle Corporation
original here
Uptime – What Does an Application Really Need?
Uptime in numbers
what could happen to you?
Capturing the definitions – the Service Level Agreement (SLA)
Address Human Errors
Recovery Manager (RMAN)
Block Media Recovery (BMR)
Hardware Assisted Resilient Data (HARD) initiative
Storage Configuration
Oracle9i Data Guard
Real Application Clusters
Transparent Application Failover
Ten Things Every OFA Developer Should Know
original here
OFA is a Visual Basic application issuing Express SPL instructions to the underlying databases
1: Rules for Efficient Cube Design
2: Using Functions for Complex Modeling
3: Capturing OFA’s Instructions to Express
4: Viewing the Task Queue in latest-to-earliest order
5: Executing a Solve Definition from the command line
6: Defining and using a “User Type” attribute
7: Removing all data formatting from a document
8: Performing Task Queue maintenance
9: Performing an “invisible” auto-distribution of support objects
10: Auto-login without entering a password
Multi-Dimensional Data Warehouse Automation Integrity Framework
original here
Work with Oracle Objects to construct a simple case to automate multi-dimensional data warehouse
Implement metadata to manage independent/external validation & fact/dimension relationship
Implement dynamic/centralized dimension tables
Implement views to automatically de-centralize dimension across (any) defined star-schema model
Scenario for Data Warehouse
DW process model: “main points of control”
Business Information maturity model / Impact analysis
Scenario for case study & star-schema population
Case Study
Dimensional integrity: “just in time SM approach”
Implementation: dynamic PL/SQL, Objects & triggers
Benefits, challenges and future enhancements
USGS NAWQA Program: a case study with Oracle Discoverer and Data Warehouse
original here
Environmental systems have many dimensions and pathways determining status
Data consists of water quality, groundwater levels, river flow, and biological community data with thousands of GIS derived land use attributes
Business Problem
Integrate legacy data sources
Make ad hoc querying available with out-of-the-box solution
Deliver Data to the Public
Design Philosophy
Minimize custom coding
Minimize maintenance costs
Oracle Migration Workbench and Kanji: porting from Sybase to Oracle
original here
Existing Sybase database and application, needed to convert to Oracle
Use Oracle Migration Workbench (OMWB)
After the migration to Oracle Kanji data were missing
How was Kanji stored in Sybase?
How was application working with Sybase?
Why lost when migrated to Oracle?
Moving Sybase Data to Oracle
Oracle database is US7ASCII character set, 7-bits per character
Import stripped the 8th bit off each byte, 8th bit set to 0
8-bit characters can’t be represented in the US7ASCII character set
Oracle Workflow
original here
Why the requirement
How did we do it
Structure of the IFS Document Class
Status
How will IFS communicate with Workflow
Start and Stop the workflow
How will Workflow communicate with IFS
Process Calls
Update IFS Workflow Status
Optimizing Dimensional Data Warehouse Design
original here
Dimensional Data Warehouse Definition
Dimensional Design
Sample Dimensional Schema
Large Dimension Tables
Do most of the business questions have to go through a large dimension table as in schemas with large customer or patient dimensions?
Analytical Queries through a Large Dimension Table
Build Analytical Dimensions
Analytical Dimension Benefits
Data Locality by new dimensions
New dimensions will be smaller making them easier to index
Analytical queries won’t have to use the customer table unless they need to bring back individual customer detail
Automatic history retention
Too Many Analytical Dimensions
Consolidated Dimensions
Handling Dimension Table Attribute History
Oracle Migration Workbench
original here
Why Migrate?
Complete Migration Process
Database Architecture
RDBMS Similarites
Migration Issues
Oracle’s Migration Strategy
Oracle Migration Workbench
Supported Databases
Building eCommerce Applications Using JDeveloper
original here
JDeveloper vision and new features
Competes with Oracle Forms, VB, PowerBuilder
Learning the new environment
Java Server Pages (JSPs)
Security Issues
Object-Based Development with Forms 9i
original here
OO in Forms
Object-based code
Libraries
Object-based objects
Visual attributes & property classes
Subclassing
Object groups
Object libraries
Templates
eBusiness Architecture and firewall security
original here
Application/Web Server
Firewall Technology
The eBusiness Database Should Be ‘Hardened’
Security policies
BOD and XML
original here
BOD: Requirements
OAG (GCSS-AF) Compliant
Transfer variable (possibly large) amounts of data to the repository
Flat file (or transaction) or RDBMS source
Maintain sufficient information to store data in RDBMS tables
BOD: Control Area
BOD: Business Service Request
BOD: Business Data Area
BOD: User Data Area
BOD: Definition Section
BOD: Values Section
BOD: Sample
Wrapper: Architecture
Failover Clustering and Oracle Fail Safe
original here
Introduce Failover Clustering Concepts
Microsoft Cluster Services Concepts
Oracle Fail Safe Concepts
Installation Issues
Pitfalls of Clustering
Failover Clustering Concepts
SAN and Fibre Channel architecture
original here
Differentiate between SAN and traditional storage
Fibre Channel Architecture
Oracle storage concepts
Analyze Oracle I/O performance issues on SAN
JBOD
Storage Array
SAN
NAS
Traditional (Internal) Storage
SCSI Bus w/ internal controller and external storage
DBA misconceptions
original here
note: the following are all false!
Backup mode stops writing to the datafiles
Media recovery will be required after instance failure during backup mode
'shutdown abort' is bad
You can avoid “Snapshot too old” using “set transaction use rollback segment
Batch jobs should use a “dedicated” rollback segment
select count(primary_key) is faster than count(*)
Lots of extents are bad
Always ‘switch logfile’ before/after online backups
Cold backup once a week as a “baseline”
Export is a good way to back up the database
Add more/bigger logfiles if you get 'checkpoint not complete'
NOLOGGING turns off redo logging
After activating a standby, the primary requires re-copying to become the standby
Listeners must be started before the instance
Oracle 9i Data Guard (just 5 lessons in security)
original here
Oracle Standby Database
Why do I want a Standby Database?
Oracle 8i Data Guard Architecture
Creating an Oracle 8i Standby Database
Oracle 9i Data Guard
Data Protection Modes
Query Tuning using DBMS_STATS
original here
Oracle’s Cost Based Optimizer
Supplied package DBMS_STATS
BMC internal IS application
Traditional query tuning techniques
Add or change optimizer hints
Index strategies: Remove redundant, Reorder keys, Add new
tkprof reports on statement
Oracle9i Self Management
original here
Self-tuning Memory Management
Automatic Undo Management
Database Resource Manager
Unused Index Identification
Oracle Managed Files
Advanced SQL Tips for Developers and DBAs
note: 'advanced' maybe a relative word;)
original here
Dealing with sub-queries
Limiting rows and Displaying Data
Comparing Join Techniques
Rankings, Medians, Intervals and Best-Fit
View Tricks
Oracle iPortal and Portlets
original here
Oracle iPortal Overview
What can I use it for?
Installation
Portlets
URL Services
Deployment
Portals, The New eBusiness Desktop
Oracle eBusiness Suite & performances
original here
eBusiness Suite Mid-Tier Technology Stack
Apache Server
Jserv
PL/SQL Gateway
Forms Server
eBusiness Suite Architecture
Apache/Jserv Tuning
Oracle 9i Automatic Tuning: The 7 deadly sins
original here
Powerful yet Simple - How?
High-level interfaces / tools
System managed undo tablespaces
Automatic PGA memory management
The 7 deadly sins:
  1. Using literal SQL
  2. Using client-side code
  3. Disconnecting and reconnecting
  4. Committing often
  5. Over-indexing transactional databases with redundant indexes
  6. High-concurrency monolithic PK indexes
  7. Stripe and mirror everything (SAME) over a few large disks

Enterprise Manager Key Performance Indicators
original here
Unix Capacity Planning System
Scalable & Adaptive Management Interface
9i IA automated install
eBusiness Suite 11i: a very detailed analysis
original here
Data flow during each process and tables involved
Transaction flow between PA and AP
Concurrent Manager Processes
Various problems encountered and error messages
Troubleshooting/Bug Info
Tips to overcome typical error messages
New features in 11i and set-up parameters
Entering Expense Reports in 11i
XML and Oracle: An Overview
original here
XML Basics
XML’s Potential
Support for XML in Oracle Products
Utilizing Oracle Data Warehouse Functionality in Mainstream Business Intelligence Applications
original here
Business Intelligence Trends
BI Reporting Technologies
Multidimensional BI Application Types
Desktop OLAP (DOLAP)
Multidimensional OLAP (MOLAP)
Relational OLAP (ROLAP)
Oracle 9i Data Warehouse Functionality
Sample Data Warehouse Star Schema
Query Rewrite
Materialized Views
Materialized OLAP Cube
Star Transformation Queries
eBusiness Suite and the business drivers
original here
Why do companies implement technology ?
What is the Information Path ?
Present eBusiness Suite Feature/Function
A closer look at STATSPACK
original here
Installation
Data Collection
Reporting
Levels & Thresholds
Report Analysis
Finding Your Heterogeneous Zone
original here
Oracle’s Heterogeneous Services
Distributed Environments and Database Links
Discoverer
Installing and Configuring Generic Connectivity
New Oracle 9i & 8i Features Every i Developer Should Know
note: 'new' maybe a relative word;), like 'advanced'
original here
Case Expression & Case Statement
New Internal Functions
New Data Types
Native Compilation of PL/SQL Code
Merge Statement
Autonomous Transactions
Triggers on System Events
Native Dynamic SQL
Global Temporary Tables
Bulk Binds with Collections
Internal PL/SQL Enhancements
Integration of SQL and PL/SQL Parsers
Data Transformation, Data Warehousing, Business Intelligence with Oracle 9i
original here
Answering Business Questions
Transforming Tables into Multidimensional Data Structures
Recent Changes in SQL
Analytic Functions and Families
Analytic Functions - Features and Examples
Oracle 9iAS Portal for the Beginner
original here
Portal Overview
9iAS Portal Architecture
Oracle Portal Basics
Portal Home Page
Portlets
Pages
Content Areas
Applications
Application Components
Forms
Reports
Charts
Sample Application
Recovery with DBMS_FLASHBACK
original here
Possible Recovery Options
Flashback Query Overview
Flashback Query Benefits
Configuring Undo Retention
Dynamic system parameter UNDO_RETENTION