Home » RDBMS Server » Server Administration » Strange alters in alert.log (Oracle 11.2.0.3 on RedHat 5.x)
Strange alters in alert.log [message #578209] Mon, 25 February 2013 12:03 Go to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Hi,

What can cause a lot of entries like this in the alert.log (3 or more per second)?
Fri Feb 22 21:06:51 2013
ALTER SYSTEM SET parallel_max_servers=1024 SCOPE=MEMORY;
Fri Feb 22 21:06:51 2013
ALTER SYSTEM SET parallel_max_servers=1024 SCOPE=MEMORY;
Fri Feb 22 21:06:51 2013
ALTER SYSTEM SET parallel_max_servers=1024 SCOPE=MEMORY;

Looks very suspiciously like a runaway script, but why the scope=MEMORY?
Alternatively, Oracle is tracing autotuning operations?

Anyone seen this before?

Best regards.
Frank
Re: Strange alters in alert.log [message #578423 is a reply to message #578209] Wed, 27 February 2013 21:45 Go to previous message
GirishSharma
Messages: 22
Registered: March 2010
Junior Member
May be below link give you some clue (but not sure though):
http://www.orafaq.com/forum/t/75289/2/

http://docs.oracle.com/cd/E18283_01/server.112/e16541/parallel005.htm#CIHHJFFC

My wild guess is that since default value is dependent upon CPU_COUNT, PARALLEL_THREADS_PER_CPU, and PGA_AGGREGATE_TARGET, so if you just play around these parameter(s), you may be near to find the reason about it.

Regards
Girish Sharma
Previous Topic: How to Alter Tablespace/s in oracle?
Next Topic: Where can i see all executed statements?
Goto Forum:
  


Current Time: Sun Dec 21 17:30:25 CST 2014

Total time taken to generate the page: 0.31719 seconds