Re: Running SQLs betweem RAC Instance
From: ibodogan <idogan_tech_at_yahoo.com>
Date: Thu, 3 Jan 2008 15:36:03 -0800 (PST)
Message-ID: <a277f1dc-5743-4a6c-b9c0-e8bb814227d2@21g2000hsj.googlegroups.com>
Date: Thu, 3 Jan 2008 15:36:03 -0800 (PST)
Message-ID: <a277f1dc-5743-4a6c-b9c0-e8bb814227d2@21g2000hsj.googlegroups.com>
> /
>
> 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. Received on Thu Jan 03 2008 - 17:36:03 CST