Can you run the procedure locally instead of over dblinks?
What version are you on?
What does your plan tell you about all those outer joins?
What has changed since it ran good?
Good statistics on all tables?
Lots of deletes in those hinted indices?
Skewed data?
Can you put the data into materialized views?
Have you changed sorting parameters or using pga_aggregate_target?
What platform are you on?
What are you waiting on?
Do you have undocumented parameters set?
Do you have anything set to force processing on the remote instance?
Ran a trace?
jg
--
@home.com is bogus.
"...collided with the terrain..."
http://www.ntsb.gov/NTSB/brief.asp?ev_id=20060509X00531&key=1
Received on Fri May 26 2006 - 16:17:47 CDT
