被oracle搞死的部分语句（持续更新中）

最新推荐文章于 2022-12-05 14:14:18 发布

weixin_30770495

最新推荐文章于 2022-12-05 14:14:18 发布

阅读量67

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/ShaoXin/p/7678623.html

版权

时间between：

 to_char(FIRST_INSERT,'yyyy-MM-dd HH:mm:ss')  BETWEEN to_char('2017-10-07 00:00:00') AND to_char('2017-10-16 00:00:00')

数据库因为不当操作卡死（死锁）：

SELECT p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username,b.os_user_name
FROM v$process p, v$session a, v$locked_object b, all_objects c
WHERE p.addr = a.paddr
AND a.process = b.process
AND c.object_id = b.object_id

alter system kill session '34,4661';

数据库连接数查询：

select count(*) from v$session;
select count(*) from v$process
select value from v$parameter where name = 'processes' 
Select count(*) from v$session where status='ACTIVE' ;