Re: reallocating tablespaces

1. ! beleive you can alter your tablespaces to pctincrease 0 and the next extent to be some size but this won't really change much unless any new objects are created without any size info. (Highly unlikely)
2. If you need to move indexes from one tablespace to another you can use the rebuild option of the alter index command and specify the new tablespace there. (I belive there is a possiblity of index corruptions on 7.3.2.3 if you used this option) Moving tables is a little more complex and usually involves a exp/imp.
3. To please your boss, show him the output from a before/after tkprof dump. This will show him what he wants to see if he can make sense of it. The best way for him to test perfomance is to sign on during peak usage times and see if he finds the application is running smoothly.

HTH
Scott Watson.

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 Wed Jan 05 2000 - 21:32:41 CST