SQL Performance (MOSC)

MOSC Banner

long duration of view

edited Jan 6, 2014 8:20PM in SQL Performance (MOSC) 3 commentsAnswered
Hi all

I can't explain behavior of view created in user CSULFR_APP :

CREATE OR REPLACE FORCE VIEW "CSULFR_APP"."MON_V_FORMULAR_HLAVICKA" ("ID", "DATA", "DATUM_VYTVORENI", "DATUM_ZMENY", "NAZEV", "POPIS") AS
  SELECT b.tableid,
    a.preferences,
    TO_DATE(EXTRACTVALUE(XMLTYPE(a.preferences), '/portlet-preferences/preference[name="datumVytvoreni"]/value'), 'DD.MM.YYYY HH24:MI:SS') datum_vytvoreni,
    TO_DATE(EXTRACTVALUE(XMLTYPE(a.preferences), '/portlet-preferences/preference[name="datumZmeny"]/value'), 'DD.MM.YYYY HH24:MI:SS') datum_zmeny,
    EXTRACTVALUE(XMLTYPE(a.preferences), '/portlet-preferences/preference[name="title"]/value') nazev,
    EXTRACTVALUE(XMLTYPE(a.preferences), '/portlet-preferences/preference[name="description"]/value') popis

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center