![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库与数据仓库
文章平均质量分 80
Jermaine
xbq826@hotmail.com
注明csdn
展开
-
关于隔离级别(Isolation level)
Isolation levelsThe isolation property is the most often relaxed ACID property in a DBMS (Database Management System). This is because to maintain the highest level of isolation a DBMS must ac转载 2009-02-01 15:54:00 · 2449 阅读 · 0 评论 -
确定Oracle中某张表的High Water Mark
analyze table &owner.&table_name compute statistics<br />/<br /><br />SELECT<br /> blocks<br />FROM<br /> dba_segments<br />WHERE<br /> owner = '&&owner'<br /> AND segment_name = '&&table_name'<br />/<br /><br />SELECT<br /> e原创 2010-06-26 14:38:00 · 389 阅读 · 0 评论 -
如何修改SYSMAN密码
<br />先说一下EM的常用配置命令:<br />创建一个EM资料库<br />emca -repos create<br />重建一个EM资料库<br />emca -repos recreate<br />删除一个EM资料库<br />emca -repos drop<br />配置数据库的 Database Control<br />emca -config dbcontrol db<br />删除数据库的 Database Contr原创 2010-08-01 11:33:00 · 1602 阅读 · 0 评论 -
Oracle Latch牛刀小试
<br />Latch free 等待事件,有单个参数:latch address,latch number,number of tries;在处理此等待事件的时候要注意一下几点:<br /> latch 只应用于 sga的内存结构;不适用与 数据库的 objects;sga有多个latch 用来保护各种内存结构;<br /> session 对等待特殊的 latch;<br /> 到9i latch free 等待事件展现了所有的latch,但是10g 开始就 开始进行了详转载 2010-08-01 11:56:00 · 2398 阅读 · 0 评论 -
Oracle Lock详解
DML Locks<br />These are the locks that Oracle places on your behalf when you execute DML. For the purposes of this post (and my sanity), let’s divide DML into 2 categories: Regular DML (thegarden variety of INSERT, UPDATE, DELETE, SELECT FOR UPDAT转载 2010-08-03 20:20:00 · 724 阅读 · 0 评论