| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gmail.com]
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_at_gmail.com=20
------------------------------------------------------------------------
om mani padme hum
 |
 |