.
4
8
16
32
Materialized Query Table
Sequence Object
SQL Procedure
Trigger
When you want to control the order in which triggers are fired.
When you want to control the order in which stored procedures can be invoked.
When you want to automatically generate a numeric value that is not tied to any specific column or table.
When you want to automatically generate a numeric value for each row that is added to a specific table.
ADD COLUMN
ALTER COLUMN
APPEND COLUMN
RENAME COLUMN
Table
Schema
Package
Database
A transaction-start-id column must be defined for the table.
A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
A history table must be defined and associated with the base table.
A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.
Oracle connect
Trusted context
Oracle federation
Distributed request
CLI
JDBC
XML
RUBY
Alias
Index
Schema
Collection
Tree
Node
Trigger
Contexts
Sequence
Table
Bitemporal
Time-period
System-period
Application-period
In the table definition.
In the system catalog.
In the schema that the index resides in.
In the metadata of the table the index was created for.
PureScale
Data partitioning feature
Workload manager
Self-tuning memory manager
Reference
Address
Pointer
Locator
Inline
Binary
Internal
Partitioned
To automatically capture and stop rogue queries.
To provide recommendations and analysis for tuning a single query.
To provide recommendations and analysis for tuning up to 100 queries.
To recommend indexes and to guide DBAs through the process of creating new indexes.
Control Center
Universal Connection Expert
DB2 Connection Pool Manager
IBM Data Studio
Confirm product inventory.
Monitor product availability.
Summarize sales by region.
Identify patterns for products sold in the last five years.
Associate one or more products with a purchase order.
To combine data from multiple sources.
To discover hidden relationships in data.
To analyze large amounts of data to find patterns.
To make changes to a small number of records within a single transaction.
Read Stability (RS)
Cursor Stability (CS)
Repeatable Read (RR)
Uncommitted Read (UR)
Table size
Buffer space
Number of locks
Available real storage
Share (S)
Update (U)
Exclusive (X)
Intent Exclusive (IX)
Read Stability (RS)
Repeatable Read (RR)
Uncommitted Read (UR)
Cursor Stability (CS)
LOCK TABLE tab1 IN READ MODE
LOCK TABLE tab1 IN SHARE MODE
LOCK TABLE tab1 IN EXCLUSIVE MODE
LOCK TABLE tab1 IN READ-ONLY MODE
When a transaction intends to read or change data.
When a transaction intends to change but not read data.
When a transaction intends to read but not change data.
When a transaction intends to change the system catalog.