Re: Using DBMS_OLAP.ESTIMATE_SUMMARY

From: SK <no-one_at_yahoo.com>
Date: Wed, 24 Jul 2002 09:42:24 -0700
Message-ID: <ahmldf$u3n7i$1@ID-84096.news.dfncis.de>

"Srinivasa Medam" <msrhome_at_yahoo.com> wrote in message news:a682873e.0207240816.7a3cda42_at_posting.google.com...
> Hi
> I am trying to find estimated size for a view using
> DBMS_OLAP.ESTIMATE_SUMMARY_SIZE package.
> Using the following sql (logged in as SYS). I am new to materialized
> views
> and DBMS_OLAP.ESTIMATE_SUMMARY_SIZE usage. PLAN_TABLE is already
> created.
> I am doing this through SQL*Plus logged in as SYS.
> I also set SERVEROUTPUT ON
> and VAR num_bytes NUMBER
> VAR num_rows NUMBER at SQL prompt in SQL*Plus.
<snip..>

You need to analyze your tables first to get the statistics. try
analyze table emp compute statistics;
analyze table dept compute statistics;

Also you are not required to be sys for this to work.

hth
sk Received on Wed Jul 24 2002 - 11:42:24 CDT

Re: Using DBMS_OLAP.ESTIMATE_SUMMARY_SIZE procedure