[Q] How much temporary space is needed to run ANALYZE command?

From: Dana Stockler <stockler_at_ingdata.no>
Date: 1996/11/23
Message-ID: <32972D73.7201_at_ingdata.no>#1/1

I asked this question before, but got no answer so I'll try again.

The ANALYZE TABLE command apparently requires a large temporary segment. I ran out of space in my temporary tablespace three times while trying to analyze my tables. Each time I expanded the tablespace and each time it was not enough.

Does anyone know how much temporary space is necessary in order to guarantee the error-free execution of the ANALYZE TABLE command? I want to schedule a batch job for execution once a week to run the ANALYZE command and I want to be sure it works.

Regards,

---

Dana Stockler

---

Home: Solstadlia 10, 1364 Hvalstad, Norway ((+47)66789741) Work: IngeniørData as, Strøket 9, 1370 Asker, Norway Email: stockler_at_ingdata.no

---

Received on Sat Nov 23 1996 - 00:00:00 CET