SSD on temp or undo tablespace
From: qihua wu <staywithpin_at_gmail.com>
Date: Mon, 21 May 2012 16:57:39 -0700
Message-ID: <CAPoYtoL35hxKfATrZKagEDk6TP4CNqHBbr-E0cdQRNvFgY2nUQ_at_mail.gmail.com>
Hi experts,
We have limited budget, and put SSD for both undo and temp tablespace. We encountered ora-01555 error and some error that temp tablespace is not enough. I just want to know how SSD will be helpful for undo and temp tablespace. If temp on SSD has only limited benefit, we might assign all the SSD disk to undo, then use normal hard disk to temp. Did anyone have some suggestions
Date: Mon, 21 May 2012 16:57:39 -0700
Message-ID: <CAPoYtoL35hxKfATrZKagEDk6TP4CNqHBbr-E0cdQRNvFgY2nUQ_at_mail.gmail.com>
Hi experts,
We have limited budget, and put SSD for both undo and temp tablespace. We encountered ora-01555 error and some error that temp tablespace is not enough. I just want to know how SSD will be helpful for undo and temp tablespace. If temp on SSD has only limited benefit, we might assign all the SSD disk to undo, then use normal hard disk to temp. Did anyone have some suggestions
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 21 2012 - 18:57:39 CDT