RE: query rewrite?

Thanks for your invaluable input. I just wonder whether there are any data dictionary in Oracle by any chance to store such query rewrited statement.  

Chuan

-----Original Message-----

[mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Tuesday, 6 May 2003 7:20 AM
To: Multiple recipients of list ORACLE-L

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.  

• Kirti

-----Original Message-----

[mailto:Paula_Stankus_at_doh.state.fl.us]
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-----

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?

• Kirti

-----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 
-- 
Author: Chuan Zhang 
  INET: Chuan.Zhang_at_transact.com.au 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chuan Zhang
  INET: Chuan.Zhang_at_transact.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


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

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).