This week was technically ritch and these are my selections.
1- How to measure redo log generation ?
Ben Prusinski – DBA Quick Tip of the week: Measuring Redo Generated
2-How to solve ORA-01620 for RAC standby for non-RAC primary?
Chandra Pabba – ORA-01620 while creating a RAC standby for non-RAC primary
3-How to speed up Single instance RAC convertion process via RCONFIG ?
4-Quick VPD for beginners
Paul M.Wright – VPD vite
5-Information about shared pool freelists
Riyaj Shamsudeen – Shared pool freelists (and durations)
6-How does optimizer behaves when where clause is not in index but index columns in order list ?
Randolf Geist – Optimizer cleverness
7-How to use convert command to copy files from ASM to filesystem?
Marcin Przepiorowski – ASM datafile operation in NOMOUNT
8-How to avoid invalid packages message before upgrade to 11G?
Mike Dietrich – Drop SYS.PLAN_TABLE$ prior to upgrading
9-How Oracle fast refreshes materialized views (MVs) of a single master table?
Alberto Dell’Era – Fast refresh of single-table materialized views – algorithm summary
10- How to decrypt endpoint_value in dba_tab_histograms
Martin Widlake – Decrypting Histogram Data
11- Workarounds for ITL related index growth
Jonathan Lewis – Index Explosion-2
12- How DBMS_STATS.SET_*_PREFS in 11G ?
CBO Architects Group- Understanding DBMS_STATS.SET_*_PREFS procedures
13-Improvements on autoallocated segments in 11G
14-Quick guide to Troubleshooting Oracle Streams
Pat Lehane – Troubleshooting Oracle Streams/CDC
15-How to use DBMS_ROWID ?
Tom Kyte – On DBMS_ROWID, Parsing, and Sizing
16-Tutorial for RMAN scripts
Arup Nanda –Scripting Oracle RMAN Commands
17-How to clear session which were marked for kill?
18-How to copy schemas over database link in a procedure ?
19-How to send mail with CLOB attachment?
Ozay Akdora – Sending mail with CLOB attachement
20-11G upgrade problem caused by timesone file
Miladin Modrakovic – Issues with upgrade to 11g
21-ORA-00384 on 11G when you set minimum for db_cache_size
Steven Karam – Strange Behavior with MEMORY_TARGET
22-ORA-15099 with ASM disks larger than 2 TB
Jonathan Lewis – Tera-Bug
23- How to automate usage of DBMS_DATAPUMP over network link
Daniel Ray-The gains and pains of dbms_datapump. Part I