Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9.2: Data segment compression bug

Re: Oracle9.2: Data segment compression bug

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 17 Nov 2002 18:49:25 -0000
Message-ID: <ar8oca$2ej$1$8300dec7@news.demon.co.uk>

Also I think the installation notes for 9.2 also have a section on determining which segments are compressed - basically quoting a fragment of code similar to the one that Connor has pointed out. (Possibly it's in the white-paper that another poster has already mentioned).

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 19/21 (Dallas)
____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Connor McDonald wrote in message <3DD7D121.51D4_at_yahoo.com>...

>
>Its not there in xxx_TABLES (once again a bug) but if you look at the
>definition for xxx_TAB_PARTITIONS (where it IS there), you can see
that
>its just an attribute within SEG$
>
>hth
>connor
>--
>==============================
>Connor McDonald
Received on Sun Nov 17 2002 - 12:49:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US