Home » RDBMS Server » Server Administration » Analyze table
Analyze table [message #49706] Tue, 05 February 2002 14:37 Go to next message
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 #49749 is a reply to message #49706] Thu, 07 February 2002 11:09 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Are you sure nothing has changed in the init.ora file??
Re: Analyze table [message #49751 is a reply to message #49749] Thu, 07 February 2002 13:05 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Tablespace Problem
Next Topic: Re: Need Solaris Dumps & previous solved papers
Goto Forum:
  


Current Time: Fri Jul 05 10:23:11 CDT 2024