Re: Statspack consolidation
- From: Alex Gorbachev <gorbyx@xxxxxxxxx>
- To: daniel.hubler@xxxxxxxxxx
- Date: Sun, 1 May 2005 16:08:31 +0200
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@xxxxxxxxxx <daniel.hubler@xxxxxxxxxx>:
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
