RE: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository Hmmm... FAGC ?? Jared, I am stumped ... I can't put these 2 2 together. I was planning on a new instance called dbmon. One schema for each production database instance. Statspack will be installed for each schema and other monitoring scripts that we use internally. I am thinking of best ways to propogate datasets from individual databases to this central db. Could you explain more about (your idea on) how FAGC would be useful?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 8:03 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Subject: RE: Centralized StatsPack Repository Importance: High Have you considered FGAC? ( fine grained access control ) I haven't tried it, but it seems like a good candidate for centralizing stats pack data with as little code as possible. Jared This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Centralized StatsPack Repository
Sure. For every instance that you want to include in the repository, create an account name that matches the instance. Setup FGAC so that each sees only it's own data. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/03/2003 07:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Centralized StatsPack Repository Hmmm... FAGC ?? Jared, I am stumped ... I can't put these 2 2 together. I was planning on a new instance called dbmon. One schema for each production database instance. Statspack will be installed for each schema and other monitoring scripts that we use internally. I am thinking of best ways to propogate datasets from individual databases to this central db. Could you explain more about (your idea on) how FAGC would be useful?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, January 02, 2003 8:03 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Importance: High Have you considered FGAC? ( fine grained access control ) I haven't tried it, but it seems like a good candidate for centralizing stats pack data with as little code as possible. Jared This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository Raj I did this sometime back but later on somehow this went on to the backburner.. (I also had half-developed XL based interface to the central statspack data) In the central repository create the set of tables that statspack uses to store data under user "central". Create individual schema's with different instance names (that you want monitored). Under each of the schemas 1) create a db link with a dba user to the database that this schema monitors 2) create private synonyms for all of the v$, dba* views that statspack queries usingdb links created above (create synonym v$session for sys.v$session@target_db) 3) create private synonyms for all of the statspack tables to point to the "central" schema Now when you schedule statspack.snap it will read from the target db and insert data into the "central" user... Babu - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, January 03, 2003 10:08 AM Subject: RE: Centralized StatsPack Repository Hmmm... FAGC ?? Jared, I am stumped ... I can't put these 2 2 together. I was planning on a new instance called "dbmon". One schema for each production database instance. Statspack will be installed for each schema and other monitoring scripts that we use internally. I am thinking of best ways to propogate datasets from individual databases to this central db. Could you explain more about (your idea on) how FAGC would be useful?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 8:03 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Subject: RE: Centralized StatsPack Repository Importance: High Have you considered FGAC? ( fine grained access control ) I haven't tried it, but it seems like a good candidate for centralizing stats pack data with as little code as possible. Jared
RE: RE: Centralized StatsPack Repository
; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; VARCHAR2(160)/FONT BRFONT size=2nbsp;EXECUTIONS_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bs p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bsp; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs p;n bsp;nbsp; NUMBER/FONT BRFONT size=2nbsp;PARSE_CALLS_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nb sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb sp; nbsp; NUMBER/FONT BRFONT size=2nbsp;DISK_READS_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bs p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bsp; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs p;n bsp;nbsp; NUMBER/FONT BRFONT size=2nbsp;BUFFER_GETS_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nb sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb sp; nbsp; NUMBER/FONT BRFONT size=2nbsp;SHARABLE_MEM_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; n bsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbs p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n bsp; NUMBER/FONT BRFONT size=2nbsp;VERSION_COUNT_THnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nb sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; NUMBER/FONT BRFONT size=2nbsp;ALL_INITnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nb sp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nb sp; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; VARCHAR2(5)/FONT /PBR PFONT size=2Steve Orr/FONT BRFONT size=2Bozeman, MT/FONT /PBRBR PFONT size=2-Original Message-/FONT BRFONT size=2From: Jamadagni, Rajendra [A href=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED] / A]/FONT BRFONT size=2Sent: Thursday, January 02, 2003 11:34 AM/FONT BRFONT size=2To: Multiple recipients of list ORACLE-L/FONT BRFONT size=2Subject: RE: Centralized StatsPack Repository/FONT /PBR PFONT size=2I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db./FONT/P PFONT size=2Raj /FONTBRFONT size=2__ /FONTBRFONT size=2Rajendra Jamadagninbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nb sp;nbsp; MIS, ESPN Inc. /FONTBRFONT size=2Rajendra dot Jamadagni at ESPN dot com /FONTBRFONT size=2Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. /FONTBRFONT size=2QOTD: Any clod can have facts, but having an opinion is an art! /FONT/PBR PFONT size=2-Original Message- /FONTBRFONT size=2From: [EMAIL PROTECTED] [A href=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A] /FONTBRFONT size=2Sent: Thursday, January 02, 2003 1:14 PM /FONTBRFONT size=2To: Multiple recipients of list ORACLE-L /FONTBRFONT size=2Subject: Centralized StatsPack Repository /FONT/PBR PFONT size=2To ALL, /FONTBRFONT size=2nbsp;nbsp;nbsp; We'd like to establish a centralized stats pack repository, but OTS is /FONTBRFONT size=2telling us that it's NOT doable for a couple of reasons.nbsp; As you can guess I /FONTBRFONT size=2don't believe them and am looking around to see if anyone else has done this /FONTBRFONT size=2before I break out the power tools and start building something on my own. /FONTBRFONT size=2Dick Goulet /FONTBRFONT size=2-- /FONTBRFONT size=2Please see the official ORACLE-L FAQ: A target=_blank href=http://www.orafaq.net;http://www.orafaq.net/A /FONTBRFONT size=2-- /FONTBRFONT size=2Author: /FONTBRFONT size=2nbsp; INET: [EMAIL PROTECTED] /FONTBRFONT size=2Fat City Network Servicesnbsp;nbsp;nbsp; -- 858-538-5051 A target=_blank href=http://www.fatcity.com;http://www.fatcity.com/A /FONTBRFONT size=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Mailing list and web hosting services /FONTBRFONT size=2- /FONTBRFONT size=2To REMOVE yourself from this mailing list, send an E-Mail message /FONTBRFONT size=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in /FONTBRFONT size=2the message BODY, include a line containing: UNSUB ORACLE-L /FONTBRFONT size=2(or the name of mailing list you want to be removed from).nbsp; You may /FONTBRFONT size=2also send the HELP command for other information (like subscribing). /FONT/P/BLOCKQUOTE/BODY/HTML stats_dictionary.sql Description: Binary data stats_summary.sql Description: Binary data
RE: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: Centralized StatsPack Repository To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Centralized StatsPack Repository
I beleive a guy named Anjo with a site called OraPerf has a very centralized statspack repository :-))). Mogens [EMAIL PROTECTED] wrote: To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository An Oracle emp told me they plan to support a centralized statspack repository but it's not supported yet. In the stats$snapshot table the snap_id, dbid, and instance_number columns should be unique. The trick is automagically populating the mother of all statspack repositories with a maintenance-free routine. Replication? I've modified some of the statspack tables and it still works. You'll need to study the ddl for the statspack objects of course. So if you have a repository of 1/2 dozen databases is it a statspack sixpack? SQLdesc stats$snapshot Name Null? Type - SNAP_ID NOT NULL NUMBER(6) DBID NOT NULL NUMBER INSTANCE_NUMBER NOT NULL NUMBER SNAP_TIME NOT NULL DATE STARTUP_TIME NOT NULL DATE SESSION_ID NOT NULL NUMBER SERIAL# NUMBER SNAP_LEVEL NUMBER UCOMMENT VARCHAR2(160) EXECUTIONS_TH NUMBER PARSE_CALLS_TH NUMBER DISK_READS_TH NUMBER BUFFER_GETS_TH NUMBER SHARABLE_MEM_TH NUMBER VERSION_COUNT_TH NUMBER ALL_INIT VARCHAR2(5) Steve Orr Bozeman, MT -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: Centralized StatsPack Repository I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: Centralized StatsPack Repository To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository Steve, I am leaning more towards Oracle Streams ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Centralized StatsPack Repository An Oracle emp told me they plan to support a centralized statspack repository but it's not supported yet. In the stats$snapshot table the snap_id, dbid, and instance_number columns should be unique. The trick is automagically populating the mother of all statspack repositories with a maintenance-free routine. Replication? I've modified some of the statspack tables and it still works. You'll need to study the ddl for the statspack objects of course. So if you have a repository of 1/2 dozen databases is it a statspack sixpack? SQLdesc stats$snapshot Name Null? Type - SNAP_ID NOT NULL NUMBER(6) DBID NOT NULL NUMBER INSTANCE_NUMBER NOT NULL NUMBER SNAP_TIME NOT NULL DATE STARTUP_TIME NOT NULL DATE SESSION_ID NOT NULL NUMBER SERIAL# NUMBER SNAP_LEVEL NUMBER UCOMMENT VARCHAR2(160) EXECUTIONS_TH NUMBER PARSE_CALLS_TH NUMBER DISK_READS_TH NUMBER BUFFER_GETS_TH NUMBER SHARABLE_MEM_TH NUMBER VERSION_COUNT_TH NUMBER ALL_INIT VARCHAR2(5) Steve Orr Bozeman, MT -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: Centralized StatsPack Repository I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: Centralized StatsPack Repository To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Centralized StatsPack Repository
Dick - One resource you may want to review is Don Burleson's Oracle High-Performance Tuning with STATSPACK. Throughout the book he develops a philosophy of how you can use regular STATSPACK snapshots and a repository for a comprehensive proactive tuning/capacity planning facility. He may have a few ideas you haven't considered that might make a difference in how you build your repository. On the other hand, you may want to think really carefully about what you hope to achieve before you start shipping STATSPACK records around your network. I could see where it could be really easy to get excited about the big picture and spend all your resources building a great edifice, only to find it doesn't give the benefits you hoped for. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 02, 2003 12:14 PM To: Multiple recipients of list ORACLE-L To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Centralized StatsPack Repository
Have you considered FGAC? ( fine grained access control ) I haven't tried it, but it seems like a good candidate for centralizing stats pack data with as little code as possible. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2003 10:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Centralized StatsPack Repository I am currently working on a design ... basically it is simple to set-up, but the problem I am facing is how to automatically move dataset for one snapshot from prod db to the central db. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, January 02, 2003 1:14 PM To: Multiple recipients of list ORACLE-L To ALL, We'd like to establish a centralized stats pack repository, but OTS is telling us that it's NOT doable for a couple of reasons. As you can guess I don't believe them and am looking around to see if anyone else has done this before I break out the power tools and start building something on my own. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1