无意义的脚本,大神勿喷/
[root@test Desktop]# vim oraclesh.sh
#!/bin/bash
clear
#函数
test_parameter1()
{
`echo `su - oracle -c 'sqlplus /nolog'<
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 0
SQL> 2
COMPONENT CURRENT_SIZE
---------------------------------------------------------------- ------------
shared pool 369098752
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With 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) 查看数据文件磁盘所在位置!
查询信息:4
SQL>
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.dbf
SQL>
SGA
----------------------------------
-------select name from v$tempfile
SQL>
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/temp01.dbf
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
查看数据文件:
select name from v$datafile;
select name v$tempfile;
查询信息:e
选择错误,退出!
[root@test Desktop]#