Re: Will Oracle ever follow its own advice?

From: Tony Sequeira <nobody_at_127.0.0.1>
Date: Fri, 13 Feb 2009 07:46:04 +0000
Message-ID: <4995253d$0$16167$db0fefd9_at_news.zen.co.uk>

Mark D Powell wrote:

> 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 --
> 

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 13 07:45:07 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(*) from dba_lobs
  2 where owner = 'SYS';

  COUNT(*)

---

       145

-- 
S. Anthony Sequeira
++
You don't have to know how the computer works, just how to work the
computer.
++

Received on Fri Feb 13 2009 - 01:46:04 CST