HANA SQL Plan Cache

Mit dem folgenden Statement kann der Hana DB SQL Plan Cache ausgelesen werden.

   SELECT statement_string
         , is_valid
         , last_invalidation_reason reason
         , statement_hash
         , user_name
         , plan_id
         , execution_count
         , last_execution_timestamp
         , last_preparation_timestamp
         , host
      FROM m_sql_plan_cache
     WHERE LOWER( statement_string ) like '%tables%'
 --      AND HOST_NAME =
       AND user_name = 'SYSTEM'
  ORDER BY is_valid DESC
         , last_execution_timestamp;