12 2020 档案
摘要:--测试库异常无法启动SQL> startup;ORACLE instance started. Total System Global Area 4977278976 bytesFixed Size 2261768 bytesVariable Size 989859064 bytesDatabas
阅读全文
摘要:1.查看消耗资源最多的 SQL:select hash_value, executions, buffer_gets, disk_reads, parse_callsfrom v$sqlareawhere buffer_gets > 10000000 or disk_reads > 1000000o
阅读全文