Re: Help with Tuning

Hi, Barbara.
What can I say. It would be better if you would place indexes on the other volume (other physical device) by "alter index rebuild ...". If you have one volume then everything you can do is just rebuild indexes -  it can increase performance in some cases. To evaluate a number of indexes you can view user_indexes view, to evaluate size of indexes you can view user_segments view with where clause "segment_name = <your_index_name>". Good luck.

In article <bnLM5.16117$Q92.312998_at_nntp2.onemain.com>,   "Barbara Kennedy" <barbken_at_teleport.com> wrote:
> The Oracle performance pack has a tuning expert and it is reasonably
> inexpensive. It makes its recommendations based upon usage during the
> collections period. So it is important that people use the system
 during
> the collections period or you will get skewed answers. (GIGO)
> Jim
> "Walt" <wmaguire_at_extensity.com> wrote in message
> news:3A032F58.846ED085_at_pacbell.net...
> > Hello-
> > I've recently inherited a very large and complex data model, and
 I
> > need to begin evaluating the appropriateness of indexes. My main
> > challenge is one of volume; this model has around 270 tables, and
 just
> > under 700 indexes. It's the back-end for a software package which
 is
> > designed to be customized on install, and could serve anywhere from
 a
> > few dozen to tens of thousands of users.
> > I'm hoping to avoid tuning based on complaints of poor
 performance.
> > Does anyone have any suggestions or thoughts on evaluating this
 large
> > a number of indexes?
> > Thanks in advance.
> >
> > Walt Maguire
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 04 2000 - 02:28:34 CST