OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » pagging (oracle 11.2.0.3 sun solaris 10.5)

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

pagging [message #596832]

Thu, 26 September 2013 11:01

guddu_12
Messages: 223
Registered: April 2012
Location: UK

Senior Member

Hi gurus,

How can i check if pagging happening while running the query. As i have 4gb of PGA target but the query is taking long time in parallel and has hash join.

how to check pagging in 11gr2

Report message to a moderator

Re: pagging [message #596833 is a reply to message #596832]

Thu, 26 September 2013 11:03

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

You don't check paging from within Oracle, you check it with operating system facilities.

Report message to a moderator

Re: pagging [message #596834 is a reply to message #596833]

Thu, 26 September 2013 11:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Report message to a moderator

Re: pagging [message #596865 is a reply to message #596834]

Thu, 26 September 2013 16:28

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

What you probably mean is whether your query is using the TEMP tablespace, or whether it is resolving the hash in memory.

This article contains a section on tracing hash joins to check for just that.

Ross Leishman

Report message to a moderator

Previous Topic:	Split Data separated by comma ; then create a collection with data mapped from other columns
Next Topic:	ISSUE IN THE PERFORMANCE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 07:02:14 CDT 2023