Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 19 Oct 2003 16:47:20 GMT
Message-ID: <sezkb.314804$mp.252337@rwcrnsc51.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 12 Oct 2003 05:12:58 GMT and ending at 19 Oct 2003 00:41:03 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: 170
Articles: 543 (165 with cutlined signatures) Threads: 136

Volume generated: 1451.0 kb


     - headers:    599.5 kb (9,618 lines)

     - bodies:     756.9 kb (22,542 lines)

     - original:   400.8 kb (12,522 lines)

     - signatures: 94.1 kb (2,798 lines)


Original Content Rating: 0.530

Averages

Posts per poster: 3.2

     median: 1.0 post
     mode:   1 post - 89 posters
     s:      6.4 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 34 threads
     s:      3.9 posts
Message size: 2736.4 bytes


     - header:     1130.6 bytes (17.7 lines)

     - body:       1427.4 bytes (41.5 lines)

     - original:   755.9 bytes (23.1 lines)

     - signature:  177.5 bytes (5.2 lines)

Top 10 Threads by Number of Posts

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

    20 Oracle DBA from SQL DBA
    18 Shared Instance/Database
    17 Slow Crystal Reports with Oracle     15 what happens if you lose a rollback segment?     14 Oracle's Myth: keep tables and indexes in separate tablespaces     13 hostname change & Oracle
    12 new word
    12 Update On Jitendra Patel & TUSC
    11 Oracle Names Server
    11 Dazed and confused

These threads accounted for 26.3% of all articles.

Top 10 Threads by Volume

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

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

   59.1 ( 19.4/ 35.5/ 20.2)     18  Shared Instance/Database
   56.1 ( 15.7/ 31.6/ 21.3)     10  Thee is a problem here I am sorry to
                                    have to report.
   53.3 ( 13.1/ 21.5/ 12.1)     12  Update On Jitendra Patel & TUSC
   47.8 ( 17.5/ 29.3/ 12.9)     15  what happens if you lose a rollback
                                    segment?
   47.6 ( 18.3/ 28.4/ 13.2)     14  Oracle's Myth: keep tables and
                                    indexes in separate tablespaces
   43.0 ( 22.3/ 16.2/  6.9)     20  Oracle DBA from SQL DBA
   38.1 (  6.1/ 31.6/ 14.7)      6  oracle rollback question
   36.7 ( 13.0/ 16.2/  4.0)     12  new word
   36.6 ( 14.4/ 19.5/  7.9)     13  hostname change & Oracle
   36.4 ( 10.3/ 18.0/ 10.5)      9  Can sombody list disadvantages of
                                    using Optimal setting for Rollback
                                    segs.

These threads accounted for 31.3% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

          (kb)    (kb)
OCR      orig /  body  Posts  Subject

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

0.674  ( 21.3/  31.6)     10  Thee is a problem here I am sorry to have
                               to report.
0.673  (  3.9/   5.8)      8  Counting Records
0.672  (  7.1/  10.6)      5  Checkpoints, redolog size, and ORA-01555
                               error
0.654  (  3.3/   5.0)      9  Is NFS a security problem with oracle
                               databases?
0.650  (  3.8/   5.8)      6  DB_FILE_MULTIBLOCK_READ_COUNT and single
                               block access
0.647  (  5.6/   8.6)      6  JDBC Connection to RAC Difficulties
0.635  (  3.2/   5.0)      6  DOS script problem - command hanging
0.626  (  3.4/   5.4)     10  Enabling archive logging
0.625  (  1.6/   2.5)      5  Sun Cluster 2.2, Solaris 2.6 and Oracle9
                               release2
0.612  (  0.7/   1.1)      5  After sum then max

Top 10 Targets for Crossposts

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

       29  comp.databases.oracle.tools
       27  comp.databases.oracle.misc
       14  comp.databases.oracle
        7  comp.lang.java.databases
        4  comp.unix.solaris
        3  comp.database.oracle
        1  linux.redhat
        1  comp.os.linux.misc
        1  comp.databases.oracle.marketplace

Received on Sun Oct 19 2003 - 11:47:20 CDT

Statistics for comp.databases.oracle.server - WE 10/17/2003