Re: Running SQLs betweem RAC Instance

On Jan 3, 6:36 pm, ibodogan <idogan_t..._at_yahoo.com> wrote:
> > /
>
> > It does do a very nice job of reporting active sessions, the
> > associated sql and execution plans. [One other change I made was to
> > output the sql_id in the 'Run ...' text to allow for copy and paste to
> > whichever node ran the SQL.] I can understand the desire to have this
> > run on the various nodes from a central point, however I doubt such a
> > feat is possible without resorting to the use of db links. I would
> > suspect using them might be worth a try.
>
> > David Fitzjarrell- Hide quoted text -
>
> > - Show quoted text -
>
> Yes, it's pretty little block.. and you're right it's not worth to get
> the db links involved for it..
>
> i.d.

I could be wrong, but AFAIK, a link would not work, because display_cursor returns an object type, which you can't return over a database link. You may be able to wrap it (the display_cursor call) in a custom function that returns something else like a clob, but that would probably be it.

I still think you could write a java class in the database that would get it (the display_cursor output) back as a string and you could write the PL/SQL wrapper for the java function to print it out, or return whatever you wanted. Received on Fri Jan 04 2008 - 11:10:53 CST