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     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