OCP 1Z0 053 205

来源:互联网 发布:淘宝退货运费险 编辑:程序博客网 时间:2024/05/21 18:47
SQL> show parameter targetNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------archive_lag_target                   integer     0db_flashback_retention_target        integer     1440fast_start_io_target                 integer     0fast_start_mttr_target               integer     0memory_max_target                    big integer 1232Mmemory_target                        big integer 1232Mparallel_servers_target              integer     64pga_aggregate_target                 big integer 0sga_target                           big integer 0SQL> SELECT COMPONENT,  2         CURRENT_SIZE / 1024 / 1024 AS CURRENT_SIZE,  3         MIN_SIZE / 1024 / 1024 AS MIN_SIZE,  4         MAX_SIZE / 1024 / 1024 AS MAX_SIZE  5    FROM V$MEMORY_DYNAMIC_COMPONENTS  6   WHERE CURRENT_SIZE != 0;COMPONENT            CURRENT_SIZE   MIN_SIZE   MAX_SIZE-------------------- ------------ ---------- ----------shared pool                   184        184        184large pool                     16         16         80java pool                       8          8          8SGA Target                    736        736        736DEFAULT buffer cache          520        456        520PGA Target                    496        496        496已选择6行。
0 0
原创粉丝点击