row cache object child latch map -凯发app官方网站

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

阅读(537) | 评论(0) | 转发(0) |

上一篇：删除文件，实例宕机？是的，ora-63999 数据文件遭受介质故障

下一篇：undo 诊断脚本

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们