RE: db file sequential reads

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sat, 14 Oct 2000 11:53:12 +0400
Message-Id: <10649.119243@fatcity.com>

If I remember correctly, I used to set/reset timed_statistics dynamically for running utl*stat scripts even in Oracle 7.3.4 (apart from 8.0.5 ) databases on DEC Unix Platform.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Mohan, Ross Sent: Saturday, October 14, 2000 2:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: db file sequential reads

Break out the champagne, amigo! ( timed_statistics does NOT require an instance bounce)

SVRMGR> select * from v$version;

BANNER

Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production      
PL/SQL Release 8.1.5.1.0 - Production                           
CORE Version 8.1.3.0.0 - Production                             
TNS for Solaris: Version 8.1.5.0.0 - Production                 
NLSRTL Version 3.4.0.0.0 - Production

SVRMGR> show parameter timed_s

NAME                                TYPE    VALUE
----------------------------------- -------
------------------------------
timed_statistics                    boolean FALSE

SVRMGR> alter system set timed_statistics=TRUE; Statement processed.

SVRMGR> show parameter timed_s

NAME                                TYPE    VALUE

Received on Sat Oct 14 2000 - 02:53:12 CDT