Re: Will Oracle ever follow its own advice?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 12 Feb 2009 14:52:50 -0800 (PST)
Message-ID: <9eab8dc1-cfdb-498f-95f5-d41190bdafee_at_q9g2000yqc.googlegroups.com>

On Feb 12, 12:32 pm, 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>
Without some analysis of how much oracle code internally may still be accessing those columns and needs to be converted ... it is hard to come up with anything more than probably this stuff is on a cleanup list and when new features or maintenance coding is done in an area that gets near one or more of these ... maybe a column gets fixed.

Not that I care particularly but a count of how many there were in 7.3 8 ... thru 11.1 might show a trend. Received on Thu Feb 12 2009 - 16:52:50 CST