Home » RDBMS Server » Server Administration » statspack rpt_latch.sql "dlm resource hash list"
| statspack rpt_latch.sql "dlm resource hash list" [message #54872] |
Wed, 11 December 2002 13:51  |
Ron Van Cleave
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
Hello,
Hello,
Would anyone have some insights for a couple
latch attributes that are having high wait times?
The attributes are reported from the statspack rpt_latch.sql report:
"process parent latch" and "dlm resource hash list"
As exaample below shows:
Apologize for the formatting.
Specific lines of concern are:
12-10-02 dlm resource hash list -214,097,287 0.1 38.9 -34,619,698 0.0
12-11-02 process parent latch 80,243,322 0.0 27.4 0
Pct Avg Pct
Get Get Sleeps Nowait Nowait
STATS_DA Latch Name Requests Miss /Miss Requests Miss
-------- ------------------------------- --------------- ------ ------ ------------ ------
12-11-02 KCL freelist latch 26,035,436 0.0 0.0 0
12-11-02 KCL lock element parent latch 41,607,969 0.1 0.1 0
12-11-02 KCL name table latch 10,308,204 0.1 0.1 0
12-11-02 Token Manager 4,443 0.0 324,678 0.0
12-11-02 active checkpoint queue latch 188,583 0.0 0.3 84,984 0.0
12-11-02 archive control 1,135 0.0 0
12-11-02 cache buffer handles 39,542 0.0 0
12-11-02 cache buffers chains 192,879,486 0.0 0.1 19,237,511 0.0
12-11-02 cache buffers lru chain 18,205,762 0.2 0.2 10,113,284 0.3
12-11-02 channel handle pool latch 5,576 0.0 0
12-11-02 channel operations parent latch 8,434 0.0 0
12-11-02 checkpoint queue latch 1,320,519 0.0 0.5 0
12-11-02 dlm cr info freelist latch 14 0.0 0
12-11-02 dlm cr request queue latch 116,870 0.0 0.3 0
12-11-02 dlm deadlock list 438,997 0.0 0.0 152 0.0
12-11-02 dlm domain lock latch 2,854 0.0 0
12-11-02 dlm domain lock table latch 1,525,206 0.0 0.1 0
12-11-02 dlm group lock latch 2,854 0.0 0
12-11-02 dlm group lock table latch 21,961,582 0.1 0.3 0
12-11-02 dlm lock table freelist 65,403,739 0.5 0.1 0
12-11-02 dlm process hash list 6,416,373 0.0 0
12-11-02 dlm process table freelist 5,582 0.0 0
12-11-02 dlm recovery domain record latc 6,239,251 0.0 0
12-11-02 dlm resource hash list 100,650,509 0.1 32.9 15,718,134 0.0
12-11-02 dlm resource scan list 102,792 0.0 0
12-11-02 dlm resource table freelist 50,169,565 0.6 0.1 1,957,233 0.3
12-11-02 dlm shared communication latch 55,987,087 0.3 0.3 0
12-11-02 dlm synchronous data latch 5 0.0 13,425 0.0
12-11-02 dlm timeout list 11,458,321 0.1 2.2 2,379 0.1
12-11-02 dml lock allocation 809,143 0.0 0.1 0
12-11-02 enqueue hash chains 3,922,246 0.0 0.2 0
12-11-02 enqueues 5,281,911 0.0 0.1 0
12-11-02 error message lists 656 0.0 0
12-11-02 event group latch 2,854 0.0 0
12-11-02 global transaction 6,038 0.0 0
12-11-02 global tx free list 97 0.0 0
12-11-02 global tx hash mapping 399 0.0 0
12-11-02 hash table modification latch 0 324,669 0.0
12-11-02 i/o slave adaptor 0 324,678 0.0
12-11-02 job_queue_processes parameter l 1,729 0.0 0
12-11-02 ksfv messages 0 649,356 0.0
12-11-02 ktm global data 70 0.0 0
12-11-02 latch wait list 173,457 0.3 0.2 173,724 0.1
12-11-02 library cache 90,028,972 0.3 0.6 2,840,752 2.3
12-11-02 library cache load lock 14,110 0.0 0
12-11-02 list of block allocation 653,357 0.0 0.1 0
12-11-02 longop free list 1,730 0.0 0
12-11-02 messages 4,648,767 0.1 0.1 0
12-11-02 mostly latch-free SCN 19,652,360 0.0 0.1 0
12-11-02 multiblock read objects 3,609,805 0.0 0.1 1 0.0
12-11-02 name-service memory objects 27 0.0 1 0.0
12-11-02 name-service namespace bucket 297,822 0.0 0
12-11-02 name-service pending queue 3,228 0.0 0
12-11-02 name-service request 22 0.0 0
12-11-02 name-service request queue 298,560 0.0 1 0.0
12-11-02 ncodef allocation latch 1,729 0.0 0
12-11-02 parallel query alloc buffer 4,050 0.0 0
12-11-02 parallel query stats 643 0.0 0
12-11-02 process allocation 2,854 0.0 2,854 0.0
12-11-02 process group creation 5,581 0.0 0
12-11-02 process parent latch 80,243,322 0.0 27.4 0
12-11-02 process queue 1,434 0.0 0
12-11-02 process queue reference 98,729 0.0 0.0 2,580 3.7
12-11-02 query server freelists 1,672 0.0 0
12-11-02 query server process 5 0.0 3 0.0
12-11-02 redo allocation 1,616,886 -0.0 -0.0 0
12-11-02 redo copy 0 993,596 -0.2
12-11-02 redo writing 1,792,002 0.1 0.4 0
12-11-02 row cache objects 82,651,758 0.2 0.1 5 0.0
12-11-02 sequence cache 195,308 0.0 0.0 0
12-11-02 session allocation 4,555,469 0.1 0.8 0
12-11-02 session idle bit 27,414,410 0.0 0.0 0
12-11-02 session switching 1,729 0.0 0
12-11-02 shared java pool 1,056 0.0 0
12-11-02 shared pool 37,376,979 0.6 0.5 0
12-11-02 sort extent pool 402 0.0 0
12-11-02 transaction allocation 1,090,863 0.0 0.1 0
12-11-02 transaction branch allocation 1,864 0.0 0
12-11-02 undo global data 989,031 0.0 0.1 0
12-11-02 user lock 118,880 0.0 0.6 0
12-11-02 vecio buf des 0 324,678 0.0
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Dec 28 09:37:07 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
