Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what is v$sql_redirection
I haven't looked at it yet, so here's a quick guess - anything to do with query rewrite, and connecting original and rewritten SQL ?
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html ____Finland__September 22nd - 24th ____Norway___September 25th - 26th Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____USA_(CA, TX)_August ____USA__October ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:3f4a5547$1_1_at_news.estpak.ee...Received on Mon Aug 25 2003 - 14:18:43 CDT
> Hi!
>
> What the heck is v$sql_redirection view? 9.2 docs say "This view
identifies
> SQL statements that are redirected". Great...
>
> It queries from x$kglcursor and x$kkssrd (kernel cache shared sql
> redirect?), but I'm not that good in x$views that I could tell from
there,
> what is the purpose of the view..
>
> Tanel.
>
>
>