oracle
ilwzxy
这个作者很懒,什么都没留下…
展开
-
oracle timestamp 时间戳增加一天
例 : update tb_user_action_log set created = (select current_timestamp from dual) + numtodsinterval(rownum,'day');翻译 2014-03-21 22:00:51 · 6767 阅读 · 0 评论 -
sqlplus 退格问题
stty erase ^h.转载 2014-04-24 22:07:44 · 621 阅读 · 0 评论 -
oracle解锁表
ORACLE 解除锁表进程select sid,serial# from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID; alter system kill session '39,12076' ; --左侧39,12076 改为 sid,serial# 查出的具体值。原创 2014-03-19 20:13:57 · 746 阅读 · 0 评论 -
ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK
ERROR : ORA-12516: TNS:listener could not find available handler with matching protocol stackCAUSE : 进程到了最大值 alter system set processes=300 scope=spfile; alter system set sessions=300 sc翻译 2014-03-21 13:27:23 · 1401 阅读 · 0 评论