07 2023 档案
摘要:正常大事务造成undo 和temp临时表空间被占用,如何释放其空间? 一般情况下,需要人为的干预,Oracle不会在其扩展后自动收缩,这部分空间Oracle会保留重用。 相应的方法也类似,可以先尝试resize, 不行的话,可以新建后设为默认,待原有的不再使用后就可以删除。 PS: 如果您是DG环境
阅读全文
摘要:Troubleshooting "Global Enqueue Services Deadlock detected" (Doc ID 1443482.1)
阅读全文
摘要:Troubleshooting Issues with SYSAUX Space Usage (Doc ID 1399365.1)
阅读全文
摘要:推荐值脚本 Oracle Linux: Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration (Doc ID 401749.1) 设置步骤 Oracle Linux: HugePage
阅读全文
摘要:SQL Tuning Health-Check Script (SQLHC) (Doc ID 1366133.1)
阅读全文
摘要:TROUBLESHOOTING: Possible Causes of Poor SQL Performance (Doc ID 33089.1)
阅读全文
摘要:How to work out how many of the parse count are hard/soft? (Doc ID 34433.1)
阅读全文
摘要:Oracle GoldenGate Best Practices: Oracle GoldenGate Conflict Management (Doc ID 1348990.1)
阅读全文
摘要:There will be a script "prvtlmpg.plb" under gg home directory [oracle@OGGR2-1 ogg]$ ls -lrt prvtlmpg.plb -rw-r 1 oracle oinstall 9487 May 27 2015 prvt
阅读全文
摘要:Integrated Extract for ADG standby database (Doc ID 2186503.1) You can not use Integrated Extract for ADG standby database. It's only Classic Extract.
阅读全文