RE: sanity check...

Hi Bill,

All of our scripts that do this sort of thing (truncate and load) analyze
the table immediately after running the data load.  Since it happens
automatically no one forgets about it.  This was implemented a number of
years ago to avoid just the issues you're talking about :).  It's one of our
scripting standards now.



Jay Miller
Sr. Oracle DBA


-----Original Message-----
From: bill thater [mailto:shrekdba@xxxxxxxxx] 
Sent: Wednesday, May 04, 2005 5:40 PM
To: oracle-l
Subject: sanity check...

solaris 9
9.2.0.6

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.

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.

thanks.

--=20
--
Bill "Shrek" Thater     ORACLE DBA    =20
       shrekdba@xxxxxxxxx=20
------------------------------------------------------------------------
om mani padme hum
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: