Analyze table [message #49706] |
Tue, 05 February 2002 14:37 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
After converting our database version from 8.1.6 to 8.1.6.3.2 we are facing performance issues on anaising tables. It is increased 10 times & nothing is effected expect this. Does anybody have any clue how to check where is the problem.
Regards
Suresh
|
|
|
|
Re: Analyze table [message #49751 is a reply to message #49749] |
Thu, 07 February 2002 13:05 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
I don't think any of the parameters got changed. We have the same problem across the development & production instances with this release. Do you know what are the parameters will impact it.
Thanks
Suresh
|
|
|
Re: Analyze table [message #49776 is a reply to message #49749] |
Fri, 08 February 2002 08:00 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I guess it's best to search metalink.oracle.com for any known issues. Also, 8.1.7.3 is already out, so why not upgrade to that?? Seems like it will be worth it if there is a known issue.
|
|
|