Re: Xml query in Oracle: stored proc (apparently) killing the Oracle server

From: <vrittis_at_gmail.com>
Date: 22 Feb 2007 07:11:06 -0800
Message-ID: <1172157065.957701.312050@a75g2000cwd.googlegroups.com>

> Hi Samy,
>
> I would start by tracing the session running the procedure to get an
> explain plan for the query.
>
> Also, how many rows (and what percentage) have the NOM_METADONNEE_C
> starting with REP?
>
> HTH,
>
> Steve

Hello Steve,
Thanks for your prompt reply

I don't have access to the oracle server at the moment, the admin seems to have disappeared in a hole somewhere; however, i may have some difficulty having them relaunch the procedure today - understandably since it forces them to stop and restart the server each time. Can i view the explain plan for the query in toad without launching it? If so, i'll try to do it asap.

Regarding volumetry 1833 out of 62780 rows are returned by the query LIKE 'REP%', a litlle bit more than 2%. If you add to that the fact that we have another selection filter, it doesn't seem impressive at all...

I'll inform you as soon as i have the explain plan for the query

Thanks again
Samy Received on Thu Feb 22 2007 - 09:11:06 CST