Statistics for comp.databases.oracle.server

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Mon, 05 May 2003 00:38:05 GMT
Message-ID: <Nnita.736131$F1.95625@sccrnsc04>

Following is a summary of articles spanning a 7 day period, beginning at 28 Apr 2003 00:34:27 GMT and ending at 05 May 2003 00:03:43 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: 214
Articles: 657 (107 with cutlined signatures) Threads: 167

Volume generated: 1738.5 kb


     - headers:    719.1 kb (11,671 lines)

     - bodies:     999.3 kb (28,479 lines)

     - original:   537.1 kb (15,094 lines)

     - signatures: 19.5 kb (769 lines)


Original Content Rating: 0.538

Averages

Posts per poster: 3.1

     median: 1.0 post
     mode:   1 post - 112 posters
     s:      5.6 posts
Posts per thread: 3.9
     median: 3 posts
     mode:   1 post - 42 threads
     s:      11.8 posts
Message size: 2709.6 bytes


     - header:     1120.7 bytes (17.8 lines)

     - body:       1557.5 bytes (43.3 lines)

     - original:   837.2 bytes (23.0 lines)

     - signature:  30.4 bytes (1.2 lines)

Top 10 Threads by Number of Posts

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

    35 Are Oracle GUIs causing a decline in DBA salaries?     19 anyway to flush the db_buffer_cache?     18 Oracle Locking Up
    17 Is this a candidate for a stored outline?     15 Extent management local problem
    15 help with this simple proc?
    14 Boss is asking for 'root cause analysis'     13 suppress the output of SQL's by spooling     12 How to tune for "too many" users ?     11 System tablespace growing

These threads accounted for 25.7% of all articles.

Top 10 Threads by Volume

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

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

  114.4 (  1.9/112.5/111.6)      2  HELP - What is this OC4J thread dump
                                    telling me!
  100.6 ( 45.5/ 54.5/ 27.3)     35  Are Oracle GUIs causing a decline in
                                    DBA salaries?
   70.9 ( 20.2/ 50.4/  9.6)     18  Oracle Locking Up
   60.5 ( 21.8/ 38.5/ 10.0)     19  anyway to flush the db_buffer_cache?
   54.9 ( 17.0/ 37.7/  7.9)     15  help with this simple proc?
   50.2 ( 20.5/ 29.7/  8.1)     17  Is this a candidate for a stored
                                    outline?
   38.4 ( 16.1/ 20.1/  8.0)     14  Boss is asking for 'root cause
                                    analysis'
   38.2 ( 10.6/ 27.5/  8.0)      8  Forms 3.0 and Oracle 8i (8.1.7) (
                                    Invalid Rowid)
   35.0 ( 11.7/ 20.8/  9.9)     11  System tablespace growing
   32.2 ( 17.2/ 14.8/  6.5)     15  Extent management local problem

These threads accounted for 34.2% of the total volume.

Top 10 Threads by OCR (minimum of five posts)

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

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

0.888  ( 16.6/  18.7)     12  How to tune for "too many" users ?
0.886  (  2.8/   3.2)      5  PL/SQL
0.786  (  6.2/   7.9)      6  RMAN problems
0.692  (  4.3/   6.2)      8  How do you convert from Extent management
                               local to dictionary?
0.670  (  5.1/   7.6)      9  Table locked while rebuilding index
0.659  (  6.7/  10.2)      6  imp commit=n and rbs
0.648  (  3.7/   5.7)      6  Question for DBAs who use perl?
0.604  (  1.7/   2.8)      5  Named User Licensing
0.593  (  1.7/   2.9)      5  Location of the Sort extent pool
0.582  (  1.2/   2.1)      7  strange question

Top 10 Targets for Crossposts

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

       63  comp.databases.oracle.misc
       32  comp.databases.oracle.tools
        6  comp.databases.oracle.marketplace
        5  alt.os.linux.suse
        4  microsoft.public.dotnet.framework
        4  microsoft.public.dotnet.framework.adonet
        4  comp.databases.oracle
        4  comp.database.oracle
        1  comp.sys.sun.admin
        1  comp.unix.solaris

Received on Sun May 04 2003 - 19:38:05 CDT

Statistics for comp.databases.oracle.server - WE 5/04/2003