Why design new schema when you can use same AWR repository to store data for multiple database_id? For capacity planning, averages stored in Gridcontrol repository are not enough? Granted they don't have fine-grained details provided by AWR, but normal 15 minutes averages and daily averages are available and are very useful in a lot of cases. As for GridControl repository data, yes, I have played with it and I roll my own capacity report based on custom needs, we have db/host targets that are in few thousands. Raj On Sun, Oct 3, 2010 at 6:29 AM, LS Cheng <exriscer@xxxxxxxxx> wrote: > > > > The other option is all these 20 databases are monitoried by Grid Control > which stores 13 months data. But I have been looking Grid Control's data > model and doesnt seem very intuitive. Anyone's got experience with mining > Grid Control data? > > >