Re:RE: Centralized StatsPack Repository
I also was informed during the iTAR process that they will support a centralized repository, but you'll have to wait till 10i for it. Heck I've haven't gotten a play instance of 9i up yet. 10i, maybe by 2010!!! I really don't want to wait that long!! Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 1/2/2003 12:51 PM 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- Sent: Thursday, January 02, 2003 3:41 PM To: Multiple recipients of list ORACLE-L 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_IDNOT 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_THNUMBER VERSION_COUNT_TH NUMBER ALL_INIT VARCHAR2(5) Steve Orr Bozeman, MT -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, January 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L 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 http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 TITLERE: Centralized StatsPack Repository/TITLE META content=MSHTML 5.50.4522.1800 name=GENERATOR/HEAD BODY DIVSPAN class=986215120-02012003FONT face=Courier New color=#ff size=2Steve,/FONT/SPAN/DIV DIVSPAN class=986215120-02012003FONT face=Courier New color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=986215120-02012003FONT face=Courier New color=#ff size=2I am leaning more towards Oracle Streams .../FONT/SPAN/DIV DIVSPAN class=986215120-02012003FONT face=Courier New color=#ff size=2/FONT/SPANnbsp;/DIV
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
Dick, I did some work on this some time ago, but never got around to fully implementing it. What it was supposed to do is take a day's worth of stats from each instance and store it in a table called DAILY_STATS. We take hourly stats on each instance, so the procedure takes the stats from today's midnight snapshot, subtracts the value of the stats form yesterdays midnight snapshot, and stores the deltas in DAILY_STATS. I figured that I might not want to save the values for all the stats, so I created a table called STATS_DICTIONARY which contains the stats which are to be saved - see stats_dictionary.sql for an example. Hopefully this will give you something of use to build upon. Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Friday, January 03, 2003 9:09 AM To: Multiple recipients of list ORACLE-L I also was informed during the iTAR process that they will support a centralized repository, but you'll have to wait till 10i for it. Heck I've haven't gotten a play instance of 9i up yet. 10i, maybe by 2010!!! I really don't want to wait that long!! Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 1/2/2003 12:51 PM 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- Sent: Thursday, January 02, 2003 3:41 PM To: Multiple recipients of list ORACLE-L 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_IDNOT 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_THNUMBER VERSION_COUNT_TH NUMBER ALL_INIT VARCHAR2(5) Steve Orr Bozeman, MT -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, January 02, 2003 11:34 AM To: Multiple recipients of list ORACLE-L 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 http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com 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
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 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