-----Original Message-----
Ari, I have a question about running bstat and estat, Is there any reason
why you can't run these utilities with a different user instead of sys, as
long as that user has select on any table? I would like to create the begin
and end stat tables in a different tablespace besides the system tablespace.
Will doing this skew the report for estat?  I'm concern running these on
periodic basis using sys will 
fragment the system tablespace.

You wed site is great, there a lot of great tips!


---- Reply -----------
Your assumptions are correct. You can use bstat and estat from any user account,
as long as they can see the v$ views and everything else that is used with bstat
/estat. It's a good idea; I never thought of doing it outside of the SYSTEM
tablespace myself.

Thanks for the comments.


Back to Ari Kaplan's Home Page n's Home Page