一名刚毕业的大学生,一名oracle爱好者,一名unix爱好者,一名技术爱好者!
发布时间:2013-06-25 17:17:19
look up the table which is locked.SELECT P.SPID, A.SERIAL#, C.OBJECT_NAME, B.SESSION_ID, B.ORACLE_USERNAME,&n.........【阅读全文】
发布时间:2013-06-17 13:30:58
点击(此处)折叠或打开--GET_DDL: Return the metadata for a single object as DDL. -- This interface is meant for casual browsing one object's ddl -- PARAMETERS: object_type - The type of object to be retrieved. name - Name of the object. .........【阅读全文】
发布时间:2013-06-15 20:54:20
事务:Transaction一个事务由一组构成一个逻辑操作的DML语句组成。事务完成:1、commit、rollback(显式提交)2、执行了DDL或DCL语句(隐式提交)3、用户正常退出(提交)4、系统崩溃(回滚)事务特征:1、在提交之前的状态可以恢复2、在commit之前,当前用户可以看到修改.........【阅读全文】
发布时间:2013-06-14 14:27:15
If the high concurrency of insert, and if we insert into the same block, the block will became a hot block, the wait event maybe latch: CBC, data buffer busy. this usually is the case when the index is date related and sequence related. and for some power seller.........【阅读全文】