| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
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
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.netReceived on Thu Jan 02 2003 - 14:51:22 CST
<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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.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).
- text/plain attachment: ESPN_Disclaimer.txt
 |
 |