Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sun, 11 May 2003 16:27:14 GMT
Message-ID: <CRuva.846820$S_4.859637@rwcrnsc53>

Following is a summary of articles spanning a 7 day period, beginning at 04 May 2003 17:36:20 GMT and ending at 11 May 2003 15:59:32 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: 230
Articles: 667 (87 with cutlined signatures) Threads: 161

Volume generated: 1537.9 kb


     - headers:    721.3 kb (11,626 lines)

     - bodies:     795.8 kb (24,917 lines)

     - original:   425.4 kb (13,903 lines)

     - signatures: 20.1 kb (733 lines)


Original Content Rating: 0.535

Averages

Posts per poster: 2.9

     median: 1.0 post
     mode:   1 post - 118 posters
     s:      3.9 posts
Posts per thread: 4.1
     median: 3 posts
     mode:   1 post - 41 threads
     s:      4.0 posts
Message size: 2361.0 bytes


     - header:     1107.4 bytes (17.4 lines)

     - body:       1221.8 bytes (37.4 lines)

     - original:   653.1 bytes (20.8 lines)

     - signature:  30.8 bytes (1.1 lines)

Top 10 Threads by Number of Posts

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

    32 Australian trip.
    19 good sources for tuning info
    17 IBM Debunks Oracle's MultiVersion Read Consistency ?     15 VLDB Question
    12 difference between thread based and process based operating

        systems?
    12 Why my Temporary tablespace is always 99% full ?     11 Tuning Semaphores on Solaris
    11 SQL Works but PL/SQL hangs
    11 Anybody have experience of online reorg tools ?     11 ORA-3114: not connected to ORACLE on DB creation

These threads accounted for 22.6% of all articles.

Top 10 Threads by Volume

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

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

   71.8 ( 35.8/ 35.2/ 17.2)     32  Australian trip.
   49.7 ( 13.7/ 36.0/ 19.9)     11  ORA-3114: not connected to ORACLE  on
                                    DB creation
   43.9 ( 20.3/ 21.6/  9.6)     17  IBM Debunks Oracle's MultiVersion
                                    Read Consistency ?
   42.7 ( 21.3/ 21.1/  9.0)     19  good sources for tuning info
   36.7 ( 14.6/ 21.9/ 11.8)     12  difference between thread based and
                                    process based operating systems?
   36.4 ( 11.3/ 25.1/  5.7)     10  Please help tuning a query
   32.8 ( 16.8/ 14.9/  7.4)     15  VLDB Question
   29.1 (  7.3/ 21.5/  6.2)      6  Oracle 8i Install On Redhat 9
   27.8 ( 10.5/ 17.3/  6.4)      9  anyway to flush the db_buffer_cache?
   27.8 ( 12.8/ 14.8/  4.7)     11  SQL Works but PL/SQL hangs

These threads accounted for 25.9% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.926  ( 17.6/  19.0)      7  Full table scans
0.805  (  3.9/   4.8)     10  Full table scans
0.735  (  3.5/   4.8)      5  Can the listener forward connect request
                               to another server
0.716  (  7.8/  10.8)     11  Tuning Semaphores on Solaris
0.707  (  4.6/   6.5)      5  Examples of setup for 5TB Oracle DB?
0.680  (  3.7/   5.4)      5  High IO Waiting...
0.639  (  4.2/   6.5)      8  Dropping Online Log Files
0.624  (  4.3/   6.9)      8  how to auto commit in oracle?
0.597  (  6.2/  10.4)      5  Peoplesoft: Prolific Use of EXISTS and
                               HASH hints
0.589  (  4.3/   7.2)      6  wget --- downloading from oracle site!

Top 10 Targets for Crossposts

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

       28  comp.databases.oracle.misc
       25  comp.databases.oracle.tools
        9  comp.databases.olap
        8  comp.databases.oracle
        6  comp.databases.theory
        6  comp.database.oracle
        6  comp.os.linux.development.apps
        5  comp.os.linux.networking
        4  alt.solaris.x86
        4  comp.unix.solaris

Received on Sun May 11 2003 - 11:27:14 CDT

Statistics for comp.databases.oracle.server - WE 05/11/2003