Hi,

My database is migrated from Oracle8i OPS to Oracle9i RAC (9.2.0.4)running under IBM-AIX 4.3.3 o/s with two instances. When the db was in 8i we have installed the statspack and we took reports too. After some time we have migrated to 9i RAC, can i run statspack and take reports now? Do i need to drop the old tablespace & statspack user PERFSTAT and delete all related views which got created in 8i OPS or rerun statpack utility once again in 9i RAC by creating a new tablespace to run statspack? Please clarify and help...

Ramesh