How to trace the oracle optimizer...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 3 Apr 2003 17:41:33 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038260D5@lnewton.leeds.lfs.co.uk>

Hi Yvan,

do you mean that you want to see what decisions the optimiser took when creating an execution plan ?
If so, you want to be using event 10053 which will create a trace file with details.

HTH Regards,
Norman.

PS. Your English is fine !

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Yvan GALAS [mailto:yvan.galas_at_fr.adp.com] Posted At: Thursday, April 03, 2003 5:00 PM Posted To: server
Conversation: How to trace the oracle optimizer... Subject: How to trace the oracle optimizer...

Hello

First sorry for my english...

I would like to know how can I trace the oracle optimizer output

The v$slqarea and v$sqltext containt the sql typed in sqlplus tools... but how can I get the rebuild order from the optimizer...

Maybe an event or a special init.ora parameter !? Or I missed a sys tables !? Do I need to dump the SGA ?

Any advices or tips ?

Thanks by advance... Received on Thu Apr 03 2003 - 10:41:33 CST