Re: dedicated tablespaces

Richard,

You may want to consider a separate archiving tablespace with the TS default PCTFREE set to 0. Typically, archiving tables are inserted into, but not updated, so tweaking PCTFREE will reduce unused disk space.

Cheers,
Rich

In article <371C3A8C.C4E326F1_at_netscape.net>,   Richard Baines <richardbaines_at_netscape.net> wrote:
>
> Is there any benefit for setting up different tablespaces to store
> tables that will perform different roles. (using RAID by the way).
>
> We have a database used for general usage, lots of rows added to several
>
> tables and and regular deletions etc. We also have a set of archiving
> tables which are populated with data from the regular tables once a
> month, data is then exported from the archive tables, the archive tables
>
> are then truncated until the following archive occurs (standard sort of
> data archiving set up).
>
> Are there any performance benefits from putting the archive tables in
> their own tablespace. Is the regular populating of these tables and
> truncating of these tables adding to disk fragmentation in my main
> tablespaces.
>
> any experience/assisstance greatly appreciated
>
> Richard
>
>

--

Rich Goldkamp, Consultant, OCP		RJGoldka_at_dcss.com
Digital Consulting & Software Services	(504) 523-5005 x2736

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own