This is how we gather statistics on some of the schemas (9.2.0.6): DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA_NAME',NULL,FALSE,'FOR ALL INDEXED = COLUMNS SIZE 1',4,'DEFAULT',TRUE,NULL,NULL,'GATHER'); HTH, Sonja -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of zhu chao Sent: Thursday, May 05, 2005 1:41 PM To: shrekdba@xxxxxxxxx Cc: oracle-l Subject: Re: sanity check... You can export the statistics and import back after you import the = actual d=3D ata. While doing import, the ANALYZE=3D3DY should also do the analyze. On 5/5/05, bill thater <shrekdba@xxxxxxxxx> wrote: > solaris 9 > 9.2.0.6 >=3D20 > OK i have several development databases here. the production ones are > someplece else and they're not my concern yet. a lot of the > evelopment here consists of truncating and reloading tables in a > couple of schemas on the databases, adding data, importing data. most > of the schemas are static. this leads to developers showing up at my > cube and <whiney voice> "bill, the database is slow again.</whiney > voice>. most of this can be fixed by just gathering stats on those > schemas. >=3D20 > so what i'm looking for is pointers to TFM, white papers, best > pratices, your favorite method of gathering stats on just those > schemas so i can write a script to be chroned to run against them. >=3D20 > thanks. >=3D20 > --=3D3D20 > -- > Bill "Shrek" Thater ORACLE DBA =3D3D20 > shrekdba@xxxxxxxxx=3D3D20 > = ------------------------------------------------------------------------ > om mani padme hum > -- > //www.freelists.org/webpage/oracle-l >=3D20 --=3D20 Regards Zhu Chao www.cnoug.org -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l