Re: How to optimize readonly data ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 12 Dec 1999 18:59:47 +0800
Message-ID: <38538023.527F@yahoo.com>

Michael Keppler wrote:
>
> Hello everyone !
>
> I have a tablespace with data that is deleted and newly loaded from
> external data with sql loader 4 times a year. After loading the data and
> generating some indizes all the data will only be read for the next
> three months but not written.
>
> What can I do to
> * optimize the access time
> * optimize the memory usage
> * never backup this tablespace (because the loading of the data needs
> about the same time as the recovery) to not waste space on the backup
> tape.
>
> --
> Michael Keppler, MCSE, MCP+I
> IT logic GbR
> Michael.Keppler_at_gmx.de

• Set PCTFREE to 0 to minimise the space
• Look at read-only tablespaces, these will yield the "backup once only" requirement you have
• Look at partitioning to ease the rolling window burden

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Dec 12 1999 - 04:59:47 CST