Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 09 Jun 2003 01:11:00 GMT
Message-ID: <E8REa.622166$Si4.565781@rwcrnsc51.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 02 Jun 2003 01:32:59 GMT and ending at 08 Jun 2003 23:54: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: 230
Articles: 735 (141 with cutlined signatures) Threads: 173
Volume generated: 2132.5 kb

headers: 806.0 kb (13,081 lines)
bodies: 1271.6 kb (36,755 lines)
original: 561.3 kb (17,488 lines)
signatures: 54.2 kb (1,783 lines)

Original Content Rating: 0.441

Averages

Posts per poster: 3.2

     median: 2.0 posts
     mode:   1 post - 113 posters
     s:      4.8 posts
Posts per thread: 4.2
     median: 3 posts
     mode:   2 posts - 44 threads
     s:      5.0 posts
Message size: 2971.0 bytes


     - header:     1122.9 bytes (17.8 lines)

     - body:       1771.6 bytes (50.0 lines)

     - original:   782.0 bytes (23.8 lines)

     - signature:  75.5 bytes (2.4 lines)

Top 10 Threads by Number of Posts

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

21 Where is the trcroute utility?
17 Can Someone Point Me At Some Whitepapers Comparing Oracle to

        M$$QL$erver??
    17 What kind of a DBA are you?
    16 Please help - ORA 04030: out of process memory...     15 OT: was What kind of a DBA are you? - what's your poison?     14 Storage: SAN, NAS, or Local
    14 CASE strucrure in PL/SQL
    13 How do you set up shared server connecttion?     13 Query gives incorrect results
    13 SQL - filtering data based on AND condition

These threads accounted for 20.8% of all articles.

Top 10 Threads by Volume

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

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

  393.4 (  5.0/388.4/123.2)      5  Performance issue and statspack
   59.2 ( 18.3/ 40.9/ 16.1)     16  Please help - ORA 04030: out of
                                    process memory...
   53.8 (  7.8/ 45.7/  8.6)      7  pl/sql overflow buffer problem
   51.4 ( 23.8/ 22.8/ 11.5)     21  Where is the trcroute utility?
   47.0 ( 22.1/ 21.1/  7.7)     17  Can Someone Point Me At Some
                                    Whitepapers Comparing Oracle to
                                    M$$QL$erver??
   41.5 ( 20.9/ 20.5/  8.9)     15  OT: was What kind of a DBA are you? -
                                    what's your poison?
   37.8 (  7.8/ 30.0/  9.6)      7  query performance -- another try
   36.5 ( 15.4/ 16.0/  6.5)     13  Query gives incorrect results
   34.3 ( 15.6/ 14.1/  6.9)     14  Storage: SAN, NAS, or Local
   34.3 ( 15.3/ 18.6/  8.1)     14  CASE strucrure in PL/SQL

These threads accounted for 37.0% of the total volume.

Top 10 Targets for Crossposts

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

       30  comp.databases.oracle.misc
       21  comp.databases.oracle.tools
       12  comp.databases.oracle
        8  hr.comp.programiranje.baze
        5  comp.database.oracle
        4  microsoft.public.cert.exam.mcse
        4  microsoft.public.certification
        4  microsoft.public.vb.database.ado
        4  microsoft.public.access.adp.sqlserver
        3  comp.databases.olap

Received on Sun Jun 08 2003 - 20:11:00 CDT

Statistics for comp.databases.oracle.server - WE 06/08/2003