which one (UTLBSTAT or UTLESTAT) creates STAT$END_...

Hi everybody, I'm reading Michael R. Ault's Oracle8 DBA: Performance Tuning. On p41 the first paragraph mentions something like: UTLBSTAT creates STAT$BEGIN_... tables and that UTLESTAT creates STAT$END_... tables. I checked the scripts in 8.0.5 and 8.1.5, and found that both STAT$BEGIN_... an

RE: which one (UTLBSTAT or UTLESTAT) creates STAT$END_...

Leslie, I do not have the book but the STATS$BEGIN... and STATS$END... tables are created by utlbstat.sql The utlestat.sql gathers all the stats, creates the summary tables and formats results into the report.txt file. HTH Suhen Hi everybody, I'm reading Michael R. Ault's Oracle8 DBA: Perfor

Re: which one (UTLBSTAT or UTLESTAT) creates STAT$END_...

Hi, I don't have the book but what Michael obviously meant is tha UTLESTAT is populating the STAT$END tables, ... and than calculates the differences between STAT$END and STAT$BEGIN and puts them in the report.txt. Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[