SQL Performance (MOSC)

MOSC Banner

slowness in query execution

edited Jun 25, 2014 5:00AM in SQL Performance (MOSC) 2 commentsAnswered

Note; I have tried running each Update query from  the block below separately but still never get it to complete for days

Declare

Begin

UPDATE user_metadata u

      SET u.metadata =CASE

                              WHEN EXISTSNODE(u.metadata, '/hash/src/text()') = 0

                                THEN insertChildXML(u.metadata, '/hash', 'src', XMLTYPE('<src>S001</src>'))

                               ELSE u.metadata

                              END

where CLIENT_ID = 10021;

UPDATE user_metadata u

      SET u.metadata = CASE

                              WHEN EXISTSNODE(u.metadata, '/hash/practices') = 0

                                THEN insertChildXML(u.metadata, '/hash', 'practices', XMLTYPE('<practices nil="true"></practices>'))

                               ELSE u.metadata

                              END                                                            

where CLIENT_ID = 10021;

UPDATE user_metadata u

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