Oracle Dictionary

인덱스명 조회

select table_name, index_name from user_indexes hwere table_name = 'player'

 

인덱스를 구성하는 컬럼조회

select index_name, column_name from user_ind_columns where table_name = 'player' 

 

파티션

select * from user_part_tables
select * from user_tab_partitions
select * from user_part_key_columns

 

성능

SELECT BUFFER_GETS, SQL_TEXT FROM V$SQLAREA
WHERE BUFFER_GETS > 200000
  and PARSING_SCHEMA_NAME ='MYDB'
ORDER BY BUFFER_GETS DESC;

SELECT DISK_READS, SQL_TEXT FROM V$SQLAREA
WHERE DISK_READS > 10000
  and PARSING_SCHEMA_NAME ='MYDB'
ORDER BY DISK_READS DESC;