Home » RDBMS Server » Performance Tuning » pagging (oracle 11.2.0.3 sun solaris 10.5)
pagging [message #596832] Thu, 26 September 2013 11:01 Go to next message
guddu_12
Messages: 163
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
Re: pagging [message #596833 is a reply to message #596832] Thu, 26 September 2013 11:03 Go to previous messageGo to next message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
You don't check paging from within Oracle, you check it with operating system facilities.
Re: pagging [message #596834 is a reply to message #596833] Thu, 26 September 2013 11:07 Go to previous messageGo to next message
BlackSwan
Messages: 21936
Registered: January 2009
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
Re: pagging [message #596865 is a reply to message #596834] Thu, 26 September 2013 16:28 Go to previous message
rleishman
Messages: 3651
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
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:
  


Current Time: Wed Apr 16 01:26:20 CDT 2014

Total time taken to generate the page: 0.24909 seconds