Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help with Analyze!!
I wrote a script to delete statistics, then do an analyze compute statistics on all of the tables in a schema. The anaylze failed on one table because the temp tablepace filled up.
Performance is now so dismal the application is almost unusable, should I delete all of the stats from the analyze? I have to see if there is room to increase the temp tablepace so the analyze will run on the one table it failed on.
thanks in advance Received on Thu Apr 05 2001 - 11:05:20 CDT