Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 13 Jul 2003 23:09:27 GMT
Message-ID: <HElQa.49448$sY2.24728@rwcrnsc51.ops.asp.att.net>

Following is a summary of articles spanning a 7 day period, beginning at 06 Jul 2003 23:17:12 GMT and ending at 13 Jul 2003 19:04: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: 202
Articles: 525 (86 with cutlined signatures) Threads: 132

Volume generated: 1219.7 kb


     - headers:    562.6 kb (9,132 lines)

     - bodies:     637.2 kb (19,186 lines)

     - original:   340.0 kb (10,857 lines)

     - signatures: 19.4 kb (667 lines)


Original Content Rating: 0.534

Averages

Posts per poster: 2.6

     median: 1.0 post
     mode:   1 post - 112 posters
     s:      3.8 posts
Posts per thread: 4.0
     median: 3.0 posts
     mode:   1 post - 31 threads
     s:      3.7 posts
Message size: 2379.0 bytes


     - header:     1097.3 bytes (17.4 lines)

     - body:       1242.9 bytes (36.5 lines)

     - original:   663.1 bytes (20.7 lines)

     - signature:  37.8 bytes (1.3 lines)

Top 10 Threads by Number of Posts

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

    26 Any reasons why not to upgrade to 9i     21 data replication tool
    13 Trigger on v$sql catalog table
    13 What is a UDT?
    12 High Version count in V$SQLAREA
    10 CBO cost and avg_row_len
    10 Search for string in all tables in one schema

     9  how to sort numbers in varchar2
     9  Oracle 8i and AIX 5 compatibility issue
     9  How to select Dell based mighty server for Oracle 9i EE for Win
        XP?

These threads accounted for 25.1% of all articles.

Top 10 Threads by Volume

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

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

   52.6 ( 29.1/ 23.0/ 11.3)     26  Any reasons why not to upgrade to 9i
   46.2 ( 14.4/ 31.9/ 17.0)     12  High Version count in V$SQLAREA
   41.3 (  3.0/ 38.0/ 25.4)      3  Oracle BAckup Failed. Urgent Please
   39.5 ( 25.2/ 14.2/  6.3)     21  data replication tool
   32.2 ( 14.2/ 18.0/  5.6)     13  What is a UDT?
   26.2 (  9.2/ 16.8/  5.0)      8  Installation problem of Oracle 9iAS
                                    Infrastructure
   25.9 ( 11.3/ 14.2/  8.0)     10  CBO cost and avg_row_len
   24.4 ( 15.1/  9.3/  5.0)     13  Trigger on v$sql catalog table
   24.0 (  7.2/ 16.8/ 11.5)      7  How best to move oracle9 db and
                                    binaries between similiar unix
                                    servers?
   23.4 ( 11.3/ 11.7/  4.8)     10  Search for string in all tables in
                                    one schema

These threads accounted for 27.5% of the total volume.

Top 10 Targets for Crossposts

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

       21  comp.databases.oracle.misc
        8  comp.databases.oracle.tools
        7  comp.databases.oracle
        5  alt.sys.pc-clone.compaq
        5  alt.sys.pc-clone.compaq.servers
        5  alt.ftp-servers
        5  alt.2600.warez
        3  comp.lang.java.databases
        2  comp.unix.tru64
        2  comp.database.oracle

Received on Sun Jul 13 2003 - 18:09:27 CDT

Statistics for comp.databases.oracle.server - WE 07/13/2003