• [bbk5131] 第47集 第五章 管理内存 02


    shared server模式下,UGA放在SGA的哪个位置?如果配置了LARGE POOL,UGA就会放在LARGE POOL中;否则如果没有配置,那么就存放在SHARED POOL当中.

    oracle 11g以后,可以将sql,pl/sql的执行结果存放在result pool中.

    Shared Pool

    Contents:

    • Library cache:Command text,parsed code,and execution plan
    • Data dictionary cache:Definitions for tables,columns,and privileges from the data dictionary tables
    • Result cache:Results from SQL queries and PL/SQL functions
    • User Global Area(UGA):Session information for the Oracle shared server
    • Is sized with the SHARED_POOL_SIZE parameter

    Large Pool

    • Provides large memory allocations for:
      • Session memory for the shared server and the Oracle XA interface
      • I/O server processes
      • Oracle Database backup and restore operations
      • Parallel query operations
      • Advanced Queuing memory table storage
    • Reduces potential framentation of shared pool
    • Is managed by AMM and ASMM
    • Is sized with the LARGE_POOL_SIZE parameter
  • 相关阅读:
    R.drawable 转 bitmap
    opengl
    android 时间1
    mysql 管理工具
    使用BroadcastReceiver实现开机启动Service或Activity
    webView
    博客收藏1
    popupWindow 弹出菜单
    viewpager android viewGroup左右滑动方法1
    Android中Bitmap和Drawable
  • 原文地址:https://www.cnblogs.com/arcer/p/3102012.html
Copyright © 2020-2023  润新知