OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » WINDOW SORT (Oracle 11g)

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

WINDOW SORT [message #533472]

Wed, 30 November 2011 03:29

sachi09
Messages: 22
Registered: October 2011
Location: India

Junior Member

In my insert query, Window sort takes longer time i.e. 93% of total execution time, How do i reduce this time? are there any tuning parameters availabe for this?

Report message to a moderator

Re: WINDOW SORT [message #533479 is a reply to message #533472]

Wed, 30 November 2011 03:47

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove analytic functions.

Regards
Michel

Report message to a moderator

Re: WINDOW SORT [message #533483 is a reply to message #533479]

Wed, 30 November 2011 03:55

sachi09
Messages: 22
Registered: October 2011
Location: India

Junior Member

Hi Michel, thanks for reply.
Analytical function is must in this query, so cannot remove.
Any other option without removing this analytical function? or to speed up WINDOW sorting?
Does sort_multiblock_read_count & hash_multiblock_io_count parameters help to speed up by any chance.

Report message to a moderator

Re: WINDOW SORT [message #533486 is a reply to message #533483]

Wed, 30 November 2011 03:58

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Add "fast=true" parameter.

Regards
Michel

Report message to a moderator

Re: WINDOW SORT [message #533489 is a reply to message #533486]

Wed, 30 November 2011 04:11

sachi09
Messages: 22
Registered: October 2011
Location: India

Junior Member

Thanks again,
Can you give me idea how to implemet this & how does it helps in window sort? Im performing just insert operation,inserting data into table by selecting(having analystical function) from another table.

[Updated on: Wed, 30 November 2011 04:15]

Report message to a moderator

Re: WINDOW SORT [message #533495 is a reply to message #533489]

Wed, 30 November 2011 04:37

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I give up.

For any peformances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Report message to a moderator

Previous Topic:	Data type conversion impact on performance
Next Topic:	memory_max_target and 11g memory utilization - question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:47:16 CDT 2024