发布时间: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.........【阅读全文】
发布时间:2013-06-13 18:38:34
点击(此处)折叠或打开select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数修改最大连接数:alter system set processes = 300 scope = spfil.........【阅读全文】