启动/关闭 dynamic view

最新推荐文章于 2022-03-06 15:31:05 发布

cuiting4706

最新推荐文章于 2022-03-06 15:31:05 发布

阅读量812

点赞数

set ORACLE_BASE=D:\oracle

set ORACLE_SID=orcl

set ORACLE_HOME=D:\oracle

emctl start/stop/status dbconsole

shutdown -abort
                   - immediate
                   - transactional
                   - normal

sqlplus scott/tiger as sysdba

shutdown immediate
startup

dynamic performance view:

select sql_text, executions from v$sql
where cpu_time >200000;

select * from v$session where machine = 'd52' and logon_time>sysdate-1;

select sid, ctime from v$lock where block>0;

今天发现开了dbconsole就连不上数据库，查了一下发现是连接数设的太小了：

select count(*) from v$process --当前的连接数
select value from v$parameter where name = 'processes' --数据库允许的最大连接数

修改最大连接数:
alter system set processes = 300 scope = spfile;

重启数据库:
shutdown immediate;
startup;

--查看当前有哪些用户正在使用数据
SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc;