Re: Statistics for comp.databases.oracle.server - WE 11/22/2003

Hi Mark:

Any reason why Niall gets two separate entries?

And whatever happened to top posts by original content??

Regards
HJR "Mark Townsend" <markbtownsend_at_attbi.com> wrote in message news:WFbwb.287193$Tr4.896223_at_attbi_s03...
> Following is a summary of articles spanning a 7 day period,
> beginning at 16 Nov 2003 23:58:22 GMT and ending at
> 23 Nov 2003 23:31:22 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: 173
> Articles: 524 (107 with cutlined signatures)
> Threads: 113
> Volume generated: 1287.3 kb
> - headers: 573.3 kb (9,409 lines)
> - bodies: 685.5 kb (21,754 lines)
> - original: 310.4 kb (10,414 lines)
> - signatures: 28.0 kb (910 lines)
>
> Original Content Rating: 0.453
>
> Averages
> ========
>
> Posts per poster: 3.0
> median: 1 post
> mode: 1 post - 88 posters
> s: 4.4 posts
> Posts per thread: 4.6
> median: 3 posts
> mode: 1 post - 24 threads
> s: 5.1 posts
> Message size: 2515.6 bytes
> - header: 1120.3 bytes (18.0 lines)
> - body: 1339.6 bytes (41.5 lines)
> - original: 606.6 bytes (19.9 lines)
> - signature: 54.7 bytes (1.7 lines)
>
> Top 10 Posters by Number of Posts
> =================================
>
> (kb) (kb) (kb) (kb)
> Posts Volume ( hdr/ body/ orig) Address
> ----- -------------------------- -------
>
> 40 97.0 ( 51.1/ 37.6/ 10.9) Daniel Morgan
> 20 69.2 ( 24.4/ 44.8/ 25.4) Howard J. Rogers
> 19 38.8 ( 19.5/ 19.3/ 7.9) Sybrand Bakker
> 17 55.6 ( 22.7/ 32.5/ 3.3) fbortel
> 15 40.6 ( 15.5/ 25.1/ 8.2) Joel Garry
> 11 41.0 ( 15.9/ 25.0/ 24.8) mcstock
> 11 28.9 ( 13.8/ 12.9/ 6.8) Niall Litchfield
> 10 26.3 ( 9.7/ 16.6/ 5.7) Paul Drake
> 10 31.1 ( 13.2/ 17.8/ 6.9) Niall Litchfield
> 10 25.8 ( 12.2/ 13.6/ 7.8) Richard Foote
>
> These posters accounted for 31.1% of all articles.
>
> Top 10 Posters by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Address
> -------------------------- ----- -------
>
> 97.0 ( 51.1/ 37.6/ 10.9) 40 Daniel Morgan
> 69.2 ( 24.4/ 44.8/ 25.4) 20 Howard J. Rogers
> 55.6 ( 22.7/ 32.5/ 3.3) 17 fbortel
> 41.0 ( 15.9/ 25.0/ 24.8) 11 mcstock
> 40.6 ( 15.5/ 25.1/ 8.2) 15 Joel Garry
> 38.8 ( 19.5/ 19.3/ 7.9) 19 Sybrand Bakker
> 31.1 ( 13.2/ 17.8/ 6.9) 10 Niall Litchfield
> 28.9 ( 13.8/ 12.9/ 6.8) 11 Niall Litchfield
> 26.9 ( 8.7/ 18.1/ 11.8) 8 Jonathan Lewis
> 26.3 ( 9.7/ 16.6/ 5.7) 10 Paul Drake
>
> These posters accounted for 35.4% of the total volume.
>
> Top 10 Threads by Number of Posts
> =================================
>
> Posts Subject
> ----- -------
>
> 40 db cache size in oracle 9ir2
> 21 Another Oracle "Myth"?
> 20 Myth revisited ...
> 17 DBMS_REPAIR, 8.1.7
> 16 Patch Set for 8.1.7.4 failed to upgrade
> 14 "Nologging"-option tablespace and tables
> 14 Index not used therefore rebuild the thing ...
> 12 -- insert instead of an update
> 12 Synchronizing 2 tables in same database -how ?
> 11 dbms_stats set_table_stats, set_index_stats and set_columns_stats
>
> These threads accounted for 33.8% of all articles.
>
> Top 10 Threads by Volume
> ========================
>
> (kb) (kb) (kb) (kb)
> Volume ( hdr/ body/ orig) Posts Subject
> -------------------------- ----- -------
>
> 105.0 ( 53.3/ 49.9/ 27.0) 40 db cache size in oracle 9ir2
> 56.8 ( 17.2/ 39.3/ 5.7) 16 Patch Set for 8.1.7.4 failed to
> upgrade
> 53.3 ( 20.9/ 31.1/ 16.6) 20 Myth revisited ...
> 50.3 ( 22.2/ 27.4/ 7.8) 17 DBMS_REPAIR, 8.1.7
> 49.8 ( 22.9/ 25.5/ 14.9) 21 Another Oracle "Myth"?
> 44.6 ( 17.4/ 26.7/ 8.7) 14 "Nologging"-option tablespace and
> tables
> 42.2 ( 12.0/ 29.0/ 16.3) 10 How to test to VARCHAR2's for
> equality EFFICIENTLY ?
> 39.6 ( 16.8/ 21.9/ 7.9) 14 Index not used therefore rebuild the
> thing ...
> 36.6 ( 12.8/ 23.7/ 7.9) 12 -- insert instead of an update
> 28.9 ( 11.2/ 17.6/ 7.4) 11 dbms_stats set_table_stats,
> set_index_stats and set_columns_stats
>
> These threads accounted for 39.4% of the total volume.
>
> Top 10 Targets for Crossposts
> =============================
>
> Articles Newsgroup
> -------- ---------
>
> 7 comp.databases.oracle.misc
> 6 alt.os.linux
> 6 comp.os.linux.setup
> 6 comp.os.linux.misc
> 6 alt.os.linux.suse
> 3 comp.unix.solaris
> 2 comp.databases.oracle.marketplace
>
Received on Sun Nov 23 2003 - 17:57:16 CST