I have an Oracle 188.8.131.52 database that is experiencing extremely slow
response times in the past few days. I know that one of the tables
had as many as 3,000,000 rows, but over the past week some of the
information has been purged, so now there are about 2,200,000 rows;
other tables have also been drastically reduced in row count. Last
night, I updated statistics (hoping it might make a difference), but
unfortunately, we don't observe any real difference.
I have two questions:
1. The Optimizer_Mode parameter for Oracle is set to RULE. Does this
mean that the server does ...