row cache object child latch map

原文

set pages 1000
column cache# format 99999
column name format a33
column latch# format 999999
select distinct s.kqrstcln latch#,r.cache#,r.parameter name,r.type,r.subordinate#
from v$rowcache r,x$kqrst s
where r.cache#=s.kqrstcid
order by 1,4,5;

LATCH# CACHE# NAME                              TYPE        SUBORDINATE#
------- ------ --------------------------------- ----------- ------------
1      3 dc_rollback_segments              PARENT
2      1 dc_free_extents                   PARENT
3      4 dc_used_extents                   PARENT
4      2 dc_segments                       PARENT
5      0 dc_tablespaces                    PARENT
6      5 dc_tablespace_quotas              PARENT
7      6 dc_files                          PARENT
8     10 dc_users                          PARENT
8      7 dc_users                          SUBORDINATE            0
8      7 dc_users                          SUBORDINATE            1
8      7 dc_users                          SUBORDINATE            2
8      7 dc_users                          SUBORDINATE            3
8      7 dc_users                          SUBORDINATE            4
8      7 dc_users                          SUBORDINATE            5
9      8 dc_objects                        PARENT
9      8 dc_object_grants                  SUBORDINATE            0
10     17 dc_global_oids                    PARENT
11     12 dc_constraints                    PARENT
12     13 dc_sequences                      PARENT
13     16 dc_histogram_defs                 PARENT
13     16 dc_histogram_data                 SUBORDINATE            0
13     16 dc_histogram_data                 SUBORDINATE            1
14     54 dc_sql_prs_errors                 PARENT
15     32 kqlsubheap_object                 PARENT
16     19 dc_table_scns                     PARENT
16     19 dc_partition_scns                 SUBORDINATE            0
17     18 dc_outlines                       PARENT
18     15 dc_props                          PARENT
19     60 dc_cdbprops                       PARENT
20     14 dc_profiles                       PARENT
21     47 realm cache                       PARENT
21     47 realm auth                        SUBORDINATE            0
21     47 realm auth                        SUBORDINATE            1
22     48 Command rule cache                PARENT
23     49 Realm Object cache                PARENT
23     49 Realm Subordinate Cache           SUBORDINATE            0
24     46 Rule Set Cache                    PARENT
25     55 DV Auth Cache                     PARENT
26     34 extensible security principal in  PARENT
27     33 Unused                            PARENT
28     36 Unused                            PARENT
29     37 Unused                            PARENT
30     38 XS security class privilege       PARENT
31     39 extensible security midtier cach  PARENT
32     43 AV row cache 1                    PARENT
33     44 AV row cache 2                    PARENT
34     45 AV row cache 3                    PARENT
35     35 triton security name to ID        PARENT
36     61 dc_statistics_status              PARENT
37     62 dc_realtime_colst                 PARENT
38     63 dc_realtime_tabst                 PARENT
39     20 rule_info                         PARENT
40     21 rule_or_piece                     PARENT
40     21 rule_fast_operators               SUBORDINATE            0
41     64 key_shard                         PARENT
42     23 dc_qmc_ldap_cache_entries         PARENT
43     52 qmc_app_cache_entries             PARENT
44     53 qmc_app_cache_entries             PARENT
45     27 qmtmrcin_cache_entries            PARENT
46     28 qmtmrctn_cache_entries            PARENT
47     29 qmtmrcip_cache_entries            PARENT
48     30 qmtmrctp_cache_entries            PARENT
49     31 qmtmrciq_cache_entries            PARENT
50     26 qmtmrctq_cache_entries            PARENT
51      9 qmrc_cache_entries                PARENT
52     50 qmemod_cache_entries              PARENT
53     24 outstanding_alerts                PARENT
54     22 dc_awr_control                    PARENT
55     25 SMO rowcache                      PARENT
56     40 sch_lj_objs                       PARENT
57     41 sch_lj_oids                       PARENT
58     56 dc_cdbfiles                       PARENT
59     57 dc_cdbservices                    PARENT
60     58 dc_pdbdba                         PARENT
61     59 dc_pdbstates                      PARENT

75 rows selected.

参考 ：DOC ID 468334.1