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