Seems like it's inefficient execution plan.
I know that Oracle might go crazy joining dictionary views and V$
views. Can you try to avoid sub-query there? Could be that oracle
"optimized" you select differently for RAC.
On 5/14/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
> Hello.
>
> We have a pl/sql script which we run regularly in the database to monitor
> tablesapce usage and to generate email notification on our regular (non-RAC)
> database. This script when run on RAC database takes way too long to
> complete.(30+ minutes) whicle it completes in under a couple of minutes on
> the regular database.
--
Best regards,
Alex Gorbachev
http://www.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 07:28:00 CDT
