Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db file sequential reads

RE: db file sequential reads

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sat, 14 Oct 2000 11:53:12 +0400
Message-Id: <10649.119242@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
----------------------------------- -------
Received on Sat Oct 14 2000 - 02:53:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US