Re: Compatible parameter

  • From: Subodh Deshpande <subodh_deshpande@xxxxxxxxx>
  • To: sarah.satterthwaite@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Jul 2009 08:06:13 -0700 (PDT)

hi sarah,
just a doubt..are you sure in pfile you have set the compatibility paramter to 
desired value.

thanks and take care..subodh

________________________________
From: "Satterthwaite, Sarah" <sarah.satterthwaite@xxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Wednesday, 15 July, 2009 19:49:43
Subject: Compatible parameter


My databases are version 10.2.0.4.x, but some of them still have compatible set 
to 10.2.0.3.0.  I want to know what restricted features will become available 
if I raise the value of compatible.
The following is probably from version 7, but I have not found a similar view 
in Oracle 10: 
Type ID  Release      Updated      Description 
-------- ------------ ------------ ----------------------------------- 
BOOTSTRP 7.0.10.0.0   7.0.12.0.0   bootstrap$ 
COMPATSG 7.0.11.0.0   7.0.12.0.0   Compatibility segment 
DATAFILE 7.0.11.0.0                Data file structure 
KCBCICT  7.1.5.0.0                 Cache cross-instance protocol 
LOGSTRUC 7.2.0.0.0                 Log structure 
TRUNCFIX 7.2.0.0.0                 truncate bug fix 
CONTROLF 7.3.0.0.0                 Control file 
RCVREDO  7.3.0.0.0                 Recovery redo 
REDODATA 7.3.0.0.0                 Redo contents 
TEMPTS   7.3.0.0.0    7.3.0.0.0    Temporary tablespace 
TRUNCNT  7.3.0.0.0    7.3.0.0.0    truncation count 
UNDODATA 7.3.0.0.0    7.3.0.0.0    Undo contents 
UNLMTEXT 7.3.0.0.0    7.3.0.0.0    unlimited extents 

DISLOCK  0.0.0.0.0                 Alter Table Disable Table Lock 
FORCEVSN 0.0.0.0.0                 Force undo/redo versions to exist 
HASHEXP  0.0.0.0.0                 Hash expressions in hash clusters 
IMPHSHFN 0.0.0.0.0                 Improved hash function 
KDIBIX   0.0.0.0.0                 bitmap indexes 
KDINFB   0.0.0.0.0                 index support for freelist groups 
LOCKING  0.0.0.0.0                 Instance locking protocol 
MULTTRIG 0.0.0.0.0                 Multiple Triggers Per Type 
RDONLYTS 0.0.0.0.0                 Read only tablespace 
REDOORDR 0.0.0.0.0                 Redo order by SCN 
RESZDAFL 0.0.0.0.0                 Resizable data files 
REUSEBRB 0.0.0.0.0                 reuse index branch blocks 
UPDSNAP  0.0.0.0.0                 Updatable Snapshots 
I am quite sure that it was generated using the following SQL: 
col type_id     format a8       head 'Type ID' 
col release     format a12      head 'Release' 
col description format a40      head 'Description'      word 
col updated     format a12      head 'Updated'          word 
col implemented noprint 
break on implemented skip 2 
spool compatib.rep 
select decode (c.release, '0.0.0.0.0', '2,', '1') implemented, 
       c.type_id, c.release, s.updated, c.description 
from   v$compatibility c, 
       v$compatseg s 
where  c.type_id = s.type_id (+) 
and    c.release = s.release (+) 
order by decode (c.release, '0.0.0.0.0', '2,', '1'), 
         c.release, c.type_id, s.updated 
/ 
Can someone point me to similar information in Oracle 10? 
Thanks, 
Sarah 
_______________________________ 
Sarah Satterthwaite
Database Administrator
Loan Fulfillment Solutions
Fiserv
Fax: 617-498-0959
www.fiserv.com 
P Please consider the environment before printing this e-mail 


      

Other related posts: