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

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 02 Nov 2003 16:26:43 GMT
Message-ID: <7fapb.67309$ao4.172829@attbi_s51>

Following is a summary of articles spanning a 7 day period, beginning at 26 Oct 2003 16:43:15 GMT and ending at 02 Nov 2003 15:32:54 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: 211
Articles: 663 (187 with cutlined signatures) Threads: 161

Volume generated: 1686.2 kb


     - headers:    709.9 kb (11,954 lines)

     - bodies:     835.8 kb (26,658 lines)

     - original:   415.8 kb (14,024 lines)

     - signatures: 139.8 kb (4,238 lines)


Original Content Rating: 0.497

Averages

---

Posts per poster: 3.1

     median: 1 post
     mode:   1 post - 107 posters
     s:      6.0 posts
Posts per thread: 4.1
     median: 3 posts
     mode:   1 post - 42 threads
     s:      5.1 posts
Message size: 2604.4 bytes


     - header:     1096.5 bytes (18.0 lines)

     - body:       1291.0 bytes (40.2 lines)

     - original:   642.2 bytes (21.2 lines)

     - signature:  215.9 bytes (6.4 lines)

Top 10 Posters by Number of Posts

---

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

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

    67   250.3 ( 78.9/ 76.8/ 30.2)  Daniel Morgan
    24    67.8 ( 28.5/ 19.8/ 13.5)  Niall Litchfield
    20    39.5 ( 20.1/ 19.4/  7.0)  Sybrand Bakker
    19    45.6 ( 19.4/ 21.4/  8.5)  Brian Peasland
    16    42.9 ( 21.7/ 18.8/  9.9)  mcstock
    14    39.9 ( 14.6/ 25.3/  9.6)  Joel Garry
    14    54.8 ( 13.0/ 41.8/ 16.5)  VC
    14    41.2 ( 15.2/ 26.1/ 17.1)  Jonathan Lewis

    11 17.2 ( 11.7/ 5.5/ 3.3) Robert C     10 10.1 ( 7.8/ 2.2/ 2.2) dominant

These posters accounted for 31.5% of all articles.

Top 10 Posters by Volume

---

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

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

  250.3 ( 78.9/ 76.8/ 30.2)     67  Daniel Morgan
   67.8 ( 28.5/ 19.8/ 13.5)     24  Niall Litchfield
   54.8 ( 13.0/ 41.8/ 16.5)     14  VC
   45.6 ( 19.4/ 21.4/  8.5)     19  Brian Peasland
   42.9 ( 21.7/ 18.8/  9.9)     16  mcstock
   41.2 ( 15.2/ 26.1/ 17.1)     14  Jonathan Lewis
   39.9 ( 14.6/ 25.3/  9.6)     14  Joel Garry
   39.5 ( 20.1/ 19.4/  7.0)     20  Sybrand Bakker
   37.9 ( 10.7/ 27.2/ 16.1)      9  ben brugman
   35.7 (  5.7/ 29.9/ 12.5)      6  gdb_dsr

These posters accounted for 38.9% of the total volume.

Top 10 Threads by Number of Posts

---

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

    37 SQL Server Yukon
    17 Maximum number of transaction. (Newby question).     13 Difference between oracle Synonyms and Views.     12 How fast should an IO be on a SYMMETRIX?     12 How can I drop a database?
    11 Shared server mode and Real application cluster     11 Difference between SYSDATE and TO_DATE     11 Upgrade from 7.x to 9i release 2     11 Any way to "conditionally" drop a table?     10 Performance DB-Link

These threads accounted for 21.9% of all articles.

Top 10 Threads by Volume

---

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

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

  117.0 ( 46.7/ 40.7/ 19.0)     37  SQL Server Yukon
   50.7 ( 19.0/ 20.8/ 10.8)     17  Maximum number of transaction. (Newby
                                    question).
   40.2 ( 12.0/ 27.7/ 14.0)     12  How fast should an IO be on a
                                    SYMMETRIX?
   38.6 ( 11.0/ 27.3/  8.9)     10  REPOST (line wrap): How fast should
                                    an IO be on a SYMMETRIX?
   38.3 (  3.9/ 27.5/ 11.8)      4  Tuning
   36.3 (  7.3/ 28.6/ 25.8)      7  Oracle versioning discovery
   34.8 (  6.0/ 28.8/ 11.2)      6  database revovery issue(my system is
                                    down)
   32.4 ( 14.3/ 14.7/  8.3)     13  Difference between oracle Synonyms
                                    and Views.
   31.8 ( 12.2/ 19.1/  9.8)     11  Difference between SYSDATE and
                                    TO_DATE
   29.8 (  9.0/ 20.3/  5.9)      9  Chained Rows  VS new extent
                                    allocation

These threads accounted for 26.7% of the total volume.

Top 10 Targets for Crossposts

---

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

       21  comp.databases.oracle.misc
       10  comp.databases.oracle.tools
        7  comp.databases.ms-sqlserver
        5  comp.unix.solaris
        5  comp.sys.sun.apps
        5  comp.databases.oracle
        5  comp.sys.sun.admin
        4  de.comp.lang.delphi.datenbanken
        4  ch.comp.os.linux
        2  comp.databases.ibm-db2

Received on Sun Nov 02 2003 - 10:26:43 CST