Re: Oracle 9i STATSPACK Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 28 Jul 2003 00:39:31 -0700
Message-ID: <a20d28ee.0307272339.c3e5fa3@posting.google.com>

Big Chuck <ccarson_at_echeeba.com> wrote in message news:<3F248C6A.6040301_at_echeeba.com>...
> Is it possible to use one database and STATSPACK to collect data from
> several databases. ie: Someone install statspack under several different
> schemas somehow?
>
> Seems to be a huge limitation to only allow one per database.
>
> Thanks,
> CC

Yes, you can store data from multiple databases in one statspack schema.
Yes, you'll need export/import to collect them No,having multiple statspack schema's per database doesn't make sense. Statspack collects database wide statistics.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Jul 28 2003 - 02:39:31 CDT