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 Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Sep 10 05:36:25 CDT 2024
|