Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 04 Jul 2004 18:29:18 GMT
Message-ID: <20YFc.7384$JR4.2776@attbi_s54>

Following is a summary of articles spanning a 7 day period, beginning at 27 Jun 2004 19:23:09 GMT and ending at 04 Jul 2004 17:36:01 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: 179
Articles: 541 (111 with cutlined signatures) Threads: 127

Volume generated: 1336.4 kb


     - headers:    582.9 kb (9,745 lines)

     - bodies:     726.0 kb (20,953 lines)

     - original:   361.1 kb (11,032 lines)

     - signatures: 27.0 kb (958 lines)


Original Content Rating: 0.497

Averages

Posts per poster: 3.0

     median: 1 post
     mode:   1 post - 98 posters
     s:      5.4 posts
Posts per thread: 4.3
     median: 3 posts
     mode:   1 post - 29 threads
     s:      5.1 posts
Message size: 2529.5 bytes


     - header:     1103.3 bytes (18.0 lines)

     - body:       1374.1 bytes (38.7 lines)

     - original:   683.5 bytes (20.4 lines)

     - signature:  51.1 bytes (1.8 lines)

Top 10 Threads by Number of Posts

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

    26 Why?
    23 Windows ASM and DBCA in 10g
    16 SQL Server to Oracel
    14 Eliminating Combinatorial Relationship Multiplication     12 Tablespace Offline on Oracle 817i     11 ref cursor slow compared to sql query     11 Setting ulimit values in files on Redhat AS 2.1     10 ORA-04031: unable to allocate 8192 bytes of shared memory     10 OMLETv4 The Ultimate Instance Monitor      9 recover question

These threads accounted for 26.2% of all articles.

Top 10 Threads by Volume

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

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

   69.7 ( 21.6/ 47.9/ 21.7)     16  SQL Server to Oracel
   63.6 ( 27.0/ 35.7/ 17.3)     23  Windows ASM and DBCA in 10g
   56.1 ( 32.2/ 22.7/ 10.9)     26  Why?
   49.7 ( 16.4/ 32.9/ 15.0)     14  Eliminating Combinatorial
                                    Relationship Multiplication
   47.1 (  2.6/ 44.5/ 21.8)      3  FATAL ERROR IN TWO-TASK SERVER: error
                                    = 12571
   39.7 ( 11.4/ 28.3/  6.6)     10  OMLETv4 The Ultimate Instance Monitor
   32.1 (  7.0/ 24.8/  8.3)      7  Oracle won't release locks - ever!
   28.4 ( 14.6/ 13.5/  5.9)     11  Setting ulimit values in files on
                                    Redhat AS 2.1
   26.9 ( 14.3/ 10.8/  6.1)     11  ref cursor slow compared to sql query
   25.6 (  6.9/ 18.7/  6.0)      7  Stored procedure compilation problem

These threads accounted for 32.8% of the total volume.

Top 10 Targets for Crossposts

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

       39  comp.databases.oracle.misc
       34  comp.databases.ms-sqlserver
       20  comp.databases.oracle.tools
       18  comp.databases
       18  comp.databases.theory
       16  microsoft.public.sqlserver.server
       14  linux.redhat.install
       13  comp.os.linux.redhat
       12  comp.databases.oracle.marketplace
       11  comp.os.linux.misc

Received on Sun Jul 04 2004 - 13:29:18 CDT

Statistics for comp.databases.oracle.server - WE 07/04/2004