Re: reallocating tablespaces

Hi,

Please notice that setting tablespaces PCTINCREASE to zero will cause those tablespaces to be Excluded from "fet$/uet$". The matter which will lead Oracle background processes not to automatically coalesce the free space within those tablespaces.

We actually recommend setting PCTINCREASE 0 for TEMPORARY tablespace mainly due to system "intensive waits" while trying to coalesce the free space.

"
The Views expressed here are my own and not necessarily those of Oracle Corporation"

"Ed Stevens" <Ed.Stevens_at_nmm.nissan-usa.com> wrote in message news:8506fm$bsg$1_at_nnrp1.deja.com...
> Well, I've just completed the Oracle Performance and Tuning Workshop
> and am ready to attack our large collection of databases. All of these
> databases were built by either myself or one other DBA, and we both
> started with zero Oracle experience. As you can imagine, there are
> lots of tuning opportunities to correct past sins.
>
> One of the first things I want to do is correct the storage allocations
> of our tablespaces, resizing the extents and resetting PCTINCREASE back
> to zero. Could someone point me in the direction to best accomplish
> this? I'm sure I can figure out *a* way of doing it, and I'm not
> looking for a ready-to-run solution, just a point in the right
> direction, to avoid excessive spinning of wheels.
>
> One other item: As those who have taken the class know, it covers all
> sorts of things that impact performance, how to measure them, how to
> adjust them. But they are all "internal" things. My boss has said the
> one measure he cares about is query execution time -- how long does it
> take to execute a query. I can do all kinds of things with buffer
> caches, log files, file distribution, etc. etc. etc. but in the end
> I've got to be able to measure and show improvement in application
> response time. That was the one measurement I don't recall covering in
> the class. Again -- any hints?
>
>
> --
> Ed Stevens
> (Opinions are not necessarily those of my employer)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jan 08 2000 - 09:31:24 CST