被oracle搞死的部分语句(持续更新中)

时间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' ;

 

posted @ 2017-10-16 20:12  情似雨餘黏地絮  阅读(174)  评论(0编辑  收藏  举报