Some tables used by optimizer to gather statistics

It’s a list of some tables which optimizer uses to gather various statistics related to the database tables.

select * from user_tables
where table_name ='EMP'

 
select * from user_tab_statistics
where table_name ='EMP'
 

select * from user_tab_col_statistics
where table_name ='EMP'

 
select * from user_tab_histograms
where table_name ='EMP'
and column_name = 'EMPID'