OraFAQ Forum: Server Administration » Slow running Function

Home » RDBMS Server » Server Administration » Slow running Function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Slow running Function [message #56788]

Thu, 24 April 2003 15:24

Ray
Messages: 58
Registered: January 2000

Member

I have a function that runs slow on 1 server (about 33 seconds) as opposed to another server (about 12 seconds). It is a large function but shouldn't be that slow. The servers are identical in size, processor speed, # of processors, memory,etc. I have checked SHARED POOL size, SHARED MEMORY, SQL AREA, and a few other places, but still no help. Any ideas would be greatly appriciated. Thanks in advance.

Report message to a moderator

Re: Slow running Function [message #56791 is a reply to message #56788]

Fri, 25 April 2003 00:14

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You do have the same Oracle version on both machines, right? How about the indexes? Are they the same on both machines? And the data itself? Perhaps one table is a lot larger than the same table on the other machine. Best is to check the function itself to identify the 'slow' part.

MHE

Report message to a moderator

Re: Slow running Function [message #56795 is a reply to message #56791]

Fri, 25 April 2003 06:48

Ray
Messages: 58
Registered: January 2000

Member

Same version on both machines. Indexes and data appear to be the same as well as the tables being the same in size, structure, etc. Is there a specific function check process that is helpful? Normal stats does not seem to help much. Thanks

Report message to a moderator

Re: Slow running Function [message #56799 is a reply to message #56795]

Fri, 25 April 2003 08:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

just to add what Maaher has said,
check the Opmitmizing mode , whether the tables are analyzed and the sort_area_size

Report message to a moderator

Re: Slow running Function [message #56800 is a reply to message #56799]

Fri, 25 April 2003 09:22

psmyth
Messages: 81
Registered: October 2002

Member

check the contents of dba_tables and dba_indexes for the relevant tables and indexes on both systems - your looking to see if they have been analyzed at similar times in a similar way... might be worth analyling all indexes and tables on both systems and trying it again... if you're not using rule-based optimization (which doesn't use this information anyway).

Report message to a moderator

Re: Slow running Function [message #56801 is a reply to message #56799]

Fri, 25 April 2003 09:54

Ray
Messages: 58
Registered: January 2000

Member

Thanks, will try all of the above mentioned ideas.

Report message to a moderator

Previous Topic:	IP addressing
Next Topic:	Archive files getting generated every two minutes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:32:06 CDT 2024