Re: analyzing queries performance

From: Marc Staudacher <marcst_at_gmx.ch>
Date: Fri, 8 Dec 2000 00:13:29 +0100
Message-ID: <90p5jd$198$1@bw107zhb.bluewin.ch>

> All tablespaces?

No, always system first! You have to try this command several times until it works!!

Sorry, I couldn't resist. The tablespace which holds your objects being tested should be taken offline to force Oracle to flush its cache.

regards,
Marc Staudacher

+++++++++ FineSolutions +++++++++++++++++++

Marc Staudacher
FineSolutions
Support and Development Engineer
Militaerstr. 76
Postfach 3428
CH-8021 Zurich

Tel: ++41 (0)1 245 85 71
Fax: ++41 (0)1 245 85 95

e-mail: marc.staudacher_at_finesolutions.ch Received on Thu Dec 07 2000 - 17:13:29 CST