![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
iteye_15783
这个作者很懒,什么都没留下…
展开
-
Oracle 统计命令
按小时 [code="java"]select to_char(timestamp, 'YYYY-MM-dd hh24') a,sum(num) from udbstat group by to_char(timestamp,'YYYY-MM-dd hh24'); [/code] 按天 [code="java"]select to_char(timestamp, 'YYYY-MM-dd')...原创 2012-03-15 16:48:07 · 122 阅读 · 0 评论 -
resource busy and acquire with NOWAIT specified: TRUNCATE TABLE "USERS"
[code="java"]SQL> select session_id from v$locked_object;[/code] [list] [*]SESSION_ID [*]---------- [*] 43 [/list] [code="java"]SQL> SELECT sid, serial#, username, osuser FROM v$session...原创 2012-04-25 11:47:20 · 123 阅读 · 0 评论