Comments on: Query transformation – Part 1https://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/
Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.Wed, 25 Feb 2015 04:43:00 +0000hourly1http://wordpress.com/By: chiraghttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-2251
Wed, 14 Aug 2013 16:28:31 +0000http://orainternals.wordpress.com/?p=733#comment-2251You have mentioned that join elimination feature is not enable in 11gR1 . Currently we are using 11gR1 and our developer asked is to enable this feature ? How can we enable this feature.
]]>By: Query transformation | BLOG DO ALEXANDRE PIRES "DBA"https://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-1435
Tue, 15 May 2012 23:30:55 +0000http://orainternals.wordpress.com/?p=733#comment-1435[…] the concepts behind Query transformation. Some of the optimizations that we see here works from version 11gR1 onwards and so, these test cases might not work in the versions 10g and […]
]]>By: Programminghttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-867
Thu, 03 Nov 2011 18:31:39 +0000http://orainternals.wordpress.com/?p=733#comment-867Programming…

]]>By: Log Buffer #188, a Carnival of the Vanities for DBAs | The Pythian Bloghttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-530
Mon, 10 May 2010 15:00:27 +0000http://orainternals.wordpress.com/?p=733#comment-530[…] Shamsudeen posts a detailed review of the different query transformation techniques the Oracle query optimizer may use on your […]
]]>By: lakshttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-527
Mon, 03 May 2010 04:31:33 +0000http://orainternals.wordpress.com/?p=733#comment-527Hi,
The trace file and associated trm file in 11.1.0.7.0 db seemed like any other normal trace in udump but for the huge size due to redo/buffer contents getting dumped inside.
There were no errors in alert log during that time.
The code executed didnt throw any errors however based on my understanding it does a lot of deletes.
i woudl revisit the code executed to get better idea,

thanks for your time
regards
laks

]]>By: Chirpir News | Query transformation – Part 1 « Oracle database internals by Riyajhttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-525
Sun, 02 May 2010 16:10:33 +0000http://orainternals.wordpress.com/?p=733#comment-525[…] Read full story […]
]]>By: orainternalshttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-523
Sun, 02 May 2010 14:31:49 +0000http://orainternals.wordpress.com/?p=733#comment-523Hi
What is the trace file name? There is probably a process encountering exception or ASSERT. Any error messages in the alert log during the same time frame in any node?

Cheers
Riyaj

]]>By: lakshttps://orainternals.wordpress.com/2010/05/01/query-transformation-part-1/#comment-522
Sun, 02 May 2010 07:32:48 +0000http://orainternals.wordpress.com/?p=733#comment-522Hi,
A question though unrelated to your current posting.( I am sorry for this.)

I am seeing redo log contents getting dumped in a oracle 11.1.0.7.0 db when executing certain code.
As far as i know i couldnt see any settings/parameters causing this in the db.

The contents i see in a trace file that gets generated when executing the code are like this: