Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 23 Nov 2003 23:47:02 GMT
Message-ID: <WFbwb.287193$Tr4.896223@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 16 Nov 2003 23:58:22 GMT and ending at 23 Nov 2003 23:31:22 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: 173
Articles: 524 (107 with cutlined signatures) Threads: 113

Volume generated: 1287.3 kb


     - headers:    573.3 kb (9,409 lines)

     - bodies:     685.5 kb (21,754 lines)

     - original:   310.4 kb (10,414 lines)

     - signatures: 28.0 kb (910 lines)


Original Content Rating: 0.453

Averages

Posts per poster: 3.0

     median: 1 post
     mode:   1 post - 88 posters
     s:      4.4 posts
Posts per thread: 4.6
     median: 3 posts
     mode:   1 post - 24 threads
     s:      5.1 posts
Message size: 2515.6 bytes


     - header:     1120.3 bytes (18.0 lines)

     - body:       1339.6 bytes (41.5 lines)

     - original:   606.6 bytes (19.9 lines)

     - signature:  54.7 bytes (1.7 lines)

Top 10 Threads by Number of Posts

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

    40 db cache size in oracle 9ir2
    21 Another Oracle "Myth"?
    20 Myth revisited ...
    17 DBMS_REPAIR, 8.1.7
    16 Patch Set for 8.1.7.4 failed to upgrade     14 "Nologging"-option tablespace and tables     14 Index not used therefore rebuild the thing ...     12 -- insert instead of an update
    12 Synchronizing 2 tables in same database -how ?     11 dbms_stats set_table_stats, set_index_stats and set_columns_stats

These threads accounted for 33.8% of all articles.

Top 10 Threads by Volume

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

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

  105.0 ( 53.3/ 49.9/ 27.0)     40  db cache size in oracle 9ir2
   56.8 ( 17.2/ 39.3/  5.7)     16  Patch Set for 8.1.7.4 failed to
                                    upgrade
   53.3 ( 20.9/ 31.1/ 16.6)     20  Myth revisited ...
   50.3 ( 22.2/ 27.4/  7.8)     17  DBMS_REPAIR, 8.1.7
   49.8 ( 22.9/ 25.5/ 14.9)     21  Another Oracle "Myth"?
   44.6 ( 17.4/ 26.7/  8.7)     14  "Nologging"-option tablespace and
                                    tables
   42.2 ( 12.0/ 29.0/ 16.3)     10  How to test to VARCHAR2's for
                                    equality EFFICIENTLY ?
   39.6 ( 16.8/ 21.9/  7.9)     14  Index not used therefore rebuild the
                                    thing ...
   36.6 ( 12.8/ 23.7/  7.9)     12  -- insert instead of an update
   28.9 ( 11.2/ 17.6/  7.4)     11  dbms_stats set_table_stats,
                                    set_index_stats and set_columns_stats

These threads accounted for 39.4% of the total volume.

Top 10 Targets for Crossposts

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

        7  comp.databases.oracle.misc
        6  alt.os.linux
        6  comp.os.linux.setup
        6  comp.os.linux.misc
        6  alt.os.linux.suse
        3  comp.unix.solaris
        2  comp.databases.oracle.marketplace

Received on Sun Nov 23 2003 - 17:47:02 CST

Statistics for comp.databases.oracle.server - WE 11/22/2003