Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sun, 07 Mar 2004 22:05:49 GMT
Message-ID: <11N2c.133672$Xp.573997@attbi_s54>

Following is a summary of articles spanning a 7 day period, beginning at 29 Feb 2004 22:38:57 GMT and ending at 08 Mar 2004 20:34:05 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: 182
Articles: 574 (174 with cutlined signatures) Threads: 136
Volume generated: 1784.4 kb

headers: 614.0 kb (10,504 lines)
bodies: 1100.2 kb (27,850 lines)
original: 784.3 kb (18,865 lines)
signatures: 69.6 kb (2,299 lines)

Original Content Rating: 0.713

Averages

Posts per poster: 3.2

     median: 1.0 post
     mode:   1 post - 106 posters
     s:      5.8 posts
Posts per thread: 4.2
     median: 3.0 posts
     mode:   1 post - 33 threads
     s:      5.4 posts
Message size: 3183.3 bytes


     - header:     1095.4 bytes (18.3 lines)

     - body:       1962.8 bytes (48.5 lines)

     - original:   1399.2 bytes (32.9 lines)

     - signature:  124.1 bytes (4.0 lines)

Top 10 Threads by Number of Posts

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

    45 SQL Fun Challenge #2
    19 Auditing: Trigger or Audit_Trail?     19 Troubleshooting ORA-01555 while using AUM     17 need help on statspack report, Parse CPU to Parse Elapsd %     14 Oracle8i client-Oracle10g server question     12 V$SQLAREA to determine most disk intensive SQL     12 SQL TRACING FOR A PARTICULAR SESSION.     12 Oracle On Compaq Server
    11 Direct IO In RH 3.0
    10 Very high CPU on OS side vs very high dbFileSeqRead on Oracle

side...

These threads accounted for 29.8% of all articles.

Top 10 Threads by Volume

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

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

  486.1 ( 17.6/468.5/431.1)     17  need help on statspack report, Parse
                                    CPU to Parse Elapsd %
  129.7 ( 50.7/ 56.2/ 38.8)     45  SQL Fun Challenge #2
   58.0 ( 20.9/ 34.6/ 11.3)     19  Troubleshooting ORA-01555 while using
                                    AUM
   47.0 ( 20.3/ 25.2/ 13.5)     19  Auditing: Trigger or Audit_Trail?
   43.0 ( 15.3/ 19.3/  7.1)     12  Oracle On Compaq Server
   32.8 ( 17.5/ 13.5/  5.4)     14  Oracle8i client-Oracle10g server
                                    question
   28.9 ( 10.0/ 18.9/  8.7)     10  Very high CPU on OS side vs very high
                                    dbFileSeqRead on Oracle side...
   26.7 ( 11.3/ 15.3/  6.2)      8  Connection problem ORA 12535 TNS
                                    Timeout
   26.3 ( 11.4/ 14.6/ 10.7)      9  searching for encrypted  fields in
                                    data columns
   26.3 ( 14.5/ 11.2/  4.4)     11  Direct IO In RH 3.0

These threads accounted for 50.7% of the total volume.

Top 10 Targets for Crossposts

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

       18  comp.databases.oracle.misc
        8  comp.databases.ms-sqlserver
        5  comp.databases.oracle
        4  comp.databases.ibm-db2
        4  alt.php.sql
        4  comp.lang.java.databases
        4  comp.databases.informix
        4  alt.comp.databases
        3  comp.databases.oracle.tools
        2  comp.databases

Received on Sun Mar 07 2004 - 16:05:49 CST

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