On May 27, 4:12 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
wrote:
> <rpend..._at_gmail.com> wrote in message
>
> news:1180296074.623341.52900_at_p77g2000hsh.googlegroups.com...
>
> > Being a non-dba can someone answer this question? We had 6
> > materialized views created in production along with multiple indexes.
> > An Analyze was not performed on the new indexes, could this have led
> > to memory utilization issues on that server when queries were run
> > against these materialized views?
>
> Yes
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html
Thanks Jonathan. Do you know of any references or documentation I can
show someone explaining this?
Received on Tue May 29 2007 - 08:53:46 CDT
