Oracle Search
Documentation
Error Message
Oracle.com
orafaq
asktom
google
metalink
Latest Articles
otn
dbasupport
oracle-base
Oracle forum
databasejournal
dbazine
psoug
puschitz
orafaq
Oracle Version History And New Features
General
General2
10GR2
docs
oracle-base
oracle
asktom
dbazine
orafaq
10G And 10g New Features
10Gr2 doc
top 20
OracleByExample
orabase
ppt
puschitz
oraclecoach
itpub(chinese)
cnorg (chinese)
9iR2
docs
oracle-base
dbazine
9i And 9i New Features
r1 and r2 combined
8i And 8i New Features
databasejournal
815 new feature
8 new feature
RMAN
Jeff Hunter
step by step 11g
example 10g
10G
rman clone
10G
DATAGUARD or Standby Database
9i
Steve Rea
step by step
steve rea
physical standby
verification
new in 10g
RAC or OPS
10gR2 vmware
10gR2 new feature
puschitz
10gr2 linux
REPLICATION
step by step
scripts
akadia
ASM: Automatic Storage Management
oracle-base
asmlib
Oracle
asm internal
Jim Czuprynski
Flashback, Recycle Bin, Flash Recovery Area
orafaq
Arup Nanda
Oracle
Jim Czuprynski
VPD or Advanced Security
dbms_rls: Row Level Security
dbms_fga: Fine grained auditing
builder 1
Oracle 1
vpd
Oracle 2
11g
UNIX Related
orafaq
Jeff Hunter
1
XML DB
XMLType XPath XQuery XSLT
JDBC ODBC OLEDB ODP.NET DBI PHP
ODP.NET
software
ODP.net FAQ
ODP Sample Code
OLEDB ADO.NET
software
carlprothman
orafaq
ODBC
ODBC Drivers
sqlstrings
JDBC
JDBC Drivers
Ullman
orafaq
upenn
PERL DBI
orafaq
thomas
jwb1
jwb2
PHP OCI8
orafaq
Oracle
10g
cookbook
ODT: Oracle Developer Tools for Visual Studio .NET
tools
demo
dev center
oramag
nbsp;
installation
tom
SQL*Loader
10g
remote dba
trailing nullcos
continueif
External Tables
example
asktom
oracle-base
dbasupport
remote dba
10g
Export & Import
-- monitoring export/import speed:
SELECT
SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name
, rows_processed
, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes
, TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;
asktom
PL/SQL
Ullman
Data Modeling
Normalization
simple5
Tutorial
LogSwitch vs. Checkpoint
Log Switch Triggers
Redo log switch
Checkpoint
Rollback Segment, ORA-1555, snapshot too old, Undo Management
ORA-1555: snapshot too old
 
Rollback Segment
 
Undo
 
Find and remove duplicate rows from a table
devx.com
 
Top-N Queries, rownum, rank(), range query( m to n)
oracle-base.com
devx.com
orafaq
range query: getting rows N through M
Cold Backup vs. Hot Backup
ittoolbox
cold vs. hot
logical vs. physical
Complete Recovery, Incomplete Recovery, controlfile
Database Cloning
Cold Backup
ilcomp
drop delete truncate high water mark
jl
orafaq
oracle forum
psoug
primary unique constraints, null, not null
constraints
unique
LMT: Locally-Managed Tablespace, ASSM: Automatic Segment Space Management, Buffer Busy Waits
dba-oracle
Buffer Busy Waits
freelist
to lmt
restriction
Data Blocks, Extents, and Segments, Datafile, Tablespace
presentation
dbms_space
tablespace usage
Bitmap Index, Bitmap Join Index
dbazine
dba-oracle
vs. BTree index
waiting commit
deadlock
Partitioned Tables And Indexes
8i
new in 9i
new in 10g
Partitioning in Oracle 9i
OPTIMIZER_INDEX_COST_ADJ Scatter Read vs. Sequential Read
calc
dba_oracle
LogMiner
8i
9i
9i
new in 10g
Basics
b1
b3
b4
b5
Popular People
Biju Thomas
Steve Rea
Rene Nyffenegger
Pete Finnigan
Tomas Kyte
asktom
ioug
Ari Kaplan
Puget Sound
Jeff Hunter
Haman Research
Rick Kupcunas
Jonathan Lewis
Jim Czuprynski
dbanotes