Re: Running SQLs betweem RAC Instance
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 3 Jan 2008 13:48:32 -0800 (PST)
Message-ID: <ebfa83dd-0d8f-424d-a697-62f47b711656@q77g2000hsh.googlegroups.com>
> (DBMS_XPLAN.DISPLAY_CURSOR(l_rec.sql_id)) ) LOOP
Date: Thu, 3 Jan 2008 13:48:32 -0800 (PST)
Message-ID: <ebfa83dd-0d8f-424d-a697-62f47b711656@q77g2000hsh.googlegroups.com>
On Jan 3, 3:38 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
> FOR l_rec3 IN (SELECT plan_table_output > FROM table
> (DBMS_XPLAN.DISPLAY_CURSOR(l_rec.sql_id)) ) LOOP
It sounds like this is your issue. Since you can't pass parameters to a remote object type (which display_cursor) returns, a database link is out. You could use a java stored procedure in the database to do this (URL connects directly to instance x), but this sounds like a ton of work relative to what the database control does for free :) Good learning exercise, though.
Regards,
Steve Received on Thu Jan 03 2008 - 15:48:32 CST