Statistics for comp.databases.oracle.server - WE 12/28/2003

Home -> Community -> Usenet -> c.d.o.server -> Statistics for comp.databases.oracle.server - WE 12/28/2003 - Happy New Year !!

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 28 Dec 2003 20:48:24 GMT
Message-ID: <skHHb.686639$Fm2.592832@attbi_s04>

Following is a summary of articles spanning a 7 day period, beginning at 21 Dec 2003 21:33:26 GMT and ending at 28 Dec 2003 17:10:32 GMT.

Notes

A line in the body of a post is considered to be original if it does *not* match the regular expression /^\s{0,3}(?:>|:|\S+>|\+\+)/.
All text after the last cut line (/^-- $/) in the body is considered to be the author's signature.
The scanner prefers the Reply-To: header over the From: header in determining the "real" e-mail address and name.
Original Content Rating (OCR) is the ratio of the original content volume to the total body volume.
Find the News-Scan distribution on the CPAN! <URL:http://www.perl.com/CPAN/modules/by-module/News/>
Please send all comments to Greg Bacon <gbacon_at_cs.uah.edu>.
Copyright (c) 1998 Greg Bacon. All Rights Reserved. Verbatim copying and redistribution is permitted without royalty; alteration is not permitted. Redistribution and/or use for any commercial purpose is prohibited.

Totals

Posters: 106
Articles: 274 (48 with cutlined signatures) Threads: 68
Volume generated: 653.1 kb

headers: 299.9 kb (4,902 lines)
bodies: 337.7 kb (10,335 lines)
original: 182.4 kb (5,810 lines)
signatures: 15.3 kb (558 lines)

Original Content Rating: 0.540

Averages

Posts per poster: 2.6

     median: 1.0 post
     mode:   1 post - 60 posters
     s:      3.2 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 18 threads
     s:      4.5 posts
Message size: 2441.0 bytes


     - header:     1120.9 bytes (17.9 lines)

     - body:       1262.0 bytes (37.7 lines)

     - original:   681.5 bytes (21.2 lines)

     - signature:  57.0 bytes (2.0 lines)

Top 10 Threads by Number of Posts

Posts Subject
----- -------

    23 buffer hit cache ratio
    20 'alter session set sql_trace=true' bug or feature ?     14 High availability for Oracle
    12 Oracle 9.2.0.4 ?

     9  Adding new datafile question
     9  Smart SQL function wanted
     9  Display only part of resultset (ORA 8.1.7)
     9  Buffer cache statistics (ratios) and CBO SQL optimization?
     7  Applying patch 9.2.0.4.0 Quirks
     6  Webserver connection pooling and sql trace

These threads accounted for 43.1% of all articles.

Top 10 Threads by Volume

(kb) (kb) (kb) (kb)
Volume ( hdr/ body/ orig) Posts Subject

--------------------------  -----  -------

   70.8 ( 23.1/ 43.5/ 21.4)     20  'alter session set sql_trace=true'
                                    bug or feature ?
   53.8 ( 25.8/ 25.0/ 15.9)     23  buffer hit cache ratio
   35.1 ( 15.8/ 18.3/  5.7)     14  High availability for Oracle
   26.6 (  9.3/ 17.2/ 12.5)      9  Buffer cache statistics (ratios) and
                                    CBO SQL optimization?
   26.5 (  9.9/ 16.5/  6.8)      9  Smart SQL function wanted
   26.3 ( 13.2/ 12.9/  6.8)     12  Oracle 9.2.0.4 ?
   25.0 ( 11.4/ 13.4/  4.6)      9  Display only part of resultset (ORA
                                    8.1.7)
   22.0 (  5.6/ 13.4/  7.2)      5  Query Runs Much Longer in 9i than in
                                    8i
   20.7 (  9.3/ 11.4/  4.8)      9  Adding new datafile question
   17.8 (  7.8/  9.3/  2.6)      5  Where is Oracle&#8217;s Grid ?

These threads accounted for 49.7% of the total volume.

Top 10 Targets for Crossposts

Articles Newsgroup
-------- ---------

       12  comp.databases.oracle.misc
        4  comp.databases.oracle.tools
        2  comp.unix.solaris
        1  comp.databases.oracle.theory
        1  poster

Received on Sun Dec 28 2003 - 14:48:24 CST