Home » RDBMS Server » Server Utilities » ORA-01475 error
ORA-01475 error [message #71865] Wed, 22 January 2003 17:43 Go to next message
Glen
Messages: 7
Registered: October 2000
Junior Member
A customer of mine is getting this error: ORA-01475: must reparse cursor to change bind.

The only resolution that I can see out there involves increasing the shared pool size, which in my case, is already at 100 MB for a database that isn't that big to begin with...this seems like a band-aid kind of fix to me.

My customer is at 8.1.7.0.0 ... anyone know if this is one of those types of errors that is fixed in a newer version of 8i?
Re: ORA-01475 error [message #71867 is a reply to message #71865] Wed, 22 January 2003 18:57 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
or
you can pin those packages/procedures to SGA.
Previous Topic: Sql Script Help !!!!
Next Topic: increase performace of oracle server without upgrading hardware
Goto Forum:
  


Current Time: Wed May 15 19:19:18 CDT 2024