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

On 22 fév, 16:11, vrit..._at_gmail.com wrote:
> > 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.
>
> I'll inform you as soon as i have the explain plan for the query

>From what i could gather, the access plan doesn't get into any details
beyond "access full from dual". We're apparently not able to go beyond that at the moment... Are there directions pointing out how to analyse this correctly (and with minimum tries, because of the impact?) out there on the web?

Sorry for the lack of useful info, i am not a dba guy and am a bit at a loss seeing that the would-be ones are as clueless as i am...

Samy, hounding for clues Received on Thu Feb 22 2007 - 09:31:43 CST