Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

From: <nicola.farina_at_info-line.it>
Date: Mon, 17 Dec 2007 02:57:10 -0800 (PST)
Message-ID: <2d6cb33c-ab90-4f00-a8de-7537a6d5c547@s19g2000prg.googlegroups.com>

Hi Yong,

No there is no mview involved, and the ddl I gave you was indeed complete. The bug text talks about mview, it is true, but evidently the
bug "scope" is larger than that.
Anyway thanks for answering and time to all of you Bye
Nicola Received on Mon Dec 17 2007 - 04:57:10 CST

This message: [ Message body ]
Next message: Robert Klemme: "Re: re creating a primary key on a table makes requests faster?"
Previous message: Wilfrid: "re creating a primary key on a table makes requests faster?"
In reply to: Yong Huang: "Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?"
Next in thread: fitzjarrell_at_cox.net: "Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US