Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Mon, 23 Aug 2004 01:02:37 GMT
Message-ID: <NmbWc.296435$a24.102457@attbi_s03>

Following is a summary of articles spanning a 7 day period, beginning at 16 Aug 2004 01:31:41 GMT and ending at 23 Aug 2004 00:43:50 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: 144
Articles: 460 (112 with cutlined signatures) Threads: 105

Volume generated: 1063.3 kb


     - headers:    468.0 kb (8,122 lines)

     - bodies:     576.9 kb (17,219 lines)

     - original:   268.3 kb (8,476 lines)

     - signatures: 17.9 kb (705 lines)


Original Content Rating: 0.465

Averages

Posts per poster: 3.2

     median: 2.0 posts
     mode:   1 post - 68 posters
     s:      5.6 posts
Posts per thread: 4.4
     median: 3 posts
     mode:   1 post - 23 threads
     s:      3.8 posts
Message size: 2367.1 bytes


     - header:     1041.8 bytes (17.7 lines)

     - body:       1284.3 bytes (37.4 lines)

     - original:   597.2 bytes (18.4 lines)

     - signature:  39.9 bytes (1.5 lines)

Top 10 Threads by Number of Posts

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

    19 DB Buffer Cache Size
    18 Type of shutdown
    16 Thinking about archived redo-logs SIZE     15 How to fire a stored proc from a query window     13 Adding rollback
    11 Execution interval is incorrect while using DBMS_JOB.SUBMIT     11 Select First 500 Rows of a Table     11 Heavy Duty schema manager tool? (was Re: DBA Jobs)     11 Shared Pool: Can it be filled *over* 100% ?     11 Looking for Howard Roger's RAC Article

These threads accounted for 29.6% of all articles.

Top 10 Threads by Volume

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

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

   63.8 ( 20.3/ 42.8/ 22.9)     19  DB Buffer Cache Size
   48.6 ( 19.2/ 29.3/  9.3)     18  Type of shutdown
   42.6 ( 12.2/ 30.3/  6.3)     11  Heavy Duty schema manager tool? (was
                                    Re: DBA Jobs)
   39.3 ( 13.4/ 25.6/ 10.7)     13  Adding rollback
   38.5 ( 15.7/ 22.6/  7.9)     15  How to fire a stored proc from a
                                    query window
   37.3 (  4.3/ 28.4/  5.9)      4  IOT, INDEX_DESC and Rownum=1
   34.8 ( 16.7/ 17.6/  7.1)     16  Thinking about archived redo-logs
                                    SIZE
   26.2 (  9.1/ 16.9/  4.5)      8  Slowness on insert statemente
   25.7 ( 11.4/ 14.2/  6.4)     11  2GB Problem with Oracle 8.0.5 an
                                    Windows 2000 Server
   25.7 ( 13.1/ 12.5/  5.2)     11  Shared Pool: Can it be filled *over*
                                    100% ?

These threads accounted for 36.0% of the total volume.

Top 10 Targets for Crossposts

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

       21  comp.databases.oracle.misc
       11  comp.databases.oracle.tools
        4  comp.lang.perl.misc
        4  comp.databases.oracle
        4  comp.lang.javascript
        4  comp.lang.basic.visual.database
        4  comp.lang.java.api
        2  comp.databases.oracle.marketplace
        2  comp.database.oracle
        1  php.dev

Received on Sun Aug 22 2004 - 20:02:37 CDT

Statistics for comp.databases.oracle.server - WE 08/22/2004