Re: Slow response from a table

Hi Ben,

Did you run ANALYZE against the table?

Also check for chained rows. If your PCTFREE isn't large enough and you are adding/updating VARCHAR or VARCHAR2 columns you can wind up with more extents than there are grains of sand -- well it seems that way.

Regards

Jerry

Ben Poels wrote:
>
> Hi,
>
> I have an Oracle table that is giving me slow response times. This
> table represents current years data. Access to last year's data table
> is much quicker and I am wondering why? Both tables are in the same
> tablespace. I was the only active session when I did my benchmarks. I
> have exported and imported it and moved it to a different filename on
> a different disk drive with little or no improvement.
>
> Any other suggestions. What statistics should I audit to try to
> discover what is happening here? Thanks,
>
> Ben
> Ben Poels
> Queen's University
> Kingston, ON, Canada

--
Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.net Received on Mon Apr 13 1998 - 22:17:00 CDT