Hello,
I am trying to select all non-system tables with locked status in the gather statistics job. This is oracle 11g database.
select table_name, OBJECT_TYPE, stattype_locked from user_tab_statistics where table_name != '%sys%'
no rows selected
Thanks for your help with the above query.
I am trying to select all non-system tables with locked status in the gather statistics job. This is oracle 11g database.
select table_name, OBJECT_TYPE, stattype_locked from user_tab_statistics where table_name != '%sys%'
no rows selected
Thanks for your help with the above query.