oracle
Sorrysbaby
这个作者很懒,什么都没留下…
展开
-
undo表空间官方说明
Undo RetentionAfter a transaction is committed, undo data is no longer needed for rollback or transaction recovery purposes. However, for consistent read purposes, long-running queries may require thi...原创 2018-03-20 16:08:08 · 219 阅读 · 0 评论 -
pl/sql tns配置
# tnsnames.ora Network Configuration File: /opt/oracle/db01/app/oracle/product/10.2.0/network/admin/tnsnames.ora# Generated by Oracle configuration tools.orcl = (DESCRIPTION = (ADDRESS_LIST = ...原创 2018-03-20 16:11:51 · 1025 阅读 · 0 评论 -
oracle死锁经验
好多搜的百度的,总结一下select l.session_id,o.owner,o.object_namefrom v$locked_object l,dba_objects owhere l.object_id=o.object_id;结果:session_id owner object_nameselect t2.username,t2.sid,t2.serial#,t2.logon_time...原创 2018-03-20 16:14:04 · 174 阅读 · 0 评论