Coskan’s Approach to Oracle

October 6, 2009

Blogroll Report 25/09/2009-02/10/2009

Filed under: Blogroll Report — coskan @ 7:34 pm

<—- 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?


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

Blogroll Report 02/10/2009 – 09/09/2009–>


Blog at