This page contains article, tips and script samples related to Oracle database:

Technical Papers

Advanced Master-to-Master Replication - what are limitations and how to resolve them (intermediate to advanced level DBA).

Resolve locking conflicts in Oracle RAC environments. - distributed locking in Oracle RAC an how resolve them, with examples and hands on.
Inner look at Oracle latches - in depth explanation of what is Oracle latch, how it is working, what is its implementation,
how it presented in Oracle SGA and so on.

Oracle 10g vs. MS SQL Server 2005 - Features, strengths and weaknesses comparison between Oracle 10g and MSSQL 2005 (Yukon) databases.

Script Samples

*Disclaimer


Knowing how much time left to complete rollback operation.

Tips

High performance unload of giant Oracle tables into text files or write into pipe

How to make FastReader working on Oracle 10g while having FastReader for Oracle 9i downloaded

Best practices how to extract and load data from Oracle - What approaches should be used and what to take into consideration during high-volume data transfer from Oracle