Question concerning showfile

From: Brewer, Edward (BREWERE@OD.NIH.GOV)
Date: Fri Sep 20 2002 - 15:21:20 EDT


Admins,

        I was examining performance on my system an encountered a strange
thing. When I examine a file with showfile I get the following

 ** ** ** ** advfs ** ** ** ** <name of the
file>.dbf

This file is actually a rollback segement for an oracle 8.1.7.3 instance.
Some of the other rollback segments have information this one doesn't. I
have noticed that the disk containing the roll back segment is
experiencing disk wait time that peak at 4000 ms then drop off to close to
zero. This happens occasionally and probably represent someone dropping a
table or something.... Does anyone know why there are only *****'s?

TIA,
Lee Brewer
         



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:53 EDT