<—- Blogroll Report 05/02/2010 – 12/02/2010
1-How does new nested loop join works in 11G? Where did that extra nested loop join came?
Luo Donghua-New Implementation for Nested Loop Joins (11g onwards)
2-Limits of Oracle Database
Eddie Awad-Oracle Database Limits You May Not Know About
3-Solution to “Hard Limit: maximum user processes” error in 11GR2 on Solaris
Vitaliy Mogilevskiy-11gR2 install fails with “Hard Limit: maximum user processes” error
4-Slow statistic gathering on partitions caused by missing stats on global index
Martin Widlake-Stats Need Stats to Gather Stats
5-How to solve “Index Leaf Block contention” and “gc buffer busy waits” in RAC caused by Sequences
Joel Goodman-Tell RAC to Leave Your Leaves Alone
6-How to clone Database with ZFS file system ?
Ronny Egner-Creating database clones with ZFS really FAST
7-How to sort failed user drop for user with quote in its name.
Mike Smithers-Dropping quoted users – why sometimes Oracle can’t bear to say goodbye
8-How to install Oracle 11GR2 on ZFS for test ?
Martin Bach-It is indeed possible to install Oracle 11.2 on OpenSolaris
9-How to monitor dNFS traffic by sampling the v$dnfs_stats view in 11G?
Glenn Fawcett-Simple script to monitor dNFS activity
10-How to drop database including backups using RMAN. ?
Anand Prakash-Drop Database using RMAN
11-How to add third node (software) in 11GR2 RAC?
Martin Bach-Build your own RAC system part V – add RDBMS home
12-How to Determine which First Rows OPTIMIZER_MODE was Specified?
Charles Hooper-How to Determine which First Rows OPTIMIZER_MODE was Specified
13-Where does that select from dual comes from when doing merge insert ?
Timur Akhmadeev-Silent ORA-904 on MERGE
14-ASH viewer tool
Timus Akhmadeev-ASH Viewer
15-Unusual temporary object (TO) locks when spatial is installed
Jonathan Lewis-TO Locks
16-Locking problem/bug while locking parent table exclusively when locking child is disabled
Jonathan Lewis-Lock Horror
17-How does nologging work with indexes?
Hemant K Chitale-Some Common Errors – 3 – NOLOGGING and Indexes
18-How to read/interpret Error Stack (ORA-0600) output/log?
Tanel Poder-How to read ERRORSTACK output
19-How to use DTrace for diagnosing Oracle problems
James Morle-The Oracle Wait Interface Is Useless (sometimes) – part 3b
20-How do truncate/move/rebuild effect statistics on table and indexes
Hemank K Chitale-Table and Index Statistics with MOVE/REBUILD/TRUNCATE
21-How does and execution plan change when statistics remain same? (comments ***)
Richard Foote-How Does An Execution Plan Suddenly Change When The Statistics (And Everything Else) Remains The Same ? (In Limbo)
22-What is/isn’t the main rule to build bitmap index?
Riachar Foote-Myth: Bitmap Indexes With High Distinct Columns (Blow Out)
23-Inconsistency with v$filestat output prior to 11GR2
Charles Hooper-V$Filestat is wrong
24-How to partition a table online with dbms_redefinition?
Uwe Hesse-Partitioning a table online with DBMS_REDEFINITION
25-What is %CPU in explain plan output?
Charles Hooper-What is the Meaning of the %CPU Column in an Explain Plan?
26-How to read/interpret errorstack output ?
Tanel Poder-How to read erorstack output;
27-How to cancel a query running in another session?
Tanel Poder-How to CANCEL a query running in another session?
28-Resource compilation for parallel querying
Charles Hooper-Parallel Reasoning
29-Problem with VPD-ANYDATA column overflows into the DATE field
Charles Schultz-VPD + bad ANYDATA practices can really bite
30-How to install Golden Gate for test purposes?
Gleb Otochkin-Oracle GoldenGate Installation, Part 1
31-Statistics on Partitioned Tables with default settings
Doug Burns-Statistics on Partitioned Tables – Part1
Blogroll Report 19/02/2010 – 26/02/2010 –>