I have been challenged to participated and now challenged to explain my query by Chen
Ok, I give a try.
To make the query unreadable and unformatable I used to space, no new line, and I started by q’‘ to confuses sqlinform.
Ok, I added undocumented constructs like
connect by .1 > 1.
connect by .25 > rownum/100.
with 2 [...]
I’d noticed that the author name wasn’t showing up properly in the feeds from this blog so I went to investigate why. I logged into Feedburner (a rare event) and noticed these subscriber numbers.
I’m quite shocked. I only look in Statcounter sometimes to see where people are coming from and I get weekly Statcounter emails with the numbers which had shown that traffic was falling gradually. I reckoned that was down to the lack of activity round here lately, but it looks like it’s a reflection of the take-up of RSS over browsing.
1000 subscribers? I’m amazed.
P.S. My heart-felt thanks to the 2 subscribers to the personal blog 
I’ve been playing around with utlbstat.sql/utlestat.sql, only briefly I should add, for a short section on the history of Oracle’s performance tuning utilities and I noticed a couple of things that tickled me enough to blog about them.
First, as the scripts output the comments, I noticed that quite a few of the updates to these scripts have been made by familiar names. Here are a few examples I’ve snipped out.
SQL> Rem cdialeri 01/02/01 - 891059: SQL*Plus compat, 1566460: connect /SQL> Rem khailey 03/15/99 - 594266: Correct per logon stats, add fstat fieldsSQL> Rem akolk 08/09/96 - #387757: fix latch hitratiosSQL> Rem drady 09/09/93 - merge changes from branch 1.1.312.2
Oak Table Network members, all. So, there you go, another possible path to membership is to have worked on bstat/estat
Then I noticed a bug in the scripts as supplied with 10.2.0.4! (Not sure I have to be that specific about the version here) The fact that the 10g version of V$SESSION contains wait event information leads to the following bug.
SQL> insert into stats$begin_bck_event 2 select event, sum(total_waits), sum(time_waited) 3 from v$session s, v$session_event e 4 where type = 'BACKGROUND' and s.sid = e.sid 5 group by event; group by event *ERROR at line 5:ORA-00918: column ambiguously defined
Do you think I should file a bug report? I wonder what priority 10g bstat/estat bug-fixes have?
So, just to be clear, it’s a bit of fun. I think you probably have better tools available these days! It’s also very likely that I could lead a more varied and stimulating life if I put my mind to it