Re: Waiting for Table metadata lock for DWH
Posted by: Peter Brawley
Date: September 02, 2019 10:21AM

Note, some of those queries need this to have been executed ...

use performance_schema;
update setup_consumers 
  set enabled = 'yes' where name = 'global_instrumentation';
update setup_instruments 
  set enabled = 'yes' where name = 'wait/lock/metadata/sql/mdl';

Options: ReplyQuote


Subject
Written By
Posted
Re: Waiting for Table metadata lock for DWH
September 02, 2019 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.