"Read Time" and "Max Read Time"

From: Tom Underhill <tom.underhill_at_alandick.co.uk>
Date: 3 Aug 2002 02:43:29 -0700
Message-ID: <2f72092.0208030143.508dfa12@posting.google.com>

when issuing the following query:

SELECT  b.name 		   "Datafile",
		a.READTIM  "Read Time",	 
		a.MAXIORTM "Max Read Time",	
  FROM 	v$filestat a,
  	v$datafile b, 

  WHERE a.FILE#=b.FILE#

For my Temporary tablespace, "Read Time" shows a value of 3 and "Max readtime" shows a value of 4868 - how can this be ?

I am using oracle 8.0.5

Many Thanks,

Tom Underhill. Received on Sat Aug 03 2002 - 04:43:29 CDT