![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
10:Oracle数据库
文章平均质量分 53
CNMicrosoft
这个作者很懒,什么都没留下…
展开
-
用SQL_TRACE对Oracle进行诊断(一)
http://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm生成trc文件后查找可以通过数据字典表看到trace文件的位置:SELECTd.VALUE|| / || LOWER (RTRIM (i.INSTANCE, CHR (0))) || _ora_ || p.spid|| .trc trace_fil原创 2006-01-20 17:14:00 · 984 阅读 · 0 评论 -
用SQL_TRACE对Oracle进行诊断(二)
分析SQL Trace文件各项的含义OVERALL TOTALS FOR ALL RECURSIVE STATEMENTScall count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- --------原创 2006-01-20 17:17:00 · 1174 阅读 · 0 评论 -
Oracle SQL:减少commit次数以提高sql的性能
详细的分析http://grassbell.itpub.net/post/26/926Oracle数据库中,当需要批量对数据库执行插入或者更新操作时候,减少commit的次数,从而减少transaction的数量,而在每个transaction中包含合适的数据处理量,可以提高sql的性能。测试sql如下:SQL> SQL> set timing onSQL> set serverout原创 2006-01-29 20:44:00 · 4106 阅读 · 0 评论 -
Oracle Read Consistency
Oralce use before image of data in undo segments to provide read consistency.Read consistency ensures the following:.A statement sees data that is consistent with a point in time for the period of原创 2006-10-07 14:08:00 · 1090 阅读 · 0 评论 -
Oracle pseudo column RowID
ROWID stores the address of the row in the database, and it uses ROWIDs to construct index. But you can also use rowid to see how a table is organized. This part is often missed by many people. Or原创 2006-10-07 14:12:00 · 1066 阅读 · 0 评论 -
Sizing an UNDO tablespace
The formula shown here calculates the optimal size for an undo tablespace using the following variables: UR-the undo retention period expressed in seconds UPS-the number of undo blocks generated原创 2006-10-07 14:11:00 · 889 阅读 · 0 评论 -
ORA-12571 ORA-03113错误解决
问题现象:Windows2000环境下System文件坏掉了,不能启动,修复以后机器是启动了,但发现原来的Oracle服务都不见了,也没有什么重要的数据,就重装了一遍,装完以后一切正常,连接Oracle正常,重启动机器以后发现连接Oracle出现错误:ORA-12571:TNS包写入程序失败。用SQLPLUS /NOLOG也不能正常连接,报ORA-03113错误。 解决办法:打开o原创 2007-01-26 10:42:00 · 4655 阅读 · 0 评论