当并发session在300左右时,用auto sga没有什么问题。但auto sga有一个bug。
Bug 5201883.
[@more@]Subject: Auto Sga: Not Free
Doc ID: 394026.1 Type: PROBLEM
Modified Date : 26-MAY-2008 Status: MODERATED
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 10.2.0.3
This problem can occur on any platform.
Symptoms
You recently upgraded to 10.2.0.2 or 10.2.0.3
Getting trace files with the following:
AUTO SGA: Not free 0xc0000002b5f80618, 1, 1, 1
AUTO SGA: Not free 0xc0000002b5f80618, 1, 1, 1
.
Cause
This is Bug 5201883
Rediscovery Information:
1. Database version is 10.2 with backport for unpublished bug 4687649 applied.
2. Generation of lots of MMAN trace files containing texts like,
"AUTO SGA: Not free 0x39cbe6e18, 1, 1, 1"
IMPACT
The trace files can safely be ignored but may cause space problems if not removed periodically from the background_dump_dest.
Bug affects 10.2.0.2 and 10.2.0.3.
Solution
To implement the solution, please execute the following steps:
1. Apply the patch for Bug 5201883.
2. If not available for your platform please submit a Service Request for a backport.
References
Bug 5201883 - UNEXPLAINED MMAN TRACE FILE
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/3345/viewspace-1024979/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/3345/viewspace-1024979/