ot 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 pla
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
ase 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
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
ACLE-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
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 i
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 f
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
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 m
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
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
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 somethi
12 matches
Mail list logo
