共 2 篇文章 |
|
select * from nls_database_parameters where parameter in (''''''''NLS_LANGUAGE'''''''',''''''''NLS_TERRITORY'''''''',''''''''NLS_CHARACTERSET'''... 阅1 转自1qxm19 公众公开 23-02-28 15:30 |
命中率的计算公式为: Hit Ratio = 1 - ((physical reads - physical reads direct - physical reads direct (lob)) / (db block gets + consistent gets - physical reads direct - physical reads direct (lob))SQL>select sum(pins-reloads)/sum(pins)SQL>select executions,disk_reads,buffer_gets,round((buffer_gets-disk_reads)/bu... 阅42 转0 评0 公众公开 20-02-15 16:51 |