Statspack Report Showing Hash Characters In Place Of Numbers
(Doc ID 2692543.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version 10.2.0.5 and laterInformation in this document applies to any platform.
Symptoms
- Statspack report showing hash characters in place of numbers:
Shared Pool Advisory DB/Inst: <DB_Name>/<Instance_Name> End Snap: 89
-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalidEst LC Est LC Est LC Est LC
Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size (M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
5,440 .9 318 11,856 ####### 1.0 ####### 46.5 ###########
5,504 .9 382 14,717 ####### 1.0 ####### 42.2 ###########
5,568 .9 446 17,159 ####### 1.0 ####### 37.4 ###########
5,632 .9 510 20,791 ####### 1.0 ####### 33.1 ######
Note:
You may find same issue in any section in statspack report.
You may find same issue in any section in statspack report.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |