Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statspack consolidation
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
>=20
--=20
Best regards,
Alex Gorbachev
-- http://www.freelists.org/webpage/oracle-lReceived on Sun May 01 2005 - 10:12:52 CDT
![]() |
![]() |