- 论坛徽章:
- 0
|
SQL> select namespace,gethitratio,pinhitratio,reloads,invalidations from v$librarycache;
NAMESPACE GETHITRATIO PINHITRATIO RELOADS INVALIDATIONS
--------------- ----------- ----------- ---------- -------------
SQL AREA .465542403 .936886024 843 28
TABLE/PROCEDURE .680138425 .699982598 1024 0
BODY .943030303 .899718838 57 0
TRIGGER .808510638 .863270777 24 0
INDEX .264550265 .716157205 40 0
CLUSTER .955284553 .97235023 7 0
OBJECT 1 1 0 0
PIPE 1 1 0 0
JAVA SOURCE 1 1 0 0
JAVA RESOURCE 1 1 0 0
JAVA DATA 1 1 0 0
[fly][fly]查询出的GETHITRATIO PINHITRATIO RELOADS INVALIDATIONS
都代表什么意思,如果SQL AREA的这四个值都很大 对系统都有什么影响?[/fly][/fly] |
|