According to oracle docs The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function. Why?
Please provide some reason.
Thanks in advance.
If you set it to basic, oracle will not gather stats reqired for "shared memory management to function"
Here are setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:
Automatic Workload Repository (AWR) SnapshotsAutomatic Database Diagnostic Monitor (ADDM)All server-generated alertsAutomatic SGA Memory ManagementAutomatic optimizer statistics collectionObject level statisticsEnd to End Application Tracing (V$CLIENT_STATS)Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)Service level statisticsBuffer cache advisoryMTTR advisoryShared pool sizing advisorySegment level statisticsPGA Target advisoryTimed statisticsMonitoring of statistics
ASMM uses SGA memory broker that is implemented by 2 background process. MMON and MMAN .MMON collects statistics and memory advisory data in memory and MMAN uses this information to coordinates the sizing of memory components.So setting the statistics_level to basic will not generate statistics which will be decesion making for MMAN to coordinates the sizes of different component.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.