Excellent, that was exactly the kind of answer I was expecting.
Thank you very much,
--Claudio
On Wed, 1 Nov 2006 09:36:11 -0600, Kerber Andrew wrote
> 1. Use extent management local, uniform extent sizes, segment space
> management auto for best performance.
>
> 2. Depends on size of table, small table, small extents, large
> table,
large extents. Its more a matter of wasting space than
> performance.
> 3. It matters more on indexes, wouldn't worry about it for table
> data.
> 4. Alter table move tablespace whatever.
>
> -----Original Message-----
> From: Claudio Alonso -Oracle DBA
> [mailto:oracledba-ezmlmshield-x57222683.[Email address protected]
> Sent: Wednesday, November 01, 2006 9:16 AM
> To: LazyDBA Discussion
> Subject: Performance and extents -again
>
> I'm sorry to insist...
> Please, are there any answers for these questions?
> Thanks again,
>
> --Claudio
>
> 1) I would like to know if you recommend to use uniform extent sizes
> or
auto allocation for this (I'm not familiar with the last one,
> which
seems to be used in this installation).
>
> 2) Do you consider that a few bigger extents (with size multiple of
> the
multiblock read size) would lead to better query performance
> than a lot
of small extents?
>
> 3) Would it be good to use a tablespace with bigger block size for
> the
bigger tables? (let's say 16k, 32k or 64k against the original
> 8k).
>
> 4) What would be the recommended way to move a table and it's
> indexes
and lobs from a group of tablespaces to another group of
> tablespaces
> (let's say from DATA8K, INDEX8K and LOBS8K to DATA32K, INDEX32K and
> LOBS32K)
>
> --Claudio
> PS: Remember I'm using 9i.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> post a
dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com
To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
> -----------------------------------------
> CONFIDENTIALITY NOTICE
>
> This message and any attachments are from the NAIC and are intended
> only for the addressee. Information contained herein is
> confidential, and may be privileged or exempt from disclosure
> pursuant to applicable federal or state law. This message is not
> intended as a waiver of the confidential, privileged or exempted
> status of the information transmitted. Unauthorized forwarding,
> printing, copying, distribution or use of such information is
> strictly prohibited and may be unlawful. If you are not the
> addressee, please promptly delete this message and notify the
> sender of the delivery error by e-mail or by calling the NAIC Help
> Desk at (816)783-8500.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page