Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what is v$sql_redirection

Re: what is v$sql_redirection

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 25 Aug 2003 20:18:43 +0100
Message-ID: <bidngu$mk3$1$8302bc10@news.demon.co.uk>

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

> 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.
>
>
>
Received on Mon Aug 25 2003 - 14:18:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US