Results 1 to 2 of 2

Thread: Stmm

  1. #1
    Join Date
    Dec 2011
    Posts
    14

    Unanswered: Stmm

    HI All,

    when i look at db cfg

    my memory are automic and value next to that does that mean the current value or the max value that system can use,

    (DATABASE_MEMORY) = AUTOMATIC(30585097)
    Database memory threshold (DB_MEM_THRESH) = 10
    Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(1268544)
    Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(97)
    Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(131625)
    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(1316963)
    Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(263392)

    Regards
    Bond

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    They are current values

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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