OraFAQ Forum: Server Administration » AUTO SGA: Not free Error in trace file (merged)

Home » RDBMS Server » Server Administration » AUTO SGA: Not free Error in trace file (merged) (Oracle 10g 10.2.0.3 on linux 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AUTO SGA: Not free Error in trace file (merged) [message #496610]

Tue, 01 March 2011 06:29

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

Hi,
Following are the lines in trace file prod_mman_6491.trc bdump directory.

Unix process pid: 6491, image: oracle@prod (MMAN)

*** 2010-04-26 06:00:10.554
*** SERVICE NAME:(SYS$BACKGROUND) 2010-04-26 06:00:10.545
*** SESSION ID:(498.1) 2010-04-26 06:00:10.545
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005458, 1, 1, 1
AUTO SGA: Not free 0x0xa000a788, 1, 1, 1
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005458, 1, 1, 1
AUTO SGA: Not free 0x0xa000a788, 1, 1, 1
AUTO SGA: Not free 0x0xa0010568, 1, 1, 1
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005458, 1, 1, 1
AUTO SGA: Not free 0x0xa000a788, 1, 1, 1
AUTO SGA: Not free 0x0xa0010568, 1, 1, 1
AUTO SGA: Not free 0x0xa0011568, 1, 1, 1
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005458, 1, 1, 1
AUTO SGA: Not free 0x0xa000a788, 1, 1, 1
AUTO SGA: Not free 0x0xa0010568, 1, 1, 1
AUTO SGA: Not free 0x0xa0011568, 1, 1, 1
AUTO SGA: Not free 0x0xa0012128, 1, 1, 1
AUTO SGA: Not free 0x0xa0005348, 1, 1, 1
AUTO SGA: Not free 0x0xa0005458, 1, 1, 1
AUTO SGA: Not free 0x0xa000a788, 1, 1, 1
AUTO SGA: Not free 0x0xa0010568, 1, 1, 1
AUTO SGA: Not free 0x0xa0011568, 1, 1, 1
AUTO SGA: Not free 0x0xa0012128, 1, 1, 1
AUTO SGA: Not free 0x0xa0017568, 1, 1, 1

Database is working fine, this trace file is created every night.

Today when i changed my SGA_TARGET to 2048 mb,from 2000 mb, file created previous night around 11:30 pm was over written by the trace file . My SGA_MAX_SIZE is 2048 mb.

My Database is working fine. Should i need to do anything

Report message to a moderator

Re: AUTO SGA: Not free error in trace file [message #496613 is a reply to message #496610]

Tue, 01 March 2011 06:33

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is a known bug in 10.2.0.3.
You can ignore it or better upgrade in 10.2.0.4 or 10.2.0.5.

Regards
Michel

Report message to a moderator

Re: AUTO SGA: Not free error in trace file [message #496616 is a reply to message #496613]

Tue, 01 March 2011 06:57

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

Hi,
If SGA_MAX_SIZE value is equal TO SGA_TARGET value then is it a normal thing or i need to reduce the size of of SGA_TARGET back to 2000 mb

[Updated on: Tue, 01 March 2011 07:03]

Report message to a moderator

Re: AUTO SGA: Not free error in trace file [message #496622 is a reply to message #496616]

Tue, 01 March 2011 08:32

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't understand the question and the relation with the previous one.
You have, at any time, SGA_TARGET <= SGA_MAX_SIZE

Regards
Michel

Report message to a moderator

Re: AUTO SGA: Not free error in trace file [message #496625 is a reply to message #496622]

Tue, 01 March 2011 08:50

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

As i described earlier when i changed SGA_TARGET FROM 2000 MB TO 2048 MB, the trace file with same error overwritten file of previous night.
That is why i am asking whether it has something to do with above.

[Updated on: Tue, 01 March 2011 08:51]

Report message to a moderator

Re: AUTO SGA: Not free error in trace file [message #496626 is a reply to message #496625]

Tue, 01 March 2011 08:55

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And what is not clear in my answer:
Quote:

You can ignore it

Regards
Michel

Report message to a moderator

Previous Topic:	Change Orace database Charater Set
Next Topic:	csm$errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 00:59:12 CST 2025