Re: Will Oracle ever follow its own advice?

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 13 Feb 2009 19:44:44 +0100
Message-ID: <4995bf20$0$2850$ba620e4c_at_news.skynet.be>


"Steve Howard" <stevedhoward_at_gmail.com> wrote in message news:fd671b52-0839-47a3-8e0e-004cbbc89ff9_at_b38g2000prf.googlegroups.com...
> 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>
So is Oracle 11g still using the SYSTEM rollback segment ? ;-) Received on Fri Feb 13 2009 - 12:44:44 CST

Original text of this message