How to turn Oracle statistics Off?
From: Takaoki Sekiguchi <takaoki_at_cow.melco.co.jp>
Date: Wed, 24 Aug 1994 01:11:42 GMT
Message-ID: <TAKAOKI.94Aug23201142_at_visar.cow.melco.co.jp>
Date: Wed, 24 Aug 1994 01:11:42 GMT
Message-ID: <TAKAOKI.94Aug23201142_at_visar.cow.melco.co.jp>
I have been measuring Oracle Performance. Off course,parameters in *.ora( e.g. timed_statistics = FALSE etc) related to oracle statistics are set FALSE.
But some statistics are recorded in data dictionary. ( .e.g. v$sysstat,v$datafile,v$filestat etc.)
Would someone tell me the way to turn off those statistics ?
Thanks in advance.
+-----------------------------------------+
| Takaoki Sekiguchi |
| Open Sytems Group C |
| Open Sytems Development Department |
| Imformation Systems Engineering Center |
| |
| Mitsubii Electric Corporation |
| 325 Kamimachiya Kamakura, |
| Kanagawa 247, JAPAN |
| Phone(+81)467-43-8301 |
| FAX(+81)467-43-8272 |
+-----------------------------------------+
-- ************************************************** 三菱電機(株) 情報システム製作所 高性能サーバ開発部 開発第3グループ 関口 孝興 E-mail: takaoki_at_ok.cow.melco.co.jp 〒251 神奈川県鎌倉市上町屋325番地 TEL 0467-43-8301 FAX 0467-43-8272 MIND 7-421-8548 **************************************************Received on Wed Aug 24 1994 - 03:11:42 CEST