Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    4

    Exclamation Unanswered: Self_tuning_mem on(inactive)

    This was a strange behavior I observed today the SELF_TUNING_MEM was ON
    but was inactive. So I check for other configuration parameters but all were set to automatic.
    DATABASE_MEMORY AUTOMATIC
    SORTHEAP AUTOMATIC
    SHEAPTHRES_SHR AUTOMATIC
    LOCKLIST AUTOMATIC
    MAXLOCKS AUTOMATIC
    PCKCACHESZ AUTOMATIC
    so all the above were automatic. Also for all the bufferpools NPAGES is -2.
    Not sure on as why the SELF_TUNING_MEM was ON
    but was inactive
    Can anybody answer this?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Is this a DPF system?

  3. #3
    Join Date
    Jul 2010
    Posts
    4
    This is a non-DPF but how does that affect. Any specific changes to check?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •