Re: I was surprised, thought I'd share...

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 21 Dec 2004 04:34:09 +0000 (GMT)
Message-ID: <20041221043409.33114.qmail@web86909.mail.ukl.yahoo.com>

Similarly...

Whack on a database-wide sql_trace and you'll be amazed at how many recursive queries have the RULE hint within them...

Thomas Biju <BThomas_at_br-inc.com> wrote:

> According to Oracle LONG and LONG RAW data types are deprecated (in Oracle8=
> i) and "we" should convert them to appropriate LOB data types.
> And there are procedures to convert them too...
>
> The following SQL is run on a brand new (not upgraded from earlier version)=
> Oracle 10g 10.1.0.3 database:
>
> system> select data_type, count(*)
> 2 from dba_tab_columns
> 3 where DATA_TYPE like 'LONG%'
> 4 and owner =3D 'SYS'
> 5* group by data_type
> system> /
>
> DATA_TYPE COUNT(*)
> -------------------- ----------
> LONG 209
> LONG RAW 4
>
> system_at_FTWT66OD> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi
> PL/SQL Release 10.1.0.3.0 - Production
> CORE 10.1.0.3.0 Production
> TNS for Solaris: Version 10.1.0.3.0 - Production
> NLSRTL Version 10.1.0.3.0 - Production
>
> system_at_FTWT66OD>
>
> Thanks,
> Biju Thomas
> DBA
>
>
> ___________________________________________________________________________=
> __________________________________
>
> This electronic transmission and any attached files are intended solely for=
> the person or entity to which they are addressed and may contain informati=
> on that is privileged, confidential or otherwise protected from disclosure.=
> Any review, retransmission, dissemination or other use, including taking a=
> ny action concerning this information by anyone other than the named recipi=
> ent, is strictly prohibited. If you are not the intended recipient or have =
> received this communication in error, please immediately notify the sender =
> and destroy this communication.
> --
> http://www.freelists.org/webpage/oracle-l
>

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 20 2004 - 22:29:30 CST