Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 91217
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: Andy.Bucksch [...] ext.imperia-ag.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Fri, 6 Dec 2013 14:37:03 +0000
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
Download (untitled) / with headers
text/plain 941b
Hi, as the title implies, since oracle 11g the RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported. More infos about that: http://www.confio.com/logicalread/oracle-11g-optimizer-changes-affect-tuning-mc02/#.UqHZDcO5TtE Oracle::DBD in version 1.68 produces SQL statements like: SELECT * FROM ( SELECT /*+ CHOOSE */ NULL TABLE_CAT , t.OWNER TABLE_SCHEM , t.TABLE_NAME TABLE_NAME , decode(t.OWNER , 'SYS' , 'SYSTEM ' , 'SYSTEM' , 'SYSTEM ' , '' ) || t.TABLE_TYPE TABLE_TYPE , c.COMMENTS REMARKS FROM ALL_TAB_COMMENTS c , ALL_CATALOG t WHERE c.OWNER (+) = t.OWNER AND c.TABLE_NAME (+) = t.TABLE_NAME AND c.TABLE_TYPE (+) = t.TABLE_TYPE ) WHERE TABLE_SCHEM LIKE '%' ESCAPE '\' AND TABLE_NAME LIKE '%TEST_KD_NEWS' ESCAPE '\' ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME which shows that the CHOOSE hint is still applied by DBD::Oracle. I'm no Oracle expert just a perl developer, please keep that in mind. Greetings, Andy
Subject: Re: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Fri, 06 Dec 2013 12:59:08 -0500
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
Download (untitled) / with headers
text/plain 216b
On 13-12-06 09:37 AM, Andy Bucksch via RT wrote: Show quoted text
> I'm no Oracle expert just a perl developer, please keep that in mind.
Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! `/anick -- --
Download (untitled) / with headers
text/plain 392b
On Fri Dec 06 12:59:22 2013, PYTHIAN wrote: Show quoted text
> On 13-12-06 09:37 AM, Andy Bucksch via RT wrote:
> > I'm no Oracle expert just a perl developer, please keep that in mind.
> > Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! > > `/anick >
See pull request https://github.com/pythian/DBD-Oracle/pull/12 I think this fixes this. Martin -- Martin J. Evans Wetherby, UK
Subject: AW: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g
Date: Thu, 27 Feb 2014 09:14:15 +0000
To: "bug-DBD-Oracle [...] rt.cpan.org" <bug-DBD-Oracle [...] rt.cpan.org>
From: Andy Bucksch <Andy.Bucksch [...] ext.imperia-ag.de>
Download (untitled) / with headers
text/plain 1.4k
Hi Martin, thanks for the info, i will check it out. Greetings, Andy Bucksch Technischer Consultant Imperia AG Von-der-Wettern-Straße 27 51149 Köln Tel: +49 2203 93530 2271 Fax: +49 2203 93530 2101 andy.bucksch@ext.imperia-ag.de – http://www.imperia-ag.de Aktiengesellschaft mit Sitz in Köln Vorsitzender des Aufsichtsrats: Felix Höger Vorstand: Daniel Redanz HRB 45063, Amtsgericht Köln ---- Kennen Sie schon unseren Blog? http://www.cms-board.de ---- Notice: This e-mail is confidential and may contain copyright material of Imperia AG. If you are not the intended recipient, please notify us and delete all copies of this message. Imperia AG accepts no responsibility for damage due to incorrect use of attached materials, corrupted files or viruses. Show quoted text
________________________________________ Von: Martin J Evans via RT [bug-DBD-Oracle@rt.cpan.org] Gesendet: Donnerstag, 20. Februar 2014 14:30 An: Andy Bucksch Betreff: [rt.cpan.org #91217] The RULE (and CHOOSE) OPTIMIZER_MODE has been deprecated and desupported in 11g <URL: https://rt.cpan.org/Ticket/Display.html?id=91217 > On Fri Dec 06 12:59:22 2013, PYTHIAN wrote:
> On 13-12-06 09:37 AM, Andy Bucksch via RT wrote:
> > I'm no Oracle expert just a perl developer, please keep that in mind.
> > Heh. Same thing here. :-) Thanks for the info, I'll see what I can do! > > `/anick >
See pull request https://github.com/pythian/DBD-Oracle/pull/12 I think this fixes this. Martin -- Martin J. Evans Wetherby, UK


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.