Category: interesting advanced dba articles
what are oracle materialized views? How to use them? – complete reference for the new oracle dba
what are oracle materialized views? How to use them? – complete reference for the new oracle dba
materialized refresh behaviour – difference between 9i and 10g – reference for the oracle DBA
difference in the materialized view refresh behaviour between 9i and 10g – advanced knowledge article for the new oracle dba
Using LOG Miner – Complete reference for the new oracle DBA
using log miner to restore recent data changes like deletes,updates and inserts- complete reference for the new oracle dba
advanced pl/sql – using collections and pipelined functions- reference for the new oracle dba
knowledge article for the new oracle dba – how to use pl/sql collections and pipelined functions
unindexed foreign keys – difference in behaviour between 10g and 11g
you should have indexes on foreign keys – especially on 11g as compared to 10g. Find out why here.
Recover your database using the Flashback Database functionality – complete reference for the new oracle dba
complete reference for the new oracle DBA about the great FLASHBACK DATABASE functionality
How do oracle external jobs work – reference for the new oracle dba
Below article contains a discussion on oracle external jobs and what should be done to fix problems with oracle external jobs.
estimating table,index,temp,rollback,undo space usage – reference for the new oracle dba
Below article can explain in detail on how to estimate the space required for a table , index , temporary tablespace , rollback segment , redo log files.
bug report-ddl on an object invalidates dependent synonyms until oracle 10.2.0.5
bug report-ddl on an object invalidates dependent synonyms until oracle 10.2.0.5
unix ip adress , dns entries , nslookup – a new oracle dba reference
unix ip adress , dns entries , nslookup – a new oracle dba reference