Re: Executing wrong sql
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 10 Oct 2008 10:37:43 -0600
Message-ID: <3c5f7820810100937o544ae5dah763782e76a08ddad@mail.gmail.com>
Date: Fri, 10 Oct 2008 10:37:43 -0600
Message-ID: <3c5f7820810100937o544ae5dah763782e76a08ddad@mail.gmail.com>
No, there is not a materialized view. We get the sql_id from v$session and
then look at v$sqltext. Actually, trace shows the same sql we see with
v$sqltext.
Sandy
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 10 2008 - 11:37:43 CDT