Re: Will Oracle ever follow its own advice?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 12 Feb 2009 16:06:14 -0800 (PST)
Message-ID: <7318273b-5c8d-4790-a7d9-089cc5764bab_at_o11g2000yql.googlegroups.com>

On Feb 12, 12:34 pm, gazzag <gar..._at_jamms.org> wrote:
> On 12 Feb, 17:32, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
>
>
>
>
> > 11:05:39 oracle_at_wcasbuild01 ~ >sqlplus / as sysdba
>
> > SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 12 12:30:28 2009
>
> > Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
>
> > Connected to:
> > Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
> > Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
>
> > SQL> select count(*),owner from dba_tab_columns where data_type =
> > 'LONG' and owner like 'SYS%' group by owner;
>
> >   COUNT(*) OWNER
> > ---------- ------------------------------
> >         11 SYSTEM
> >        219 SYS
>
> > SQL>
>
> > C:\>sqlplus / as sysdba
>
> > SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 12 12:30:43 2009
>
> > Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
> > Connected to:
> > Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
>
> > SQL> select count(*),owner from dba_tab_columns where data_type =
> > 'LONG' and owner like 'SYS%' group by owner;
>
> >   COUNT(*) OWNER
> > ---------- ------------------------------
> >         12 SYSTEM
> >        228 SYS
>
> > SQL>
>
> Do not as I do but do as I say! :)
>
> -g- Hide quoted text -
>
> - Show quoted text -

I tried to post on this earlier via google groups but apparently the post did not make it.

Using 9.2.0.6 and then 10.2.0.3 I ran a select on dba_lobs to count(*) sys owned lobs. If I remember correctly there were 29 rows returned in 9.2 and 94 hits under 10.2 so it would appear that new internal objects and new additions to some existing objects are using the new LOB data types instead of Long. I suspect that it will be a while before Oracle replaces existing working code on Long data types with LOB objects especially since this would take conversion.

Anybody got an 11g system to try the count query on?

IMHO -- Mark D Powell -- Received on Thu Feb 12 2009 - 18:06:14 CST