Home » RDBMS Server » Performance Tuning » query Dead Slow (11g,
query Dead Slow [message #658228] Wed, 07 December 2016 06:33 Go to next message
Messages: 238
Registered: July 2005
Location: Karachi
Senior Member

dear experts

I have a sub query

FROM oe_order_headers_all h,
oe_order_lines_all l
AND h.ORG_ID      = l.ORG_ID
AND h.org_id      =
FROM org_organization_definitions d
WHERE d.ORGANIZATION_code = :p_Inv_Org_Id
AND h.ORDERED_DATE     <= :p_TransDate
) Com_Sale,

retrive data based on main query where msib.INVENTORY_ITEM_ID joined from main query. Query result is fine but responces time is dead slow.

I am finding a causes why this is dead slow, Please suggest solutions and suggest best possible index combinations.

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
"CORE	Production"
TNS for Linux: Version - Production
NLSRTL Version - Production


Anwer Ali
Re: query Dead Slow [message #658235 is a reply to message #658228] Wed, 07 December 2016 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: query Dead Slow [message #658249 is a reply to message #658228] Wed, 07 December 2016 09:06 Go to previous message
John Watson
Messages: 8935
Registered: January 2010
Location: Global Village
Senior Member
What do you mean by saying that this is a sub-query? Is this just part of a larger SQL? If so, you need to show the whole thing, and of course the execution plan. You can't tune just one sub-query, Oracle may have merged it into the rest.
Previous Topic: ORA-01555 error during expdp
Next Topic: Oracle Advance Queue consumes messages very slowly
Goto Forum:

Current Time: Sun May 26 12:38:52 CDT 2024