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.
Oracle LazyDBA home page