Re: Statspack consolidation

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sun, 1 May 2005 16:08:31 +0200
Message-ID: <c2213f68050501070837d14fdc@mail.gmail.com>

We have Statspack repository built this way for about 15-20 databases. However, we have a separate schema for each database - it's easier to manage.
In addition, we have home-made web interface that allow many kind of reports to be run from web browser in addition to standard reports. One of advantages is that we can provide access to the reports to someone (like developers) without compromizing poduction DBs.

2005/4/29, daniel.hubler_at_aurora.org <daniel.hubler_at_aurora.org>:
> We are contemplating creating a single Statpack database, on one
> server/instance,
> and pushing all of our Statspack data to it. This would probably include
> data from 7-8 instances.
> We are guessing that we are not the first to consider this.
>=20
> Does anyone have any guidelines/comments/horror stories/direction to giv=
e
> on this idea?

>=20

> Any thoughts appreciated!

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Best regards,
Alex Gorbachev

--
http://www.freelists.org/webpage/oracle-l

Received on Sun May 01 2005 - 10:12:52 CDT