Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Centralized StatsPack Repository

Re:RE: Centralized StatsPack Repository

From: <dgoulet_at_vicr.com>
Date: Fri, 03 Jan 2003 06:08:43 -0800
Message-ID: <F001.00526870.20030103060843@fatcity.com> 






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" <Rajendra.Jamadagni_at_espn.com>
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? 





SQL>desc 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----- 


<mailto:Rajendra.Jamadagni_at_espn.com> ] 



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: dgoulet_at_vicr.com 
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: ListGuru_at_fatcity.com (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">

<HTML><HEAD>

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<TITLE>RE: Centralized StatsPack Repository</TITLE>




<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>

<BODY>

<DIV><SPAN class=986215120-02012003><FONT face="Courier New" color=#0000ff 

size=2>Steve,</FONT></SPAN></DIV>


<DIV><SPAN class=986215120-02012003><FONT face="Courier New" color=#0000ff 

size=2></FONT></SPAN>&nbsp;</DIV>


<DIV><SPAN class=986215120-02012003><FONT face="Courier New" color=#0000ff 

size=2>I am leaning more towards Oracle Streams ...</FONT></SPAN></DIV>


<DIV><SPAN class=986215120-02012003><FONT face="Courier New" color=#0000ff 

size=2></FONT></SPAN>&nbsp;</DIV>


<DIV><SPAN class=986215120-02012003><FONT face="Courier New" color=#0000ff 

size=2>Raj</FONT></SPAN></DIV>


<DIV><SPAN class=986215120-02012003></SPAN><FONT face="Courier New" 

size=2>______________________________________________________</FONT></DIV>


<P align=left><FONT face="Courier New" size=2>Rajendra 

Jamadagni&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MIS, ESPN Inc.</FONT></P>


<P align=left><FONT face="Courier New" size=2>Rajendra dot Jamadagni at ESPN dot


com</FONT></P>


<P align=left><FONT face="Courier New" size=2>Any opinion expressed here is 

personal and doesn't reflect that of ESPN Inc. </FONT></P>


<P align=left><FONT face="Courier New" size=2>QOTD: Any clod can have facts, but


having an</FONT> <FONT face="Courier New" size=2>opinion is an</FONT> <FONT 
face="Courier New" size=2>art!</FONT></P>


<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">

  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Orr, Steve 
  [mailto:sorr_at_rightnow.com]<BR><B>Sent:</B> Thursday, January 02, 2003 3:41 
  PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: 
  Centralized StatsPack Repository<BR><BR></FONT></DIV>
  <P><FONT size=2>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.</FONT></P>
  <P><FONT size=2>So if you have a repository of 1/2 dozen databases is it a 
  statspack sixpack?</FONT> </P><BR><BR>
  <P><FONT size=2>SQL&gt;desc stats$snapshot</FONT> <BR><FONT 
  size=2>&nbsp;Name&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
; 
  Null?&nbsp;&nbsp;&nbsp; Type</FONT> <BR><FONT 
  size=2>&nbsp;----------------------------------------- -------- 
  ----------------------------</FONT> <BR><FONT 
  size=2>&nbsp;SNAP_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  NOT NULL NUMBER(6)</FONT> <BR><FONT 
  size=2>&nbsp;DBID&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
; 
  NOT NULL NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;INSTANCE_NUMBER&nbsp;&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; 
  NOT NULL NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;SNAP_TIME&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  NOT NULL DATE</FONT> <BR><FONT 
  size=2>&nbsp;STARTUP_TIME&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;&nbsp;&nbsp;&nbsp;&nbsp; 
  NOT NULL DATE</FONT> <BR><FONT 
  size=2>&nbsp;SESSION_ID&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;&nbsp;&nbsp; 
  NOT NULL NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;SERIAL#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&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;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;SNAP_LEVEL&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;UCOMMENT&nbsp;&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;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  VARCHAR2(160)</FONT> <BR><FONT 
  size=2>&nbsp;EXECUTIONS_TH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&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;&nbsp;&n
bsp;&nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;PARSE_CALLS_TH&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;&nbsp;&
nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;DISK_READS_TH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs
p;&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;&nbsp;&n
bsp;&nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;BUFFER_GETS_TH&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;&nbsp;&
nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;SHARABLE_MEM_TH&nbsp;&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;&nbsp;

  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;VERSION_COUNT_TH&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  NUMBER</FONT> <BR><FONT 
  size=2>&nbsp;ALL_INIT&nbsp;&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;&nbsp;&
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  VARCHAR2(5)</FONT> </P><BR>
  <P><FONT size=2>Steve Orr</FONT> <BR><FONT size=2>Bozeman, MT</FONT> 
  </P><BR><BR>
  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: 
  Jamadagni, Rajendra [<A 
  href="mailto:Rajendra.Jamadagni_at_espn.com">mailto:Rajendra.Jamadagni_at_espn.com</
A>]</FONT> 
  <BR><FONT size=2>Sent: Thursday, January 02, 2003 11:34 AM</FONT> <BR><FONT 
  size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT 
  size=2>Subject: RE: Centralized StatsPack Repository</FONT> </P><BR>
  <P><FONT size=2>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.</FONT></P>
  <P><FONT size=2>Raj </FONT><BR><FONT 
  size=2>______________________________________________________ </FONT><BR><FONT

  size=2>Rajendra 
  Jamadagni&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
sp;&nbsp; 
  MIS, ESPN Inc. </FONT><BR><FONT size=2>Rajendra dot Jamadagni at ESPN dot com 
  </FONT><BR><FONT size=2>Any opinion expressed here is personal and doesn't 
  reflect that of ESPN Inc. </FONT><BR><FONT size=2>QOTD: Any clod can have 
  facts, but having an opinion is an art! </FONT></P><BR>
  <P><FONT size=2>-----Original Message----- </FONT><BR><FONT size=2>From: 
  dgoulet_at_vicr.com [<A 
  href="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>] </FONT><BR><FONT 
  size=2>Sent: Thursday, January 02, 2003 1:14 PM </FONT><BR><FONT size=2>To: 
  Multiple recipients of list ORACLE-L </FONT><BR><FONT size=2>Subject: 
  Centralized StatsPack Repository </FONT></P><BR>
  <P><FONT size=2>To ALL, </FONT><BR><FONT size=2>&nbsp;&nbsp;&nbsp; We'd like 
  to establish a centralized stats pack repository, but OTS is </FONT><BR><FONT 
  size=2>telling us that it's NOT doable for a couple of reasons.&nbsp; As you 
  can guess I </FONT><BR><FONT size=2>don't believe them and am looking around 
  to see if anyone else has done this </FONT><BR><FONT size=2>before I break out

  the power tools and start building something on my own. </FONT><BR><FONT 
  size=2>Dick Goulet </FONT><BR><FONT size=2>-- </FONT><BR><FONT size=2>Please 
  see the official ORACLE-L FAQ: <A target=_blank 
  href="http://www.orafaq.net">http://www.orafaq.net</A> </FONT><BR><FONT 
  size=2>-- </FONT><BR><FONT size=2>Author: </FONT><BR><FONT size=2>&nbsp; INET:

  dgoulet_at_vicr.com </FONT><BR><FONT size=2>Fat City Network 
  Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A target=_blank 
  href="http://www.fatcity.com">http://www.fatcity.com</A> </FONT><BR><FONT 
  size=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- 
  Mailing list and web hosting services </FONT><BR><FONT 
  size=2>--------------------------------------------------------------------- 
  </FONT><BR><FONT size=2>To REMOVE yourself from this mailing list, send an 
  E-Mail message </FONT><BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT 
  spelling of 'ListGuru') and in </FONT><BR><FONT size=2>the message BODY, 
  include a line containing: UNSUB ORACLE-L </FONT><BR><FONT size=2>(or the name

  of mailing list you want to be removed from).&nbsp; You may </FONT><BR><FONT 
  size=2>also send the HELP command for other information (like subscribing). 
  </FONT></P></BLOCKQUOTE></BODY></HTML>

 




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).









Received on Fri Jan 03 2003 - 08:08:43 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US