Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 18 Jan 2004 22:21:51 GMT
Message-ID: <3GDOb.82989$nt4.126228@attbi_s51>

Following is a summary of articles spanning a 7 day period, beginning at 11 Jan 2004 22:14:57 GMT and ending at 18 Jan 2004 21:24:56 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: 162
Articles: 512 (140 with cutlined signatures) Threads: 126

Volume generated: 1149.8 kb


     - headers:    545.9 kb (9,158 lines)

     - bodies:     568.6 kb (17,005 lines)

     - original:   284.1 kb (9,016 lines)

     - signatures: 34.8 kb (1,304 lines)


Original Content Rating: 0.500

Averages

Posts per poster: 3.2

     median: 1.0 post
     mode:   1 post - 83 posters
     s:      6.8 posts
Posts per thread: 4.1
     median: 3.0 posts
     mode:   1 post - 26 threads
     s:      3.5 posts
Message size: 2299.7 bytes


     - header:     1091.8 bytes (17.9 lines)

     - body:       1137.2 bytes (33.2 lines)

     - original:   568.3 bytes (17.6 lines)

     - signature:  69.6 bytes (2.5 lines)

Top 10 Threads by Number of Posts

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

    16 Oracle database Security.
    16 Buffer cache statistics (ratios) and CBO SQL optimization?     15 Any1 seen the latest on Larry?
    14 SQL Commands to interact with Windows Files in 9iR2     14 Hmmm, it's starting....
    13 ORACLE DBA will work for KIND BUD     13 Redo block size...
    12 How to find last record in a table?     11 Oracle 8.1.7 huge performance problem : please help !     10 10G

These threads accounted for 26.2% of all articles.

Top 10 Threads by Volume

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

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

   47.1 ( 22.3/ 23.1/ 11.9)     16  Buffer cache statistics (ratios) and
                                    CBO SQL optimization?
   38.4 ( 17.4/ 19.6/  5.8)     16  Oracle database Security.
   36.5 (  9.3/ 26.6/  7.9)      9  Problems running Oracle / Performance
   33.4 ( 10.6/ 22.7/ 10.2)     11  Oracle 8.1.7 huge performance problem
                                    : please help !
   30.9 ( 16.3/ 12.7/  4.5)     13  ORACLE DBA will work for KIND BUD
   29.1 ( 14.9/ 14.0/  5.7)     13  Redo block size...
   28.4 ( 16.8/ 11.2/  5.2)     14  SQL Commands to interact with Windows
                                    Files in 9iR2
   27.2 ( 11.4/ 14.7/  5.5)     10  10G
   25.6 ( 16.2/  7.2/  4.9)     15  Any1 seen the latest on Larry?
   25.2 (  8.0/ 17.2/  6.9)      8  ORA-12839 on 9.2.0.4

These threads accounted for 28.0% of the total volume.

Top 10 Targets for Crossposts

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

       39  comp.databases.oracle.misc
       15  comp.databases.oracle
       14  comp.databases.oracle.tools
       13  comp.database.oracle
        5  comp.os.linux
        5  microsoft.public.sqlserver.server
        2  comp.unix.solaris
        1  comp.os.linux.redhat
        1  alt.os.linux
        1  comp.os.linux.hardware

Received on Sun Jan 18 2004 - 16:21:51 CST

Statistics for comp.databases.oracle.server - WE 01/18/2004