Register Login

Why STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default)?

Updated May 19, 2018

Hello Experts,

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.


Comments

  • 10 Feb 2016 5:02 pm Abhijeet Mudgal Helpful Answer

    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) Snapshots
    Automatic Database Diagnostic Monitor (ADDM)
    All server-generated alerts
    Automatic SGA Memory Management
    Automatic optimizer statistics collection
    Object level statistics
    End to End Application Tracing (V$CLIENT_STATS)
    Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
    Service level statistics
    Buffer cache advisory
    MTTR advisory
    Shared pool sizing advisory
    Segment level statistics
    PGA Target advisory
    Timed statistics
    Monitoring of statistics

  • 10 Feb 2016 5:02 pm Jyoti Pandey Helpful Answer

    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.    


×