Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 07 Jul 2003 01:28:49 GMT
Message-ID: <l14Oa.21995$NW6.20021@rwcrnsc51.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 30 Jun 2003 01:50:24 GMT and ending at 06 Jul 2003 23:28:55 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: 190
Articles: 547 (78 with cutlined signatures) Threads: 143

Volume generated: 1261.0 kb


     - headers:    587.6 kb (9,508 lines)

     - bodies:     649.0 kb (20,022 lines)

     - original:   335.4 kb (10,984 lines)

     - signatures: 23.8 kb (817 lines)


Original Content Rating: 0.517

Averages

Posts per poster: 2.9

     median: 2.0 posts
     mode:   1 post - 94 posters
     s:      4.2 posts
Posts per thread: 3.8
     median: 3 posts
     mode:   1 post - 41 threads
     s:      3.5 posts
Message size: 2360.6 bytes


     - header:     1100.0 bytes (17.4 lines)

     - body:       1215.0 bytes (36.6 lines)

     - original:   627.9 bytes (20.1 lines)

     - signature:  44.6 bytes (1.5 lines)

Top 10 Threads by Number of Posts

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

    24 object naming conventions
    15 Order of fields in a table.
    15 Unix to Windows DBA translation
    13 How to recover a dropped table ?     12 How to insert a space after each Manager Starts.     10 sending an email from a table trigger (before inserting row)     10 sysadmin access
    10 Which is the best choice, Oracle8i or Oracle9i for Oracle11i App?

     9  What is a UDT?
     9  Using Bind Variables with Cold Fusion and Oracle

These threads accounted for 23.2% of all articles.

Top 10 Threads by Volume

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

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

   56.7 ( 27.3/ 27.2/ 15.0)     24  object naming conventions
   39.7 ( 15.7/ 24.0/ 13.2)     15  Order of fields in a table.
   35.3 ( 15.2/ 19.1/  8.2)     15  Unix to Windows DBA translation
   34.7 (  9.9/ 20.0/ 13.0)      9  What *really* happens at ALTER TBSP
                                    END BKP ?
   32.7 (  7.9/ 24.8/  6.8)      7  question for daniel morgan
   32.5 (  8.6/ 23.3/  5.2)      8  How to create tables referenced each
                                    other
   27.8 (  9.5/ 14.6/  7.2)      8  My database is too fast
   25.5 (  6.2/ 19.3/ 10.7)      6  Interpreting  AUTOEXTENSION increment
                                    in DBA_DATA_FILES and altering it.
   25.4 ( 12.3/ 13.0/  4.9)     12  How to insert a space after each
                                    Manager Starts.
   24.9 ( 13.8/  9.5/  5.3)     13  How to recover a dropped table ?

These threads accounted for 26.6% of the total volume.

Top 10 Targets for Crossposts

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

       10  comp.databases.oracle.misc
        7  microsoft.public.fr.word
        7  comp.databases.oracle.tools
        7  alt.music.yes
        5  alt.apache.configuration
        5  comp.os.linux.networking
        3  comp.unix.tru64
        3  comp.databases.oracle.marketplace
        3  alt.tv.rugrats
        3  aus.computers.ai

Received on Sun Jul 06 2003 - 20:28:49 CDT

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