Boa tarde,
Oracle 10.2.0.4/Red hat.
Alguem me explica o porque o dc_segments e o dc_object_ids ??
SQL> select round(((1-(sum(getmisses)/sum(gets)))*100),4) dictionary_cache_rate
2 from v$rowcache;
DICTIONARY_CACHE_RATE
---------------------
176,2717
1* select parameter,gets,getmisses from v$rowcache
SQL> /
PARAMETER GETS GETMISSES
-------------------------------- ---------- ----------
dc_free_extents 0 0
dc_used_extents 0 0
dc_segments -1,930E+09 33127626
dc_tablespaces 1094620034 6473
dc_tablespace_quotas 337032 2588
dc_files 141436 22871
dc_users 1205529836 2750
dc_rollback_segments 2921144 61
dc_objects 89438426 14646848
dc_global_oids 700946 64343
dc_constraints 34132 21027
dc_object_ids -1,730E+09 24115305
dc_sequences 35063622 222992
dc_usernames 29436772 15429
dc_database_links 724735 654
dc_histogram_defs 472710278 39369383
kqlsubheap_object 0 0
dc_table_scns 1223 1223
dc_outlines 0 0
dc_profiles 388649 9
realm cache 0 0
Command rule cache 0 0
Realm Object cache 0 0
Rule Set Cache 0 0
event map 0 0
format 0 0
audit collector 0 0
global database name 2572 77
rule_info 0 0
rule_or_piece 0 0
dc_qmc_cache_entries 0 0
dc_qmc_ldap_cache_entries 0 0
qmtmrcin_cache_entries 0 0
qmtmrctn_cache_entries 0 0
qmtmrcip_cache_entries 0 0
qmtmrctp_cache_entries 0 0
qmtmrciq_cache_entries 0 0
qmtmrctq_cache_entries 0 0
outstanding_alerts 171169 38665
dc_awr_control 122444 26
dc_hintsets 0 0
dc_users 0 0
dc_object_grants 1686225 312161
dc_histogram_data 368353537 11655467
dc_histogram_data 180111079 2501479
dc_partition_scns 0 0
dc_users 12700666 755
dc_users 0 0
realm auth 0 0
Realm Subordinate Cache 0 0
rule_fast_operators 0 0
51 rows selected.
SQL>
att.
Phael
[As partes desta mensagem que não continham texto foram removidas]
