Re: reallocating tablespaces

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.
>

You can change the default storage parameters of a tablespace at any time. However, the objects that already have been created (probably) with the default parameters. The only way to change the storage parameters of existing objects is via export/import.

> 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?

You can get query execution times with tkprof. You can tune all the buffers and parameters you want, but 80% of tuning is tuning the actual queries. Give your users enough DB_BLOCK_BUFFERS and SHARED_POOL and then tune the users queries...

>
>
> --
> 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:59:22 CST