Home » RDBMS Server » Server Administration » AUTO SGA: Not free Error in trace file (merged) (Oracle 10g 10.2.0.3 on linux 64 bit)
AUTO SGA: Not free Error in trace file (merged) [message #496610] Tue, 01 March 2011 06:29 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 10:18:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.