Re: Event to show Query Rewrite

2003-06-24 Thread Darrell Landrum
2 things, one is that our (on 8i, then updgraded to 9.2.0.1) MVs on prebuilt also show a staleness status of unknown, yet work find. Ok with me we just look for that now. The other thing is depending on what you're wanting to accomplish, you can simply turn off query rewrite for your session,

RE: Event to show Query Rewrite

2003-06-24 Thread Seefelt, Beth
Title: Message Its not an event, but maybe this will help. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/qr.htm#39292 -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:05 PMTo: Multiple recipients of list