Re: Permanent TS for sorting
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle.tutorials@xxxxxxxxx
- Date: Mon, 26 Sep 2005 04:55:36 +0000
On 09/26/2005 12:37:28 AM, DBA Deepak wrote:
> Hi All,
> How can I use a permamnent tablespace for sorting operation as does the
> Temporary tablespace? Is it possible?
Yes it is, and it is a really good idea. That way, your temporary blocks will
not
only be protected by redo log, they will also generate undo information, as
their old values will be saved in undo segments. That will keep otherwise idle
process
like LGWR busy and warm for the situation when you need it. That will also make
your sorts
much safer and will have a clear effect on performance.
Blocks in tempfiles are not protected by either redo or undo, which means that
in case of
the instance failure the contents of your temporary work segments will be lost
for ever.
Undo records and redo log information will kindly preserve those segments for
posterity.
--
Mladen Gogala
http://www.mgogala.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
