Coskan’s Approach to Oracle

June 26, 2009

Blogroll Report 19/06/2009 – 26/06/2006

Filed under: Blogroll Report — coskan @ 8:07 pm

<—- Blogroll Report 12/06/09 – 19/06/09

Here are  technical highlights from Oracle Blogosphere with my keywords,

1- ORA-38029 for index creation

Randolf Geist – Locked table statistics and subsequent create index

2- How to start RAC instance in non-RAC  mode

Chandra Pabba – ORA-29702 – Starting RAC instance in non-rac mode

3- How to set cardinality for pipelined and table functions

Adrian Billington – setting cardinality for pipelined and table functions

4- How to format index tree dump by SQL and RegEXP

Dion Cho – Simple formatting on index tree dump

5- Restrictions for aggregate materialized views

Rob Van Wijk – Fast refreshable materialized view errors, part three: aggregate MV’s

6- dbms_stats.copy_table_stats min/high value alteration bug

Amit Bansal – dbms_stats.copy_table_stats does not alter low/high value

7- Automatic top subheap dumping with heapdump

Tanel Poder Oracle memory troubleshooting, Part 3: Automatic top subheap dumping with heapdump

8- Views in Explain Plan output – no_merge

Jonathan Lewis – Explain View

9-  Importance of Size  for  Autoextend on Next

Hemant K Chitale  - AUTOEXTEND ON Next Size

10- Partition pruning problem for MIN/MAX of partition key column

Jeff Moss – No pruning for MIN/MAX of partition key column

11- ORA-02070 with VPD  and DBMS_SCHEDULER

Amardeep Sidhu – DBMS_SCHEDULER, DBMS_RLS and SYS_CONTEXT

12- How to check RAC option in Oracle Binary

Surachart Opun – check RAC Option in Oracle Binary

13- Diagnosing paralel query and interconnect  performance on RAC with UDPSNOOP

Riyaj Shamsudeen – RAC, parallel query and udpsnoop

Oracle Forums

1- Cache Fusion and Past Image

http://forums.oracle.com/forums/thread.jspa?threadID=917350

2-CBC Latch and Buffer Busy wait on same table.

http://forums.oracle.com/forums/thread.jspa?threadID=917866

3-Latch problem

http://forums.oracle.com/forums/thread.jspa?threadID=918767

Blogroll Report 26/06/09 – 03/07/09 —- >

About these ads

4 Comments »

  1. [...] Blogroll Report 12/06/09 – 19/06/09 Filed under: Blogroll Report — coskan @ 11:23 am <—- Blogroll Report 06/06/09 – 12/06/09 Blogroll Report 19/06/09 – 26/06/09 —-> [...]

    Pingback by Blogroll Report 12/06/09 – 19/06/09 « Coskan’s Approach to Oracle — June 26, 2009 @ 8:14 pm

  2. Thanks Coskan for listing my blog in your blogroll report..

    Cheers
    Amit

    Comment by Amit — July 2, 2009 @ 6:32 pm

    • Thank you, Amit for sharing your knowledge with us :)

      Comment by coskan — July 2, 2009 @ 7:10 pm

  3. [...] Blogroll Report 26/06/2009 – 03/07/2006 Filed under: Blogroll Report — coskan @ 3:28 pm <—- Blogroll Report 19/06/2009 – 26/06/2006 [...]

    Pingback by Blogroll Report 26/06/2009 – 03/07/2006 « Coskan’s Approach to Oracle — July 3, 2009 @ 3:29 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 193 other followers

%d bloggers like this: