Re: tblspaces with bufreads but no isreads

Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dkosenko@hotmail.com> wrote in message > news:d9d3b2cf.0409290546.43e2cb6a@posting.google.com... > >>Wonder if anyone has noticed this before and/or has any >>idea as to why this is the case. Monitoring my databases >>via sysmaster (sysptprof in particular), I see a fair >>amount of bufreads activity on tblspaces with no corresponding >>isread (or iswrite, etc.) activity. What sort of access >>of these tblspaces would cause such behavior? I thought >>maybe light scans might cause this, but that is not happening >>in this case, nor am I seeing sequential scans. The >>tblspaces in question are definitely tables, not detached >>indexes. >> >>I can't say that this behavior is out of the realm of normal, >>as I hadn't really noticed it before (actually I just added >>bufreads and bufwrites per tablespace to my monitoring >>tool), but it doesn't seem quite right to me. >> >>Thanks, >>Dave > > >