通过sqlplus查看show sga的语句

来源：互联网发布：淘宝联盟教程视频编辑：程序博客网时间：2024/05/16 14:49

[oracle@centos6 11.2.0]$ which sqlplus/u01/app/oracle/product/11.2.0/bin/sqlplus[oracle@centos6 11.2.0]$ strings /u01/app/oracle/product/11.2.0/bin/sqlplus #查看二进制文件/lib64/ld-linux-x86-64.so.2libsqlplus.so #链接库文件saficxaafidrv_Jv_RegisterClasses__gmon_start__libclntsh.so.11.1__intel_new_proc_init_finilibnnz11.solibdl.so.2libm.so.6libpthread.so.0libnsl.so.1libc.so.6__libc_start_main_edata__bss_start_end/u01/app/oracle/product/11.2.0/libGLIBC_2.2.5fff.fffff.l$ Lt$(L|$0H[oracle@centos6 11.2.0]$ cd $ORACLE_HOME[oracle@centos6 11.2.0]$ find . -name "libsqlplus.so"./lib/libsqlplus.so[oracle@centos6 11.2.0]$ cd lib[oracle@centos6 lib]$ ls libsqlplus.solibsqlplus.so[oracle@centos6 lib]$ vim libsqlplus.so #通过搜索SGA即可得到show sga的sql语句

与show sga比较：

sys@ORCL> SELECT DECODE(null,'','Total System Global Area','') NAME_COL_PLUS_SHOW_SGA,   SUM(VALUE), DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA    UNION ALL    SELECT NAME NAME_COL_PLUS_SHOW_SGA , VALUE,    DECODE (null,'', 'bytes','') units_col_plus_show_sga FROM V$SGA;NAME_COL_PLUS_SHOW_SGA   SUM(VALUE) UNITS_COL_PLUS_------------------------ ---------- ---------------Total System Global Area  776646656 bytesFixed Size                  2257272 bytesVariable Size             524291720 bytesDatabase Buffers          247463936 bytesRedo Buffers                2633728 bytes5 rows selected.sys@ORCL> show sgaTotal System Global Area  776646656 bytesFixed Size                  2257272 bytesVariable Size             524291720 bytesDatabase Buffers          247463936 bytesRedo Buffers                2633728 bytes

0 0