<—- Blogroll Report 18/09/2009 – 25/09/2009
Finally, managed to finish this weeks selection. I was in Rotterdam for MSSQL 2008 training and did not have time to read anything. I am also moving my house this weekend and as you guess also a time consuming issue but after I move I will have a study room which means more stuff to write other than list/index what I read and liked (My Plans depend, if BT moves my land line quickly otherwise 20 days without internet at home )
1-MTU size and RAC
Glenn Fawcet-Jumbo Frames with Oracle RAC really does Rock!!
2-Performance impact of functions in SQL
Hemant K Chitale-SQLs in Functions : Performance Impact
3-Solution for ORA-00942 when querying USER_QUEUE_SUBSCRIBERS
Flavio Casetta-ORA-00942 when querying USER_QUEUE_SUBSCRIBERS
4-How to multiply/migrate controlfiles in ASM by restore command?
John Hallas-Managing control files in ASM
5-How to write your queries against dictionary views?
Dion Cho-Tuning query on the fixed table
6- How filtering as much as you can, can help data dictionary table performance?
Martin Widlake-Data Dictionary Performance 2
7-How default user passwords and account statuses behave?
Pete Finnigan – Default Users
8-How to generate grammatically random passwords ?
Pete Finnigan-A grammatically correct random pass phrase generator
9- How to duplicate database via Enterprise Manager-11GR2 new manageability feature?
Luis Moreno Campos-Duplicating a database has never been so easy! (11gR2 new feature)?
10-How to use LNNVL function?
Luis Moreno Campos-Conditional function LNNVL: the bullsh*t detector
11-Questioning the reliability of V$SQL.BUFFER_GETS?
Luke Davies-Over 4 Billion Buffer Gets?
12-What is latency hiding means in real life?
James Morle – Latency Hiding For Fun and Profit
13-Characterset and client and client codepage reletionship (Please Read all the series if you are struggling with different charactersets highly recommended)
Frank Van Bortel – “Special” characters – part IV
14-SYSTEM tablespace does not have RECYCLE_BIN option
Luis Moreno Campos –How many times have I told not to create objects in the SYS schema?
15-11G AUTOMATIC DIAGNOSTIC REPOSITORY (ADR) in a nutshell?
Virag Sharma – Automatic Diagnostic Repository (ADR)
16-What does _smm_isort_cap parameter do ?
Jonathan Lewis – _smm_isort_cap
17-What happens when OCR Master cannot see/loose OCR mirror ?
Geert De Paep-Scenario 3: Loss of OCRmirror from the OCR MASTER only
18-How to install 11GR2 RAC on Linux on VMWare Server 2?
Tim Hall-Oracle 11g Release 2 RAC On Linux Using VMware Server 2
19-Scheduler Related enhancements in 11GR2-New server manageability feature of 11GR2
Tim Hall-New scheduler stuff in 11gR2
20-New enhancements on hierarchical queries with Recursive Subquery Factoring-11GR2 New Feature
Lucas Jellema – Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring
21-How in memory parallel execution works in 11GR2-New Data-New Business Intelligence and Data Warehousing feature of 11GR2?
Maria Colgan-In-Memory Parallel Execution in Oracle Database 11gR2