Loading ...
Sorry, an error occurred while loading the content.

Re: psae process stmt in cet

Expand Messages
  • hemant_chitale
    Someone has created a Materialized View Log on the PS_ORD_LINE table in the PSCOMMON schema. So, apparently, there s also an MV based on this (and other ?)
    Message 1 of 3 , May 17, 2011
    • 0 Attachment
      Someone has created a Materialized View Log on the PS_ORD_LINE table in the PSCOMMON schema.

      So, apparently, there's also an MV based on this (and other ?) tables.

      Hemant K Chitale

      --- In psftdba@yahoogroups.com, the dragon <ceprn@...> wrote:
      >
      >
      > morning.
      >
      > One of my DBAs has seen the following sql running about 30,000 times a day, and wanted to know if anyone had any ideas about it... is it an issue? is there a solution? does bread with jelly on it also land upside down when you drop it? Why is it upside down, rather than downside up?
      >
      > PT 8.17
      > SCM 8 Sp 2
      > Oracle 9.2.0.8
      > OS = Windoze 2000
      >
      > I personally think it's "black box" PTools level app engine code. It seems to only be occurring in one environment (production (of course)), so we can't really load it down with a bunch of tracing withput papal dispensation, and a blood offering.
      >
      > It may be part of a PSJob, and in this antiquated version of PTools, the PSJob can't be exploded in Process Monitor.
      >
      > Peace,
      > clark 'the dragon' willis
      >
      >
      >
      >
      >
      > INSERT /*+ IDX(0) */ INTO "PSCOMMON"."MLOG$_PS_ORD_LINE" (dmltype$$,old_new$$,snaptime$$,change_vector$$,m_row$$) VALUES (:d,:o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:m)
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.