学习的点点滴滴shell+sql

无意义的脚本，大神勿喷/

[root@test Desktop]# vim oraclesh.sh #!/bin/bashclear#函数test_parameter1(){`echo `su - oracle -c 'sqlplus /nolog'< NAME         TYPE  VALUE------------------------------------ ----------- ------------------------------shared_pool_size       big integer 0SQL>   2  COMPONENT        CURRENT_SIZE---------------------------------------------------------------- ------------shared pool           369098752SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options  查看共享池大小    show parameter shared_pool_size   select component,current_size from v$sga_dynamic_components    where component='shared pool'查询信息：1) 用户parameter初始化信息查询！                                               2) 用户SGA信息查询！                                                           3) 用户分享池大小！         4) 查看数据文件磁盘所在位置！        查询信息：4SQL> SGA-------------------------------------------------------------select name from v$datafile--查看数据文件SQL> NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/orcl/system01.dbf/u01/app/oracle/oradata/orcl/sysaux01.dbf/u01/app/oracle/oradata/orcl/undotbs01.dbf/u01/app/oracle/oradata/orcl/users01.dbf/u01/app/oracle/oradata/orcl/example01.dbfSQL> SGA-----------------------------------------select name from v$tempfileSQL> NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/orcl/temp01.dbfSQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options  查看数据文件：   select name from v$datafile;    select name v$tempfile;查询信息：e选择错误，退出！[root@test Desktop]#