Home » RDBMS Server » Server Administration » Too many parse error with error-12850 (Oracle, 12.1.0.2, Windows)
Too many parse error with error-12850 [message #684634] Thu, 15 July 2021 15:11 Go to next message
patdev
Messages: 73
Registered: August 2008
Member
hello all,

I am baffled at the moment and cannot find solution.

Often i see message in the alert log as bellow:

WARNING: too many parse errors, count=555 SQL hash=0x93a63936
PARSE ERROR: ospid=4504, error=12850 for statement:
/* query name*/

for error=12850 if it is related to RAC then the server i have is not RAC enabled. so please guide.

thanks
Re: Too many parse error with error-12850 [message #684635 is a reply to message #684634] Fri, 16 July 2021 00:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-12850: Could not allocate slaves on all specified instances: %s needed, %s allocated
 *Cause: When executing a query on a gv$ fixed view, one or more
         instances failed to allocate a slave to process query.
 *Action:Check trace output for instances on which slaves failed to start.
         GV$ query can only proceed if slaves can be allocated on all
         instances.
What was running?

Re: Too many parse error with error-12850 [message #684636 is a reply to message #684635] Fri, 16 July 2021 07:42 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
Hello,

thank you for the reply, there was a big query was running which has many aggregation running as well. I would appreciate if anyone can tell me how to find slave process because the instance is standalone NOT RAC enabled instance. also, there was no trace file generated for ORA-12850 as well

i have set these parameter as well but no luck

SGA_MAX = 24GB

SGA_Target = 22GB

pga_aggreagate limit = 8GB

pga_aggreagate target = 5gb
Re: Too many parse error with error-12850 [message #684637 is a reply to message #684636] Fri, 16 July 2021 07:58 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

 *Action:Check trace output for instances on which slaves failed to start.
         GV$ query can only proceed if slaves can be allocated on all
         instances.
Previous Topic: User process details (merged)
Next Topic: Unified Auditing Trail to find grants of privileges on an object
Goto Forum:
  


Current Time: Thu Mar 28 03:51:40 CDT 2024