RE: Centralized StatsPack Repository

2003-01-03 Thread Jamadagni, Rajendra
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

2003-01-03 Thread Jared . Still
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

2003-01-03 Thread Babu Nagarajan
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

2003-01-03 Thread Kirsh, Gary
;
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

2003-01-02 Thread Jamadagni, Rajendra
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

2003-01-02 Thread Mogens Nørgaard
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

2003-01-02 Thread Orr, Steve
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

2003-01-02 Thread Jamadagni, Rajendra
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

2003-01-02 Thread DENNIS WILLIAMS
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

2003-01-02 Thread Jared . Still
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