Coskan’s Approach to Oracle

August 12, 2009

Blogroll Report 31/07/2009 – 07/08/2009

Filed under: Blogroll Report — coskan @ 2:32 pm

<—- Blogroll Report 24/07/2009 – 31/07/2009

It is a bit late but I had decent excuses like post upgrade problems (as usual on a system which wasnt tested properly when it was test db )

1- Why not to trust ASH.TIME_WAITED ?

Vitaliy Mogilevskiy- Making sense of ASH TIME_WAITED Units

2- Restrictions when using union all with Fast refreshable materialized views

Rob Van Wijk- Fast refreshable materialized view errors, part four: union all MV’s

3- Reasons of big SYSTEM tablespaces

Martin Widlake- Why is my SYSTEM Tablespace so Big?

4- Oracle on Linux in Windows without virtualization tools.

Marcin Przepiorowski- andLinux and Oracle

5- How does Oracle fast refresh materialized views containing only joins of master tables

Alberto Dell’Era- fast refresh of join-only materialized views -algorithm summary

6- How to increase performance for data unloading from Oracle to other vendors via Oracle Heterogeneous Services

Ilmar Kerm- High performance data unloading from Oracle to ODBC database

7- Example of diagnosing a multipath problem

Martin Decker- Multipathing Configuration issue waiting to happen

8- Library Cache Pin wait caused by PL/SQL compalition

Kubilay Kara – Library Cache Pin Waits during PL/SQL compilation

9- Why export import is not reliable for detacting corrupt data blocks.

Jared Still- Detecting Corrupt Data Blocks

10- How to solve installation of grid control agent problem on active passive microsoft cluster environment

Alex Fatkulin – How to install Oracle Grid Control Agents on a Windows failover cluster with no downtime

11- ORA-4031 when there is plenty of free space in SGA.

Riyaj Shamsudeen- ORA-4031 and Shared Pool Duration

Oracle Forums

1- one block appears 54K times as cr in v$bh

Blogroll Report 24/07/2009 – 31/07/2009 –>

Create a free website or blog at