Oracle Search

I am in the process of putting my notes into web pages, please keep checking in later for more contents

Online Tools And Info Search  

Documentation     Error Message     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  

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  

10gR2 vmware   10gR2 new feature   puschitz   10gr2 linux  

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


XMLType XPath XQuery XSLT    

ODP.NET software 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  

10g     remote dba     trailing nullcos     continueif    

External Tables
example     asktom     oracle-base     dbasupport     remote dba     10g    

Export & Import
-- monitoring export/import speed:
        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
          sql_text like 'INSERT %INTO "%'
      AND command_type = 2
      AND open_versions > 0;


Data Modeling
Normalization     simple5    

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    

Top-N Queries, rownum, rank(), range query( m to n)     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  

8i   9i      9i      new in 10g  
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