Oracle-L: RE: Centralized StatsPack Repository

From: Orr, Steve <sorr_at_rightnow.com>
Date: Thu, 02 Jan 2003 12:40:32 -0800
Message-ID: <F001.00526094.20030102124032@fatcity.com>

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

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Orr, Steve
INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------