Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: query rewrite?
I meant tkprof with waits=yes parameter.
Oracle OCP DBA
-----Original Message-----
Sent: Monday, May 05, 2003 1:22 PM
To: 'ORACLE-L_at_fatcity.com'
Just love that trace in 9i has waits as well.
Oracle OCP DBA
-----Original Message-----
Sent: Monday, May 05, 2003 12:22 PM
To: Multiple recipients of list ORACLE-L
Paula,
Your assumption is correct. There is no separate session.
But trace would (hopefully) capture what was run during the session.
-----Original Message-----
Sent: Monday, May 05, 2003 9:37 AM
To: Multiple recipients of list ORACLE-L
Or tracing that particular session.
Question:
I assumed that query rewrite was within the same session. Does Oracle spawn a separate session when using query rewrite?????
Oracle OCP DBA
-----Original Message-----
<mailto:kirti.deshpande_at_verizon.com> ]
Sent: Monday, May 05, 2003 9:52 AM
To: Multiple recipients of list ORACLE-L
How about an Explain Plan? Or tracing with Event 10046?
-----Original Message-----
Sent: Monday, May 05, 2003 12:32 AM
To: Multiple recipients of list ORACLE-L
Hi,
Is there any way to see the query statement after the query statement is rewritten by Oracle with materialized views?
Many thanks in advance.
Chuan
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> -- Author: Chuan Zhang INET: Chuan.Zhang_at_transact.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Mon May 05 2003 - 16:19:56 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).