인덱스명 조회
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;