Friday, August 11, 2023

Index details for a specific table in oracle

 select table_name, index_name,column_name,column_position from dba_ind_columns where table_name='EMPL_HIST' and table_owner='XXX';


No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...