RE: Tbs READ ONLY and Snapshot too old

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 18 Jun 2004 15:32:53 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNAEJKCEAA.lex.de.haan@naturaljoin.nl>

alternatives for overkill mode:

use the FULL hint in the query
perform an export to /dev/null

Kind regards,
Lex.

---

visit my website at http://www.naturaljoin.nl

---

[BL] Much easier to simply do "select max(column)..." on an un-indexed
column to cause FTS to cause cleanouts. Statistics is a bit of an overkill.

[PWS] Have tried that. Didn't work. Turned out that Oracle was using an
index to supply the needed info for one step in its execution plan, and _those_ were the blocks which needed to be cleaned out. So I went into overkill mode.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



application/ms-tnef attachment: winmail.dat

Received on Fri Jun 18 2004 - 08:30:29 CDT