Home   Oracle   Oracle1   Oracle1   My Blog   tripod home   OCM   download hsvt3270   shopping sites  

Online Tools   Docs   Latest Articles   Versions   10g   9iR2   9i   8i  

RMAN   Dataguard   RAC or OPS   Replication   ASM   FlashBack   vpd   UNIX   Windows  

XML   ODBC etc.   ODT   SQL&Loader   External Tables   FlashBack   Export & Import   PL/SQL   Data Modeling  



Online Tools And Info 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     10G


DATAGUARD or Standby Database
9i     Steve Rea       step by step   physical standby     verification       new in 10g    


RAC or OPS
9i step by step   10gR1 example   10gR2 vmware   10gR2 new feature   puschitz   10gr2 linux   9iLinux   9iHP


REPLICATION
step by step   concept   scripts   GUI   Concept   akadia       


ASM: Automatic Storage Management
oracle-base   asmlib   oracleadvice   Oracle   asm internal   psoug   Jim Czuprynski                  


Flashback, Recycle Bin, Flash Recovery Area
admin work   orafaq   oracleadvice   Arup Nanda      Oracle   Jim Czuprynski                      


VPD or Advanced Security
dbms_rls: Row Level Security       dbms_fga: Fine grained auditing           builder 1     builder 2     Oracle 1     Oracle 2


UNIX Related
orafaq 1     orafaq 2     Jeff Hunter 1     install 9i on Solaris 9     install 10g on Solaris 9


Windows
Windows/UNIX Differences


XML
XMLDB     XML     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   features  


SQL*Loader
10g     9i     8i     orafaq     osutil     remote dba     trailing nullcos     continueif    


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


Export & Import
export 9i     export 8i     import 9i     import 8i     orafaq     asktom    


PL/SQL
otn      Ullman   coding style   uk   10g   10g app   9i   9i app   8i   8i app  


Data Modeling
Normalization     datamodel.org     simple5    
ERwin     tutorial    
Designer 2000     Tutorial     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     remote-dba     orafaq    


Top-N Queries, rownum, rank(), range query( m to n)
anticlue.net     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     cold backup in rman     asktom    


Complete Recovery, Incomplete Recovery, controlfile
9i manual    


Database Cloning
RMAN and Hotbackup   dizwell   oraguy   9i   10g  
Cold Backup   samoratech   orafaq       dbaclick       ilcomp   asktom unix   asktom windows  


drop delete truncate high water mark
jl     orafaq     oraqa     oracle forum     psoug     how to recover a truncate ?    


primary unique constraints, null, not null
constraints     unique     unique index    


LMT: Locally-Managed Tablespace, ASSM: Automatic Segment Space Management, Buffer Busy Waits
dba-oracle   Buffer Busy Waits   freelist   to lmt   Arup Nanda   ppt   restriction  


Data Blocks, Extents, and Segments, Datafile, Tablespace
Oracle   segment statistics   Data Blocks       dba_segments   dbms_space   tablespace usage  


Bitmap Index, Bitmap Join Index
dbazine           dba-oracle       vs. BTree index   waiting commit   deadlock  


Partitioned Tables And Indexes
10g   9i   8i   new in 9i   new in 10g   Partitioning in Oracle 9i      


OPTIMIZER_INDEX_COST_ADJ Scatter Read vs. Sequential Read
calc   asktom   oracleadvice   dba_oracle   Tim Gorman at evdbt  


LogMiner
9i docs   8i   9i      9i      new in 10g  


Basics
b1 b2   b3 b4   b5   dbaclick            


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