Скачать или смотреть Oracle Index Utilization Question

This video is in response to a question on another video that introduced Oracle Index utilization monitoring. A channel viewer asked about index utilization details not being available right away. This video covers some details that can help explain why.

URL for the original video -    • Oracle Index Utilization  

SQL from the video:
create table test_index(id number generated always as identity, name varchar2(100), department varchar2(100) );

create unique index ukx_test_index on test_index(id);
create index ix2_test_index on test_index(name);
create index ix3_test_index on test_index(department);

insert into test_index( name, department) values('tom', 'shipping');
insert into test_index( name, department) values('tim', 'packing');

select *
from test_index
where id=2

select *
from test_index
where name='tom'

select *
from dba_index_usage
where name like '%TEST_INDEX%'


SELECT index_stats_enabled,
index_stats_collection_type,
active_elem_count,
last_flush_time,
sysdate
FROM v$index_usage_info;



ALTER SESSION SET "_iut_stat_collection_type"=ALL;
ALTER SESSION SET "_iut_stat_collection_type"=SAMPLED;


If you would like to submit a question or comment please drop it below!

Company Website
http://www.serverside-ts.com

Contact Email: [email protected]