Oracle Database

11g

How to

Snapshots & Materialized Views	How to configure Host Naming
Resource Manager	Start and stop database
How to partition a table	How to create an instance
How to duplicate a database	How to create a database
How to create a Multimaster Replication	How to auto start an instance in Red Hat AS 3
Text indexes	How to Transportable Tablespaces
Script generation for DDL operations	How to Supplied Packages
Log Mining - Tips	How to script
How to audit	How to manage space
Web Services	How to blob
Raw devices	Automate database Startup/Shutdown
Tablespaces	How many opened cursors?
Transactions troubleshooting	Oracle Corruptions
Sql Loader	A small stress test
ASM	How to jobs
db links	Custom password security
Segment reorganization	Automatic Segment Advisor
Legato	Profiles
How to rename a database	Privileges and grants
NLS issues	Datapump
Oracle Embedded Apache	Quick search
How to move segments between tablespaces	How to compare two db
Export/Import	Monitoring
Locks	Undo
How to trace	Using Sql Area
Monitoring Listener	Maintenance trigger
Db files and path scripts	Move and rename datafile (and all others oracle files)
ODBC & JDBC-ODBC connection	Timesten database
Oracle Security and Logon

Advanced/Expert SQL

Streams

10g

RAC

Statistics

How to statistics	How to export/import statistics
XP Stat - Custom statistics	Mysterious plan changes

Enterprise Manager

dbca	OEM repository
How to start main services

Tuning

Tuning	How to tune a query
How to Statspack	Outlines

Pl/Sql

Pl/Sql Cursor	New object instantiation semantic since 9.2.0.1
PGA issues	StringTokenizer in Pl/Sql
Exceptions in Pl/Sql	Pipelined functions
Intervals, Timestamp & Co.	How to write files in Pl/Sql
Pl/Sql tips	Nested tables and Arrays

Java programming from the Oracle perspective

How to Java stored procedures	My Java Utilities
Java tunnel Oracle-OS	Array between Oracle and Java

Listener and net service names

How to spawn more listeners	Listener.ora example listening everywhere
TNSnames configuration	Add more listeners and load balance
Ldap for tns entries	listener.ora
How to mine listener's log

RMAN

How to create RMAN catalog	RMAN effective use
No more space for archives
Manual completion of failed RMAN duplicate	Rman - Quering catalog
RMAN - catalog clean up

Standby databases

How to create a physical standby database	How to create a logical standby database
Parameters for standby database	Troubleshooting Standby db

How to install

How to install Oracle 9iR2 various services on Red Hat 9	OPatch and RDA
How to install, patch and interim	How to install Oracle 9i on Fedora Core 3
Unix profiles

Init.ora

Dedicated Server	Pfile shared base
Init.ora example with explanations	Shared Server enhanced
Advanced Replication
init.ora 9i	init.ora 10g

My Solutions

Implementing an history database	How to limit the number of rows in a table
How to reorder a primary key	Determine the differences between two tables
Partitioning for Standard Ed. (Oracle 7 way)	Primary keys generation

Handbooks

(basic DBA administration)

Other

Various tips	How to prepare an instance report
Managed Errors	Configure GetRight for Oracle download