List Oracle SQL Hints

Below lists Oracle SQL hints:

Oracle SQL Function Detail

Below lists Oracle SQL Function , and which version introduce this:

SQL> SELECT NAME,VERSION,DATATYPE,DESCR FROM v$sqlfn_metadata  order by 2;

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTKDUSTOOPN                   INVALID      UNKNOWN  KDUSTOOPN
OPTTLK2                        SQL/DS       UNKNOWN   LIKE
OPTURNE                        SQL/DS       UNKNOWN  <>
OPTTUA                         SQL/DS       UNKNOWN   UNION ALL
COS                            SQL/DS       NUMERIC  COS
SIN                            SQL/DS       NUMERIC  SIN
TAN                            SQL/DS       NUMERIC  TAN
COSH                           SQL/DS       NUMERIC  COSH
SINH                           SQL/DS       NUMERIC  SINH
TANH                           SQL/DS       NUMERIC  TANH
EXP                            SQL/DS       NUMERIC  EXP
LN                             SQL/DS       NUMERIC  LN
LOG                            SQL/DS       NUMERIC  LOG
OPTCFX                         SQL/DS       UNKNOWN  ANSI Fix Character Function
>                              SQL/DS       UNKNOWN  >
<                              SQL/DS       UNKNOWN  <
>=                             SQL/DS       UNKNOWN  >=
<=                             SQL/DS       UNKNOWN  <=
=                              SQL/DS       UNKNOWN  =
!=                             SQL/DS       UNKNOWN  <>

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTNLS                         SQL/DS       UNKNOWN  NLS Parameter String To Internal Representation
OPTTVLCF                       SQL/DS       UNKNOWN  TO_NUMBER
TO_SINGLE_BYTE                 SQL/DS       STRING   TO_SINGLE_BYTE
TO_MULTI_BYTE                  SQL/DS       STRING   TO_MULTI_BYTE
NLS_LOWER                      SQL/DS       STRING   NLS_LOWER
NLS_UPPER                      SQL/DS       STRING   NLS_UPPER
NLS_INITCAP                    SQL/DS       STRING   NLS_INITCAP
INSTRB                         SQL/DS       NUMERIC  INSTRB
LENGTHB                        SQL/DS       NUMERIC  LENGTHB
SUBSTRB                        SQL/DS       STRING   SUBSTRB
OPTRTUR                        SQL/DS       UNKNOWN  DTYRID=>DTYBURI
OPTURTB                        SQL/DS       UNKNOWN  DTYBURI=>DTYBRI
OPTBTUR                        SQL/DS       UNKNOWN  DTYBRI=>DTYBURI
OPTCTUR                        SQL/DS       UNKNOWN  DTYCHR=>DTYBURI
OPTURTC                        SQL/DS       UNKNOWN  DTYBURI=>DTYCHR
OPTURGT                        SQL/DS       UNKNOWN  >
OPTURLT                        SQL/DS       UNKNOWN  <
OPTURGE                        SQL/DS       UNKNOWN  >=
OPTURLE                        SQL/DS       UNKNOWN  <=
OPTUREQ                        SQL/DS       UNKNOWN  =
OPTTNK2                        SQL/DS       UNKNOWN   NOT LIKE

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_XQRENAME                   V10 Oracle   UNKNOWN  SYS_XQRENAME
SYS_XQREPLACE                  V10 Oracle   UNKNOWN  SYS_XQREPLACE
SYS_XQXFORM                    V10 Oracle   UNKNOWN  SYS_XQXFORM
SYS_XQFTCONTAIN                V10 Oracle   UNKNOWN  SYS_XQXFORM
SYS_XQPOLYVNE                  V10 Oracle   UNKNOWN  SYS_XQPOLYVNE
SYS_XQPOLYFLR                  V10 Oracle   UNKNOWN  SYS_XQPOLYFLR
SYS_XQPOLYCEL                  V10 Oracle   UNKNOWN  SYS_XQPOLYCEL
SYS_XQPOLYABS                  V10 Oracle   UNKNOWN  SYS_XQPOLYABS
SYS_XQPOLYRND                  V10 Oracle   UNKNOWN  SYS_XQPOLYRND
SYS_XQSTARTSWITH               V10 Oracle   UNKNOWN  SYS_XQSTARTSWITH
SYS_XQENDSWITH                 V10 Oracle   UNKNOWN  SYS_XQENDSWITH
SYS_XQSUBSTRBEF                V10 Oracle   UNKNOWN  SYS_XQSUBSTRBEF
SYS_XQSUBSTRAFT                V10 Oracle   UNKNOWN  SYS_XQSUBSTRAFT
SYS_XQSTRJOIN                  V10 Oracle   UNKNOWN  SYS_XQSTRJOIN
SYS_XQNORMSPACE                V10 Oracle   UNKNOWN  SYS_XQNORMSPACE
SYS_XQNORMUCODE                V10 Oracle   UNKNOWN  SYS_XQNORMUCODE
SYS_XQED4URI                   V10 Oracle   UNKNOWN  SYS_XQED4URI
SYS_XQIRI2URI                  V10 Oracle   UNKNOWN  SYS_XQIRI2URI
SYS_XQESHTMLURI                V10 Oracle   UNKNOWN  SYS_XQESHTMLURI
SYS_XQCODEP2STR                V10 Oracle   UNKNOWN  SYS_XQCODEP2STR
SYS_XQSTR2CODEP                V10 Oracle   UNKNOWN  SYS_XQSTR2CODEP

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_XQCODEPEQ                  V10 Oracle   UNKNOWN  SYS_XQCODEPEQ
SYS_XQFNCMP                    V10 Oracle   UNKNOWN  SYS_XQFNCMP
SYS_XQRNDHALF2EVN              V10 Oracle   UNKNOWN  SYS_XQRNDHALF2EVN
SYS_XQNODENAME                 V10 Oracle   UNKNOWN  SYS_XQNODENAME
SYS_XQNILLED                   V10 Oracle   UNKNOWN  SYS_XQNILLED
SYS_XQBASEURI                  V10 Oracle   UNKNOWN  SYS_XQBASEURI
SYS_XQDOCURI                   V10 Oracle   UNKNOWN  SYS_XQDOCURI
SYS_XQRESVURI                  V10 Oracle   UNKNOWN  SYS_XQRESVURI
SYS_XQDFLTCOLATION             V10 Oracle   UNKNOWN  SYS_XQDFLTCOLATION
SYS_XQSTATBURI                 V10 Oracle   UNKNOWN  SYS_XQSTATBURI
SYS_XQRSLVQNM                  V10 Oracle   UNKNOWN  SYS_XQRSLVQNM
SYS_XQFNQNM                    V10 Oracle   UNKNOWN  SYS_XQFNQNM
SYS_XQPFXFRMQNM                V10 Oracle   UNKNOWN  SYS_XQPFXFRMQNM
SYS_XQLLNMFRMQNM               V10 Oracle   UNKNOWN  SYS_XQLLNMFRMQNM
SYS_XQNSPFRMQNM                V10 Oracle   UNKNOWN  SYS_XQNSPFRMQNM
SYS_XQNSP4PFX                  V10 Oracle   UNKNOWN  SYS_XQNSP4PFX
SYS_XQINSPFX                   V10 Oracle   UNKNOWN  SYS_XQINSPFX
SYS_XQFNNM                     V10 Oracle   UNKNOWN  SYS_XQFNNM
SYS_XQSEQRVS                   V10 Oracle   UNKNOWN  SYS_XQSEQRVS
SYS_XQINDXOF                   V10 Oracle   UNKNOWN  SYS_XQINDXOF
SYS_XQSEQ2CON4XC               V10 Oracle   UNKNOWN  SYS_XQSEQ2CON4XC

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_XQPOLYUPLS                 V10 Oracle   UNKNOWN  SYS_XQPOLYUPLS
SYS_XQPOLYUMUS                 V10 Oracle   UNKNOWN  SYS_XQPOLYUMUS
SYS_XQPOLYCST                  V10 Oracle   UNKNOWN  SYS_XQPOLYCST
SYS_XQPOLYCSTBL                V10 Oracle   UNKNOWN  SYS_XQPOLYCSTBL
SYS_XQPOLYSQRT                 V10 Oracle   UNKNOWN  SYS_XQPOLYSQRT
SYS_XQFUNCR                    V10 Oracle   UNKNOWN  SYS_XQFUNCR
SYS_XQERR                      V10 Oracle   UNKNOWN  SYS_XQERR
SYS_XQMKNODEREF                V10 Oracle   UNKNOWN  SYS_XQMKNODEREF
SYS_XQRYWRP                    V10 Oracle   UNKNOWN  SYS_XQRYWRP
SYS_XQEXSTWRP                  V10 Oracle   UNKNOWN  SYS_XQEXSTWRP
SYS_XQRYVARGET                 V10 Oracle   UNKNOWN  SYS_XQRYVARGET
SYS_XQRYENVPGET                V10 Oracle   UNKNOWN  SYS_XQRYENVPGET
SYS_XQFNROOT                   V10 Oracle   UNKNOWN  SYS_XQFNROOT
SYS_XQREF2VAL                  V10 Oracle   UNKNOWN  SYS_XQREF2VAL
INSERTCHILDXMLBEFORE           V10 Oracle   UNKNOWN  INSERTCHILDXMLBEFORE
INSERTCHILDXMLAFTER            V10 Oracle   UNKNOWN  INSERTCHILDXMLAFTER
SYS_XQFNDATIM                  V10 Oracle   UNKNOWN  SYS_XQFNDATIM
SYS_XQLANG                     V10 Oracle   UNKNOWN  SYS_XQLANG
SYS_XQDOC                      V10 Oracle   UNKNOWN  SYS_XQDOC
SYS_XQFB2STR                   V10 Oracle   UNKNOWN  SYS_XQFB2STR
OPTORNA                        V10 Oracle   UNKNOWN  N-way relational OR ANSI

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTORNO                        V10 Oracle   UNKNOWN  N-way relational OR ORACLE
INSERTXMLAFTER                 V10 Oracle   UNKNOWN  INSERTXMLAFTER
SYS_GETTOKENID                 V10 Oracle   UNKNOWN  SYS_GETTOKENID
SYS_XQDELETE                   V10 Oracle   UNKNOWN  SYS_XQDELETE
SYS_XQINSERT                   V10 Oracle   UNKNOWN  SYS_XQINSERT
CV                             V10 Oracle   UNKNOWN  CV
SYS_OP_XPTHATG                 V10 Oracle   UNKNOWN  SYS_OP_XPTHATG
SYS_OP_XPTHOP                  V10 Oracle   UNKNOWN  SYS_OP_XPTHOP
SYS_OP_XPTHIDX                 V10 Oracle   UNKNOWN  SYS_OP_XPTHIDX
SYS_OP_XTXT2SQLT               V10 Oracle   UNKNOWN  SYS_OP_XTXT2SQLT
OPTWNLNNV                      V10 Oracle   UNKNOWN  LAST_VALUE
OPTWNFNNV                      V10 Oracle   UNKNOWN  FIRST_VALUE
OPTXMLSERIALIZE                V10 Oracle   UNKNOWN  XMLSERIALIZE
SYS_OP_ROWIDTOOBJ              V10 Oracle   UNKNOWN  ROWID=>Obj#
SYS_MAKE_XMLNODEID             V10 Oracle   UNKNOWN  SYS_MAKE_XMLNODEID
SYS_XMLNODEID_GETRID           V10 Oracle   UNKNOWN  SYS_XMLNODEID_GETRID
SYS_XMLNODEID_GETOKEY          V10 Oracle   UNKNOWN  SYS_XMLNODEID_GETOKEY
SYS_XQ_PKSQL2XML               V10 Oracle   UNKNOWN  SYS_XQ_PKSQL2XML
SYS_XQ_UPKXML2SQL              V10 Oracle   UNKNOWN  SYS_XQ_UPKXML2SQL
SYS_XQ_ATOMCNVCHK              V10 Oracle   UNKNOWN  SYS_XQ_ATOMCNVCHK
SYS_XQ_ASQLCNV                 V10 Oracle   UNKNOWN  SYS_XQ_ASQLCNV

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTENCRYPT                     V10 Oracle   UNKNOWN  OPTENCRYPT
OPTDECRYPT                     V10 Oracle   UNKNOWN  OPTDECRYPT
SYS_XMLNODEID_GETSVAL          V10 Oracle   UNKNOWN  SYS_XMLNODEID_GETSVAL
SYS_PATHID_LASTNAME            V10 Oracle   UNKNOWN  SYS_PATHID_LASTNAME
SYS_PATHID_LASTNMSPC           V10 Oracle   UNKNOWN  SYS_PATHID_LASTNMSPC
SYS_PATHID_IS_NMSPC            V10 Oracle   UNKNOWN  SYS_PATHID_IS_NMSPC
SYS_ORDERKEY_MAXCHILD          V10 Oracle   UNKNOWN  SYS_ORDERKEY_MAXCHILD
SYS_ORDERKEY_PARENT            V10 Oracle   UNKNOWN  SYS_ORDERKEY_PARENT
SYS_ORDERKEY_DEPTH             V10 Oracle   UNKNOWN  SYS_ORDERKEY_DEPTH
SYS_XMLI_LOC_ISTEXT            V10 Oracle   UNKNOWN  SYS_XMLI_LOC_ISTEXT
SYS_XMLI_LOC_ISNODE            V10 Oracle   UNKNOWN  SYS_XMLI_LOC_ISNODE
SYS_PATH_REVERSE               V10 Oracle   UNKNOWN  SYS_PATH_REVERSE
SYS_PATHID_IS_ATTR             V10 Oracle   UNKNOWN  SYS_PATHID_IS_ATTR
SYS_XQGETCONTENT               V10 Oracle   UNKNOWN  SYS_XQGETCONTENT
SYS_XQSEQTYPMATCH              V10 Oracle   UNKNOWN  SYS_XQSEQTYPMATCH
SYS_XQTREATAS                  V10 Oracle   UNKNOWN  SYS_XQTREATAS
SYS_XQSEQINSB                  V10 Oracle   UNKNOWN  SYS_XQSEQINSB
SYS_XQSEQRM                    V10 Oracle   UNKNOWN  SYS_XQSEQRM
SYS_XQSEQSUB                   V10 Oracle   UNKNOWN  SYS_XQSEQSUB
SYS_XQSEQDEEPEQ                V10 Oracle   UNKNOWN  SYS_XQSEQDEEPEQ
SYS_XQERRH                     V10 Oracle   UNKNOWN  SYS_XQERRH

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
XMLTRANSFORMBLOB               V10 Oracle   UNKNOWN  XMLTRANSFORMBLOB
SYS_XMLNODEID                  V10 Oracle   UNKNOWN  SYS_XMLNODEID
SYS_XMLNODEID_GETPATHID        V10 Oracle   UNKNOWN  SYS_XMLNODEID_GETPATHID
SYS_XMLNODEID_GETLOCATOR       V10 Oracle   UNKNOWN  SYS_XMLNODEID_GETLOCATOR
SYS_XQPOLYADD                  V10 Oracle   UNKNOWN  SYS_XQPOLYADD
SYS_XQPOLYSUB                  V10 Oracle   UNKNOWN  SYS_XQPOLYSUB
SYS_XQPOLYMUL                  V10 Oracle   UNKNOWN  SYS_XQPOLYMUL
SYS_XQPOLYDIV                  V10 Oracle   UNKNOWN  SYS_XQPOLYDIC
SYS_XQPOLYMOD                  V10 Oracle   UNKNOWN  SYS_XQPOLYMOD
SYS_XQPOLYVEQ                  V10 Oracle   UNKNOWN  SYS_XQPOLYVEQ
SYS_XQPOLYVLT                  V10 Oracle   UNKNOWN  SYS_XQPOLYVLT
SYS_XQPOLYVLE                  V10 Oracle   UNKNOWN  SYS_XQPOLYVLE
SYS_XQPOLYVGT                  V10 Oracle   UNKNOWN  SYS_XQPOLYVGT
SYS_XQPOLYVGE                  V10 Oracle   UNKNOWN  SYS_XQPOLYVGE
VARIANCE                       V10 Oracle   NUMERIC  VARIANCE(FLOAT) (Windows)
VARIANCE                       V10 Oracle   NUMERIC  VARIANCE(DOUBLE) (Windows)
MEDIAN                         V10 Oracle   NUMERIC  MEDIAN
STATS_MODE                     V10 Oracle   ARG 1    STATS_MODE
STATS_T_TEST_ONE               V10 Oracle   NUMERIC  STATS_T_TEST_ONE
STATS_T_TEST_PAIRED            V10 Oracle   NUMERIC  STATS_T_TEST_PAIRED
STATS_T_TEST_INDEP             V10 Oracle   NUMERIC  STATS_T_TEST_INDEP

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
STATS_T_TEST_INDEPU            V10 Oracle   NUMERIC  STATS_T_TEST_INDEPU
STATS_F_TEST                   V10 Oracle   NUMERIC  STATS_F_TEST
STATS_ONE_WAY_ANOVA            V10 Oracle   STRING   STATS_ONE_WAY_ANOVA
STATS_CROSSTAB                 V10 Oracle   NUMERIC  STATS_CROSSTAB
STATS_BINOMIAL_TEST            V10 Oracle   NUMERIC  STATS_BINOMIAL_TEST
STATS_WSR_TEST                 V10 Oracle   NUMERIC  STATS_WSR_TEST
STATS_MW_TEST                  V10 Oracle   NUMERIC  STATS_MW_TEST
STATS_KS_TEST                  V10 Oracle   NUMERIC  STATS_KS_TEST
CORR_S                         V10 Oracle   NUMERIC  CORR_S
CORR_K                         V10 Oracle   NUMERIC  CORR_K
OPTCL2NCL                      V10 Oracle   UNKNOWN  CLOB<=>NCLOB
OPTRTRI                        V10 Oracle   UNKNOWN  RTRIM '      ' to ' '
OPTMSUA                        V10 Oracle   UNKNOWN  MULTISET UNION
OPTMSUD                        V10 Oracle   UNKNOWN  MULTISET UNION DISTINCT
OPTMSIA                        V10 Oracle   UNKNOWN  MULTISET INTERSECT
OPTMSID                        V10 Oracle   UNKNOWN  MULTISET INTERSECT DISTINCT
OPTMSEA                        V10 Oracle   UNKNOWN  MULTISET EXCEPT
OPTMSED                        V10 Oracle   UNKNOWN  MULTISET EXCEPT DISTINCT
SET                            V10 Oracle   BINARY   SET
CARDINALITY                    V10 Oracle   NUMERIC  CARDINALITY
SUBMULTISET                    V10 Oracle   UNKNOWN  SUBMULTISET

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTNOTSUBMS                    V10 Oracle   UNKNOWN  NOT SUBMULTISET
OPTMEMBER                      V10 Oracle   UNKNOWN  MEMBER OF
OPTNOTMEMBER                   V10 Oracle   UNKNOWN  NOT MEMBER OF
OPTISSET                       V10 Oracle   UNKNOWN  IS A SET
OPTISNOTSET                    V10 Oracle   UNKNOWN  IS NOT A SET
OPTISEMPTY                     V10 Oracle   UNKNOWN  IS EMPTY
OPTISNOTEMPTY                  V10 Oracle   UNKNOWN  IS NOT EMPTY
POWERMULTISET                  V10 Oracle   UNKNOWN  POWERMULTISET
POWERMULTISET_BY_CARDINALITY   V10 Oracle   UNKNOWN  POWERMULTISET_BY_CARDINALITY
OPTNINF                        V10 Oracle   UNKNOWN   IS INFINITE
OPTNNAN                        V10 Oracle   UNKNOWN   IS NAN
OPTNNINF                       V10 Oracle   UNKNOWN   IS NOT INFINITE
OPTNNNAN                       V10 Oracle   UNKNOWN   IS NOT NAN
NANVL                          V10 Oracle   NUMERIC  NANVL
REMAINDER                      V10 Oracle   NUMERIC  REMAINDER
INSERTXMLBEFORE                V10 Oracle   UNKNOWN  INSERTXMLBEFORE
APPENDCHILDXML                 V10 Oracle   UNKNOWN  APPENDCHILDXML
DELETEXML                      V10 Oracle   UNKNOWN  DELETEXML
OPTXMLROOT                     V10 Oracle   UNKNOWN  XMLROOT
XMLCOMMENT                     V10 Oracle   UNKNOWN  XMLCOMMENT
OPTXMLPI                       V10 Oracle   UNKNOWN  XMLPI

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
XMLCDATA                       V10 Oracle   UNKNOWN  XMLCDATA
HEXTOREF                       V10 Oracle   UNKNOWN  HEXTOREF
OPTTTESTOD                     V10 Oracle   UNKNOWN  STATS_T_TEST_ONE
OPTTTESTPD                     V10 Oracle   UNKNOWN  STATS_T_TEST_PAIRED
OPTTTESTIPD                    V10 Oracle   UNKNOWN  STATS_T_TEST_INDEP
OPTTTESTIUD                    V10 Oracle   UNKNOWN  STATS_T_TEST_INDEPU
OPTFTESTD                      V10 Oracle   UNKNOWN  STATS_F_TEST
OPTANOVAONED                   V10 Oracle   NUMERIC  STATS_ONE_WAY_ANOVA
OPTWSRTESTD                    V10 Oracle   NUMERIC  STATS_WSR_TEST
OPTFCFINT                      V10 Oracle   UNKNOWN  BINARY_FLOAT=>DTYINT
OPTFCDINT                      V10 Oracle   UNKNOWN  BINARY_DOUBLE=>DTYINT
OPTFCINTF                      V10 Oracle   UNKNOWN  DTYINT=>BINARY_FLOAT
OPTFCINTD                      V10 Oracle   UNKNOWN  DTYINT=>BINARY_DOUBLE
OPTCAST3                       V10 Oracle   UNKNOWN  SYS_OP_CAST( as ): slaves only
REMAINDER                      V10 Oracle   NUMERIC  REMAINDER
REMAINDER                      V10 Oracle   NUMERIC  REMAINDER
ABS                            V10 Oracle   NUMERIC  ABS
ABS                            V10 Oracle   NUMERIC  ABS
ACOS                           V10 Oracle   NUMERIC  ACOS
ASIN                           V10 Oracle   NUMERIC  ASIN
ATAN                           V10 Oracle   NUMERIC  ATAN

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
ATAN2                          V10 Oracle   NUMERIC  ATAN2
CEIL                           V10 Oracle   NUMERIC  CEIL
CEIL                           V10 Oracle   NUMERIC  CEIL
COS                            V10 Oracle   NUMERIC  COS
COSH                           V10 Oracle   NUMERIC  COSH
EXP                            V10 Oracle   NUMERIC  EXP
FLOOR                          V10 Oracle   NUMERIC  FLOOR
FLOOR                          V10 Oracle   NUMERIC  FLOOR
LN                             V10 Oracle   NUMERIC  LN
LOG                            V10 Oracle   NUMERIC  LOG
MOD                            V10 Oracle   NUMERIC  MOD
MOD                            V10 Oracle   NUMERIC  MOD
POWER                          V10 Oracle   NUMERIC  POWER
ROUND                          V10 Oracle   NUMERIC  ROUND
ROUND                          V10 Oracle   NUMERIC  ROUND
SIGN                           V10 Oracle   NUMERIC  SIGN
SIGN                           V10 Oracle   NUMERIC  SIGN
SIN                            V10 Oracle   NUMERIC  SIN
SINH                           V10 Oracle   NUMERIC  SINH
SQRT                           V10 Oracle   NUMERIC  SQRT
SQRT                           V10 Oracle   NUMERIC  SQRT

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
TAN                            V10 Oracle   NUMERIC  TAN
TANH                           V10 Oracle   NUMERIC  TANH
TRUNC                          V10 Oracle   NUMERIC  TRUNC
TRUNC                          V10 Oracle   NUMERIC  TRUNC
STDDEV                         V10 Oracle   NUMERIC  STDDEV
STDDEV                         V10 Oracle   NUMERIC  STDDEV
VARIANCE                       V10 Oracle   NUMERIC  VARIANCE
VARIANCE                       V10 Oracle   NUMERIC  VARIANCE
AVG                            V10 Oracle   NUMERIC  AVG
AVG                            V10 Oracle   NUMERIC  AVG
SUM                            V10 Oracle   NUMERIC  SUM
SUM                            V10 Oracle   NUMERIC  SUM
OPTFFADD                       V10 Oracle   UNKNOWN  +
OPTFDADD                       V10 Oracle   UNKNOWN  +
OPTFFSUB                       V10 Oracle   UNKNOWN  -
OPTFDSUB                       V10 Oracle   UNKNOWN  -
OPTFFMUL                       V10 Oracle   UNKNOWN  *
OPTFDMUL                       V10 Oracle   UNKNOWN  *
OPTFFDIV                       V10 Oracle   UNKNOWN  /
OPTFDDIV                       V10 Oracle   UNKNOWN  /
OPTFFNEG                       V10 Oracle   UNKNOWN  -

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTFDNEG                       V10 Oracle   UNKNOWN  -
OPTFCFEI                       V10 Oracle   UNKNOWN  C float=>Canonical float
OPTFCDEI                       V10 Oracle   UNKNOWN  C double=>Canonical double
OPTFCFIE                       V10 Oracle   UNKNOWN  Canonical float=>C float
OPTFCDIE                       V10 Oracle   UNKNOWN  Canonical double=>C double
OPTFCFI                        V10 Oracle   UNKNOWN  BINARY_FLOAT=>DTYIIN
OPTFCDI                        V10 Oracle   UNKNOWN  BINARY_DOUBLE=>DTYIIN
OPTFCIF                        V10 Oracle   UNKNOWN  DTYIIN=>BINARY_FLOAT
OPTFCID                        V10 Oracle   UNKNOWN  DTYIIN=>BINARY_DOUBLE
SUM                            V10 Oracle   NUMERIC  SUM(FLOAT) (Windows)
SUM                            V10 Oracle   NUMERIC  SUM(DOUBLE) (Windows)
AVG                            V10 Oracle   NUMERIC  AVG(FLOAT) (Windows)
AVG                            V10 Oracle   NUMERIC  AVG(DOUBLE) (Windows)
STDDEV                         V10 Oracle   NUMERIC  STDDEV(FLOAT) (Windows)
STDDEV                         V10 Oracle   NUMERIC  STDDEV(DOUBLE) (Windows)
OPTTLKC                        V10 Oracle   UNKNOWN  Internal Function to Compile a Like Pattern
SYS_XQ_NRNG                    V10 Oracle   UNKNOWN  SYS_XQ_NRNG
XMLQUERY                       V10 Oracle   UNKNOWN  XMLQUERY
SYS_XMLCONTAINS                V10 Oracle   UNKNOWN  SYS_XMLCONTAINS
SYS_OP_C2C                     V10 Oracle   UNKNOWN  SYS_OP_C2C
ORA_HASH                       V10 Oracle   NUMERIC  ORA_HASH

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTSPASSIGN                    V10 Oracle   UNKNOWN  =
OPTSPCELL                      V10 Oracle   UNKNOWN  SP cell Reference
OPTSPPRES                      V10 Oracle   UNKNOWN  IS PRESENT
PRESENTV                       V10 Oracle   ARG 2    PRESENTV
PRESENTNNV                     V10 Oracle   ARG 2    PRESENTNNV
OPTSPFORLOOP                   V10 Oracle   UNKNOWN  SP for FOR loop
OPTSPFORLIKE                   V10 Oracle   UNKNOWN  SP for LIKE loop
OPTSPFORINLIST                 V10 Oracle   UNKNOWN  SP for inlist Loop
CURRENTV                       V10 Oracle   UNKNOWN  CURRENTV
OPTSPISANY                     V10 Oracle   UNKNOWN  IS ANY
PREVIOUS                       V10 Oracle   UNKNOWN  PREVIOUS
OPTSPISPRESENT                 V10 Oracle   UNKNOWN  SP IS PRESENT
OPTSPALIAS                     V10 Oracle   UNKNOWN  Spreadsheet Alias
OPTTINLA                       V10 Oracle   UNKNOWN  inlist equality ANSI
OPTTINLO                       V10 Oracle   UNKNOWN  inlist equality ORACLE
OPTSPIS                        V10 Oracle   UNKNOWN  SP binary IS
OPTSPAIS                       V10 Oracle   UNKNOWN  SP binary ANSI IS
OPT521                         V10 Oracle   UNKNOWN  Unused
OPTRXLIKE                      V10 Oracle   UNKNOWN   REGEXP_LIKE
OPTRXNLIKE                     V10 Oracle   UNKNOWN   NOT REGEXP_LIKE
REGEXP_SUBSTR                  V10 Oracle   STRING    REGEXP_SUBSTR

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
REGEXP_INSTR                   V10 Oracle   NUMERIC   REGEXP_INSTR
REGEXP_REPLACE                 V10 Oracle   STRING    REGEXP_REPLACE
OPTRXCOMPILE                   V10 Oracle   UNKNOWN  Internal Function to Compile a Regexp Pattern
OPTCOLLCONS                    V10 Oracle   UNKNOWN  Collection Constructor
SYS_ET_BLOB_TO_IMAGE           V10 Oracle   UNKNOWN  SYS_ET_BLOB_TO_IMAGE
SYS_ET_IMAGE_TO_BLOB           V10 Oracle   UNKNOWN  SYS_ET_IMAGE_TO_BLOB
INSERTCHILDXML                 V10 Oracle   UNKNOWN  INSERTCHILDXML
OPT534                         V10 Oracle   UNKNOWN  Unused
SYS_ET_BFILE_TO_RAW            V10 Oracle   UNKNOWN  SYS_ET_BFILE_TO_RAW
SYS_ET_RAW_TO_BFILE            V10 Oracle   UNKNOWN  SYS_ET_RAW_TO_BFILE
OPTLRXLIKE                     V10 Oracle   UNKNOWN   REGEXP_LIKE
OPTLRXNLIKE                    V10 Oracle   UNKNOWN   NOT REGEXP_LIKE
OPTLRXSUBSTR                   V10 Oracle   STRING    REGEXP_SUBSTR
OPTLRXINSTR                    V10 Oracle   NUMERIC   REGEXP_INSTR
OPTLRXREPLACE                  V10 Oracle   STRING    REGEXP_REPLACE
TO_BINARY_DOUBLE               V10 Oracle   NUMERIC  TO_BINARY_DOUBLE
TO_BINARY_FLOAT                V10 Oracle   NUMERIC  TO_BINARY_FLOAT
TO_CHAR                        V10 Oracle   STRING   TO_CHAR
TO_CHAR                        V10 Oracle   STRING   TO_CHAR
OPTFCFSTCF                     V10 Oracle   UNKNOWN  BINARY_FLOAT=>CHAR With Constant Format
OPTFCDSTCF                     V10 Oracle   UNKNOWN  BINARY_DOUBLE=>CHAR With Constant Format

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
TO_BINARY_FLOAT                V10 Oracle   NUMERIC  TO_BINARY_FLOAT
TO_BINARY_DOUBLE               V10 Oracle   NUMERIC  TO_BINARY_DOUBLE
TO_NCHAR                       V10 Oracle   STRING   TO_NCHAR
TO_NCHAR                       V10 Oracle   STRING   TO_NCHAR
OPTFCSTFCF                     V10 Oracle   NUMERIC  TO_BINARY_FLOAT
OPTFCSTDCF                     V10 Oracle   NUMERIC  TO_BINARY_DOUBLE
OPTFFINF                       V10 Oracle   UNKNOWN   IS INFINITE
OPTFDINF                       V10 Oracle   UNKNOWN   IS INFINITE
OPTFFNAN                       V10 Oracle   UNKNOWN   IS NAN
OPTFDNAN                       V10 Oracle   UNKNOWN   IS NAN
OPTFFNINF                      V10 Oracle   UNKNOWN   IS NOT INFINITE
OPTFDNINF                      V10 Oracle   UNKNOWN   IS NOT INFINITE
OPTFFNNAN                      V10 Oracle   UNKNOWN   IS NOT NAN
OPTFDNNAN                      V10 Oracle   UNKNOWN   IS NOT NAN
NANVL                          V10 Oracle   NUMERIC  NANVL
NANVL                          V10 Oracle   NUMERIC  NANVL
OPTDM                          V10R2 Oracle UNKNOWN  Internal Data Mining Function
OPT682                         V10R2 Oracle UNKNOWN  Unused
PREDICTION                     V10R2 Oracle UNKNOWN  PREDICTION
PREDICTION_PROBABILITY         V10R2 Oracle UNKNOWN  PREDICTION_PROBABILITY
PREDICTION_COST                V10R2 Oracle UNKNOWN  PREDICTION_COST

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
PREDICTION_SET                 V10R2 Oracle UNKNOWN  PREDICTION_SET
PREDICTION_DETAILS             V10R2 Oracle UNKNOWN  PREDICTION_DETAILS
CLUSTER_ID                     V10R2 Oracle UNKNOWN  CLUSTER_ID
CLUSTER_PROBABILITY            V10R2 Oracle UNKNOWN  CLUSTER_PROBABILITY
CLUSTER_SET                    V10R2 Oracle UNKNOWN  CLUSTER_SET
FEATURE_ID                     V10R2 Oracle UNKNOWN  FEATURE_ID
FEATURE_VALUE                  V10R2 Oracle UNKNOWN  FEATURE_VALUE
FEATURE_SET                    V10R2 Oracle UNKNOWN  FEATURE_SET
LOBNVL                         V10R2 Oracle UNKNOWN  LOBNVL
OPTDMO                         V10R2 Oracle UNKNOWN  Internal Data Mining Function
XMLCAST                        V11R1 Oracle UNKNOWN  XMLCAST
XMLEXISTS2                     V11R1 Oracle UNKNOWN  XMLEXISTS2
XS_SYS_CONTEXT                 V11R1 Oracle UNKNOWN  XS_SYS_CONTEXT
SYS_ROW_DELTA                  V11R1 Oracle UNKNOWN  SYS_ROW_DELTA
SYS_GET_PRIVILEGES             V11R1 Oracle UNKNOWN  SYS_GET_PRIVILEGES
OPTXPATHOUT                    V11R1 Oracle UNKNOWN  VALUE
SYS_XMLTYPE2SQL                V11R1 Oracle UNKNOWN  SYS_XMLTYPE2SQL
OPTXLOBSNAP                    V11R1 Oracle UNKNOWN  SYS_OP_LOBSNAP
SYS_GET_ACLIDS                 V11R1 Oracle UNKNOWN  SYS_GET_ACLIDS
SYS_XMLT_2_SC                  V11R1 Oracle UNKNOWN  SYS_XMLT_2_SC
SYS_XQCASTABLEERRH             V11R1 Oracle UNKNOWN  SYS_XQCASTABLEERRH

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OPTXQCASTASNQ              V11R1 Oracle UNKNOWN  SYS_OPTXQCASTASNQ
OPTCSXUPD                      V11R1 Oracle UNKNOWN  SYS_OP_CSX_UPD
SYS_OP_CSX_PATCH               V11R1 Oracle UNKNOWN  SYS_OP_CSX_PATCH
XMLTOOBJECT                    V11R1 Oracle UNKNOWN  XMLTOOBJECT
OBJECTTOXML                    V11R1 Oracle UNKNOWN  OBJECTTOXML
OPTXMLTOREDO                   V11R1 Oracle UNKNOWN  XMLTOREDO
SYS_SYNRCIREDO                 V11R1 Oracle UNKNOWN  SYS_SYNRCIREDO
SYS_OP_COMBINED_HASH           V11R1 Oracle UNKNOWN  SYS_OP_COMBINED_HASH
SYS_OP_LOBLOC2ID               V11R1 Oracle UNKNOWN  SYS_OP_LOBLOC2ID
SYS_OP_LOBLOC2TYP              V11R1 Oracle UNKNOWN  SYS_OP_LOBLOC2TYP
SYS_OP_LOBLOC2BLOB             V11R1 Oracle UNKNOWN  SYS_OP_LOBLOC2BLOB
SYS_OP_LOBLOC2CLOB             V11R1 Oracle UNKNOWN  SYS_OP_LOBLOC2CLOB
SYS_OP_LOBLOC2NCLOB            V11R1 Oracle UNKNOWN  SYS_OP_LOBLOC2NCLOB
REGEXP_COUNT                   V11R1 Oracle UNKNOWN   REGEXP_COUNT
OPTLRXCOUNT                    V11R1 Oracle UNKNOWN   REGEXP_COUNT
XMLDIFF                        V11R1 Oracle UNKNOWN  XMLDIFF
XMLPATCH                       V11R1 Oracle UNKNOWN  XMLPATCH
SYS_OP_VERSION                 V11R1 Oracle UNKNOWN  SYS_OP_VERSION
SYS_XMLTRANSLATE               V11R1 Oracle UNKNOWN  SYS_XMLTRANSLATE
OPTDMGETO                      V11R1 Oracle UNKNOWN  Internal Data Mining Function: GET value
SYS_DM_RXFORM_NUM              V11R1 Oracle UNKNOWN  SYS_DM_RXFORM_NUM

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_DM_RXFORM_CHR              V11R1 Oracle UNKNOWN  SYS_DM_RXFORM_CHR
OPT793                         V11R1 Oracle UNKNOWN  Unused
PREDICTION_BOUNDS              V11R1 Oracle UNKNOWN  PREDICTION_BOUNDS
SYS_XMLLOCATOR_GETSVAL         V11R1 Oracle UNKNOWN  SYS_XMLLOCATOR_GETSVAL
SYS_OP_BLOOM_FILTER            V11R1 Oracle UNKNOWN  SYS_OP_BLOOM_FILTER
SYS_OP_PIVOT                   V11R1 Oracle UNKNOWN  SYS_OP_PIVOT
CO_AUTH_IND                    V11R1 Oracle UNKNOWN  CO_AUTH_IND
SYS_FILTER_ACLS                V11R1 Oracle UNKNOWN  SYS_FILTER_ACLS
OPTPVTIS                       V11R1 Oracle UNKNOWN  SYS_OP_PIVOT_IS
OPTPVTAIS                      V11R1 Oracle UNKNOWN  SYS_OP_PIVOT_IS
SYS_MKXMLATTR                  V11R1 Oracle UNKNOWN  SYS_MKXMLATTR
SYS_XMLNODEID_GETPTRID         V11R1 Oracle UNKNOWN  SYS_XMLNODEID_GETPTRID
NTH_VALUE                      V11R1 Oracle ARG 1    NTH_VALUE
LISTAGG                        V11R1 Oracle ARG 1    LISTAGG
LISTAGG                        V11R1 Oracle ARG 1    LISTAGG (window)
ORA_DST_AFFECTED               V11R1 Oracle UNKNOWN  ORA_DST_AFFECTED
ORA_DST_ERROR                  V11R1 Oracle UNKNOWN  ORA_DST_ERROR
ORA_DST_CONVERT                V11R1 Oracle UNKNOWN  ORA_DST_CONVERT
SYS_XQTOKENIZE                 V11R1 Oracle UNKNOWN  SYS_XQTOKENIZE
SYS_SC_2_XMLT                  V11R1 Oracle UNKNOWN  SYS_SC_2_XMLT
OPTGETXMLSCHEMATYPE            V11R1 Oracle UNKNOWN  SYS_GETXMLSCHEMATYPE

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_BLOOM_FILTER_LIST       V11R1 Oracle UNKNOWN  SYS_OP_BLOOM_FILTER_LIST
SYS_XQEXLOBVAL                 V11R1 Oracle UNKNOWN  SYS_XQEXLOBVAL
SYS_OPTLOBPRBSC                V11R1 Oracle UNKNOWN  SYS_LOBPRBSC
OPTCSXMERGE                    V11R1 Oracle UNKNOWN  SYS_OP_CSX_MERGE
SYS_XQFORMATNUM                V11R1 Oracle STRING   SYS_XQFORMATNUM
SYS_EXTPDTXT                   V11R1 Oracle UNKNOWN  SYS_EXTPDTXT
SYS_XMLINSTR                   V11R1 Oracle STRING   SYS_XMLINSTR
SYS_XQDURDIV                   V11R1 Oracle UNKNOWN  SYS_XQDURDIV
OPTDMGET                       V11R1 Oracle UNKNOWN  Internal Data Mining Function: GET value
SYS_OP_DV_CHECK                V11R1 Oracle UNKNOWN  SYS_OP_DV_CHECK
OPTCONSXMLFORCSX               V11R1 Oracle UNKNOWN  SYS_OP_XMLCONS_FOR_CSX
SYS_GETXTIVAL                  V11R1 Oracle UNKNOWN  SYS_GETXTIVAL
OPTDJS                         V6 Oracle    UNKNOWN  JULIAN=>STRING
OPTDIF                         V6 Oracle    UNKNOWN  STRING=>INPUT FORMAT
OPTDOF                         V6 Oracle    UNKNOWN  STRING=>OUTPUT FORMAT
OPTNTI                         V6 Oracle    UNKNOWN  NUMBER=>INTERNAL INTEGER
OPTCTZ                         V6 Oracle    UNKNOWN  DTYCHR=>DTYDTZ
OPTCDY                         V6 Oracle    UNKNOWN  DTYCHR=>DTYDYN
OPTNDY                         V6 Oracle    UNKNOWN  DTYNUM=>DTYDYN
OPTDPC                         V6 Oracle    UNKNOWN  DTYCHR=>DTYDPC
DUMP                           V6 Oracle    STRING   DUMP

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTTNS                         V6 Oracle    UNKNOWN  Nested Select
OPTDRO                         V6 Oracle    DATETYPE ROUND
TRUNC                          V6 Oracle    DATETYPE TRUNC
FLOOR                          V6 Oracle    NUMERIC  FLOOR
CEIL                           V6 Oracle    NUMERIC  CEIL
DECODE                         V6 Oracle    ARG 3    DECODE
LPAD                           V6 Oracle    STRING   LPAD
RPAD                           V6 Oracle    STRING   RPAD
OPTITN                         V6 Oracle    UNKNOWN  DTYIIN=>DTYNUM
POWER                          V6 Oracle    NUMERIC  POWER
SYS_OP_TPR                     V6 Oracle    UNKNOWN  Numeric Precision
TO_BINARY_FLOAT                V6 Oracle    NUMERIC  TO_BINARY_FLOAT
TO_NUMBER                      V6 Oracle    NUMERIC  TO_NUMBER
TO_BINARY_DOUBLE               V6 Oracle    NUMERIC  TO_BINARY_DOUBLE
TO_NUMBER                      V6 Oracle    NUMERIC  TO_NUMBER
INITCAP                        V6 Oracle    STRING   INITCAP
TRANSLATE                      V6 Oracle    STRING   TRANSLATE
LTRIM                          V6 Oracle    STRING   LTRIM
RTRIM                          V6 Oracle    STRING   RTRIM
GREATEST                       V6 Oracle    ARG 1    GREATEST
LEAST                          V6 Oracle    ARG 1    LEAST

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SQRT                           V6 Oracle    NUMERIC  SQRT
VARIANCE                       V6 Oracle    NUMERIC  VARIANCE
STDDEV                         V6 Oracle    NUMERIC  STDDEV
OPTLKO                         V6 Oracle    UNKNOWN   LIKE
RAWTOHEX                       V6 Oracle    STRING   RAWTOHEX
HEXTORAW                       V6 Oracle    BINARY   HEXTORAW
NVL2                           V6 Oracle    ARG 2    NVL2
LNNVL                          V6 Oracle    UNKNOWN  LNNVL
USERENV                        V6 Oracle    STRING   USERENV
MERGE$ACTIONS                  V6 Oracle    UNKNOWN  MERGE$ACTIONS
TBL$OR$IDX$PART$NUM            V6 Oracle    UNKNOWN  TBL$OR$IDX$PART$NUM
OPTTSTCF                       V6 Oracle    UNKNOWN  Internal TO_CHAR(NUMBER 'constant_format')
BITAND                         V6 Oracle    NUMERIC  BITAND
REVERSE                        V6 Oracle    UNKNOWN  REVERSE
SYS_OP_CEG                     V6 Oracle    UNKNOWN  SYS_OP_CEG
CONVERT                        V6 Oracle    STRING   CONVERT
REPLACE                        V6 Oracle    STRING   REPLACE
NLSSORT                        V6 Oracle    STRING   NLSSORT
OPTRTB                         V6 Oracle    UNKNOWN  DTYRID=>DTYBRI
OPTBTR                         V6 Oracle    UNKNOWN  DTYBRI=>DTYRID
OPTR2C                         V6 Oracle    UNKNOWN  DTYRID=>CHAR

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_COMP                    V6 Oracle    UNKNOWN  SYS_OP_COMP
SYS_OP_DECOMP                  V6 Oracle    UNKNOWN  SYS_OP_DECOMP
OPTCNVTLAB                     V6 Oracle    UNKNOWN  OPTCNVTLAB
SYS_OP_OPNSIZE                 V6 Oracle    UNKNOWN  SYS_OP_OPNSIZE
DATAOBJ_TO_PARTITION           V6 Oracle    UNKNOWN  DATA0BJ_TO_PARTITION
PART$NUM$INST                  V6 Oracle    UNKNOWN  PART$NUM$INST
OPTTUC                         V6 Oracle    UNKNOWN  Unused
>                              V6 Oracle    UNKNOWN  >
<                              V6 Oracle    UNKNOWN  <
>=                             V6 Oracle    UNKNOWN  >=
<=                             V6 Oracle    UNKNOWN  <=
=                              V6 Oracle    UNKNOWN  =
!=                             V6 Oracle    UNKNOWN  <>
OPTTIS                         V6 Oracle    ARG 1    INTERSECT
OPTTUN                         V6 Oracle    ARG 1    UNION
OPTTMI                         V6 Oracle    ARG 1    MINUS
OPTTAD                         V6 Oracle    NUMERIC  +
OPTTSU                         V6 Oracle    NUMERIC  -
OPTTMU                         V6 Oracle    NUMERIC  *
OPTTDI                         V6 Oracle    NUMERIC  /
OPTTNG                         V6 Oracle    NUMERIC  -

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
AVG                            V6 Oracle    ARG 1    AVG
SUM                            V6 Oracle    ARG 1    SUM
COUNT                          V6 Oracle    NUMERIC  COUNT
MIN                            V6 Oracle    ARG 1    MIN
MAX                            V6 Oracle    ARG 1    MAX
OPTDESC                        V6 Oracle    UNKNOWN   DESC
TO_NUMBER                      V6 Oracle    NUMERIC  TO_NUMBER
TO_CHAR                        V6 Oracle    STRING   TO_CHAR
NVL                            V6 Oracle    ARG 1    NVL
CHARTOROWID                    V6 Oracle    BINARY   CHARTOROWID
ROWIDTOCHAR                    V6 Oracle    STRING   ROWIDTOCHAR
OPTTLK                         V6 Oracle    UNKNOWN   LIKE
OPTTNK                         V6 Oracle    UNKNOWN   NOT LIKE
CONCAT                         V6 Oracle    STRING   ||
SUBSTR                         V6 Oracle    STRING   SUBSTR
LENGTH                         V6 Oracle    NUMERIC  LENGTH
INSTR                          V6 Oracle    NUMERIC  INSTR
LOWER                          V6 Oracle    STRING   LOWER
UPPER                          V6 Oracle    STRING   UPPER
ASCII                          V6 Oracle    NUMERIC  ASCII
CHR                            V6 Oracle    STRING   CHR

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SOUNDEX                        V6 Oracle    STRING   SOUNDEX
ROUND                          V6 Oracle    NUMERIC  ROUND
TRUNC                          V6 Oracle    NUMERIC  TRUNC
MOD                            V6 Oracle    NUMERIC  MOD
ABS                            V6 Oracle    NUMERIC  ABS
SIGN                           V6 Oracle    NUMERIC  SIGN
VSIZE                          V6 Oracle    NUMERIC  VSIZE
OPTTNU                         V6 Oracle    UNKNOWN   IS NULL
OPTTNN                         V6 Oracle    UNKNOWN   IS NOT NULL
OPTDAN                         V6 Oracle    DATETYPE +
OPTDSN                         V6 Oracle    DATETYPE -
OPTDSU                         V6 Oracle    NUMERIC  -
ADD_MONTHS                     V6 Oracle    DATETYPE ADD_MONTHS
MONTHS_BETWEEN                 V6 Oracle    NUMERIC  MONTHS_BETWEEN
TO_DATE                        V6 Oracle    DATETYPE TO_DATE
OPTDSY                         V6 Oracle    DATETYPE SYSDATE
LAST_DAY                       V6 Oracle    DATETYPE LAST_DAY
NEW_TIME                       V6 Oracle    DATETYPE NEW_TIME
NEXT_DAY                       V6 Oracle    DATETYPE NEXT_DAY
OPTDSD                         V6 Oracle    DATETYPE STRING=>DATE
OPTDDS                         V6 Oracle    STRING   DATE=>STRING

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTDSI                         V6 Oracle    UNKNOWN  STRING=>INTERNAL DATE
OPTDIS                         V6 Oracle    UNKNOWN  TO_CHAR
OPTDID                         V6 Oracle    UNKNOWN  INTERNAL DATE=>DATE
OPTDDI                         V6 Oracle    UNKNOWN  DATE=>INTERNAL DATE
OPTDJN                         V6 Oracle    UNKNOWN  JULIAN=>NUMBER
OPTDNJ                         V6 Oracle    UNKNOWN  JULIAN=>NUMBER
OPTDDJ                         V6 Oracle    UNKNOWN  DATE=>JULIAN
OPTDIJ                         V6 Oracle    UNKNOWN  INTERNAL DATE=>JULIAN
OPTPLS                         V71 Oracle   UNKNOWN  PLSQL Function
ATAN2                          V73 Oracle   NUMERIC  ATAN2
ATAN                           V73 Oracle   NUMERIC  ATAN
ASIN                           V73 Oracle   NUMERIC  ASIN
ACOS                           V73 Oracle   NUMERIC  ACOS
OPTOICSCNV                     V80 Oracle   UNKNOWN  SYS_OP_CSCONV
OPTDFNR                        V80 Oracle   UNKNOWN  Deferred Name Resolution
OPTBLCST                       V80 Oracle   UNKNOWN  BLOB Constructor
SYS_OPTXICMP                   V80 Oracle   UNKNOWN  SYS_OPTXICMP
SYS_OP_REF                     V80 Oracle   UNKNOWN  ADT REFerence
SYS_OP_ATG                     V80 Oracle   UNKNOWN  SYS_OP_ATG
OPTATS                         V80 Oracle   UNKNOWN  Attribute Set
SYS_OP_ADTCONS                 V80 Oracle   UNKNOWN  CONStructor

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_DRA                     V80 Oracle   UNKNOWN  ADT DeReference And Extract Attribute
SYS_OP_GUID                    V80 Oracle   UNKNOWN  SYS_OP_GUID
OPTNCR                         V80 Oracle   UNKNOWN  CURSOR
OPTOCHK                        V80 Oracle   UNKNOWN  Object Check
DEREF                          V80 Oracle   UNKNOWN  DEREF
SYS_OP_MAKEOID                 V80 Oracle   UNKNOWN  SYS_OP_MAKEOID
MAKE_REF                       V80 Oracle   BINARY   MAKE_REF
SYS_OP_NIX                     V80 Oracle   UNKNOWN  SYS_OP_NIX
SYS_OP_DUMP                    V80 Oracle   UNKNOWN  SYS_OP_DUMP
REFTOHEX                       V80 Oracle   BINARY   REFTOHEX
SYS_OP_VREF                    V80 Oracle   UNKNOWN  Create Variable-length REF
SYS_OP_TOSETID                 V80 Oracle   UNKNOWN  SYS_OP_TOSETID
OPTBNPT                        V80 Oracle   UNKNOWN  DTYBIN=>DTYNPT
OPTASNPT                       V80 Oracle   UNKNOWN  Assign NPT Values
OPTCCN                         V80 Oracle   UNKNOWN  Collection Constructor
OPTCAST                        V80 Oracle   UNKNOWN  CAST (expression AS type)
OPTLBC                         V80 Oracle   UNKNOWN  LOB Copy Constructor
OPTFCONS                       V80 Oracle   UNKNOWN  Fast CONStructor
OPTICMP                        V80 Oracle   UNKNOWN  Image CoMPare
OPTDGRF                        V80 Oracle   UNKNOWN   IS DANGLING
OPTNDGRF                       V80 Oracle   UNKNOWN   IS NOT DANGLING

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_R2O                     V80 Oracle   UNKNOWN  SYS_OP_R2O
EMPTY_BLOB                     V80 Oracle   BINARY   EMPTY_BLOB
EMPTY_CLOB                     V80 Oracle   BINARY   EMPTY_CLOB
OPTCOERCE                      V80 Oracle   UNKNOWN  Coercion
OPTCSIV                        V80 Oracle   UNKNOWN  Coerce Single-Insert Value
OPTSM2CM                       V80 Oracle   UNKNOWN  Segmented Mem To Contig. Mem
SYS_OP_RMTD                    V80 Oracle   UNKNOWN  SYS_OP_RMTD
SYS_OP_RDTM                    V80 Oracle   UNKNOWN  Ref Conversion - Disk to Memory Format
SYS_OP_OIDVALUE                V80 Oracle   UNKNOWN  SYS_OP_OIDVALUE
OPTOLCIC                       V80 Oracle   UNKNOWN  Out-Of-Line Collection Image Constructor
BFILENAME                      V80 Oracle   BINARY   BFILENAME
CSCONVERT                      V80 Oracle   UNKNOWN  CSCONVERT
NLS_CHARSET_NAME               V80 Oracle   STRING   NLS_CHARSET_NAME
NLS_CHARSET_ID                 V80 Oracle   NUMERIC  NLS_CHARSET_ID
OPTLCNV                        V80 Oracle   UNKNOWN  Locator CoNVersion
SYS_OP_LSVI                    V80 Oracle   UNKNOWN  SYS_OP_LSVI
OPTCIOUT                       V80 Oracle   UNKNOWN  VALUE
NLS_CHARSET_DECL_LEN           V80 Oracle   NUMERIC  NLS_CHARSET_DECL_LEN
OPTCLCST                       V80 Oracle   UNKNOWN  CLOB and NCLOB Constructor
OPTUOP                         V81 Oracle   UNKNOWN  User-Defined Operator
TRIM                           V81 Oracle   STRING   TRIM

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
TRIM                           V81 Oracle   STRING   TRIM
TRIM                           V81 Oracle   STRING   TRIM
SYS_OP_RPB                     V81 Oracle   UNKNOWN  SYS_OP_RPB
SYS_OP_TRTB                    V81 Oracle   UNKNOWN  SYS_OP_TRTB
SYS_OP_DESCEND                 V81 Oracle   UNKNOWN  SYS_OP_DESCEND
SYS_OP_UNDESCEND               V81 Oracle   UNKNOWN  SYS_OP_UNDESCEND
OPTXTRCT_XQUERY                V81 Oracle   UNKNOWN  EXTRACT
OPTADIX                        V81 Oracle   UNKNOWN  SYS_OP_ADIX
OPTREW                         V81 Oracle   UNKNOWN  Compile-time REWrite
OPTDCC                         V81 Oracle   UNKNOWN  Ddynamic Collection Constructor
SYS_OP_MAP_NONNULL             V81 Oracle   UNKNOWN  SYS_OP_MAP_NONNULL
OPTVFIL                        V81 Oracle   UNKNOWN  307
OPTC2TM                        V81 Oracle   UNKNOWN  TO_TIME
OPTC2TMZ                       V81 Oracle   UNKNOWN  TO_TIME_TZ
OPTC2ST                        V81 Oracle   UNKNOWN  TO_TIMESTAMP
OPTC2STZ                       V81 Oracle   UNKNOWN  TO_TIMESTAMP_TZ
OPTC2IYM                       V81 Oracle   UNKNOWN  TO_YMINTERVAL
OPTC2IDS                       V81 Oracle   UNKNOWN  TO_DSINTERVAL
OPTTM2C                        V81 Oracle   UNKNOWN  TIME=>STRING
OPTTMZ2C                       V81 Oracle   UNKNOWN  TIME WITH TIME ZONE=>STRING
OPTST2C                        V81 Oracle   UNKNOWN  TIMESTAMP=>STRING

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTSTZ2C                       V81 Oracle   UNKNOWN  TIMESTAMP WITH TIME ZONE=>STRING
OPTIYM2C                       V81 Oracle   UNKNOWN  INTERVAL YEAR TO MONTH=>STRING
OPTIDS2C                       V81 Oracle   UNKNOWN  INTERVAL DAY TO SECOND to string
OPTDIPR                        V81 Oracle   UNKNOWN  Check Datetime/Interval Precisions
SYS_GUID                       V81 Oracle   BINARY   SYS_GUID
OPTXTRCT                       V81 Oracle   UNKNOWN  EXTRACT
OPTITME                        V81 Oracle   UNKNOWN  Internal TIME=>External
OPTTMEI                        V81 Oracle   UNKNOWN  External TIME=>Internal
OPTITTZ                        V81 Oracle   UNKNOWN  Internal TIME WTZ=>External
OPTTTZI                        V81 Oracle   UNKNOWN  External TIME WTZ=>Internal
OPTISTM                        V81 Oracle   UNKNOWN  Internal TIMESTAMP=>External
OPTSTMI                        V81 Oracle   UNKNOWN  External TIMESTAMP=>Internal
OPTISTZ                        V81 Oracle   UNKNOWN  Internal TIMESTAMP WTZ=>External
OPTSTZI                        V81 Oracle   UNKNOWN  External TIMESTAMP WTZ=>Internal
OPTIIYM                        V81 Oracle   UNKNOWN  Internal INTERVAL YM=>External
OPTIYMI                        V81 Oracle   UNKNOWN  External INTERVAL YM=>Internal
OPTIIDS                        V81 Oracle   UNKNOWN  Internal INTERVAL DS=>External
OPTIDSI                        V81 Oracle   UNKNOWN  External INTERVAL DS=>Internal
OPTITMES                       V81 Oracle   UNKNOWN  TO_CHAR
OPTITTZS                       V81 Oracle   UNKNOWN  TO_CHAR
OPTISTMS                       V81 Oracle   UNKNOWN  TO_CHAR

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTISTZS                       V81 Oracle   UNKNOWN  TO_CHAR
OPTIIYMS                       V81 Oracle   UNKNOWN  TO_CHAR
OPTIIDSS                       V81 Oracle   UNKNOWN  TO_CHAR
OPTLDIIF                       V81 Oracle   UNKNOWN  STRING=>Internal Format (for input)
OPTLDIOF                       V81 Oracle   UNKNOWN  STRING=>Internal Format (for output)
OPTDIADD                       V81 Oracle   UNKNOWN  DATETIME + INTERVAL
OPTDISUB                       V81 Oracle   UNKNOWN  DATETIME - INTERVAL
OPTDDSUB                       V81 Oracle   UNKNOWN  DATETIME - DATETIME
OPTIIADD                       V81 Oracle   UNKNOWN  INTERVAL + INTERVAL
OPTIISUB                       V81 Oracle   UNKNOWN  INTERVAL - INTERVAL
OPTINMUL                       V81 Oracle   UNKNOWN  INTERVAL * NUMBER
OPTINDIV                       V81 Oracle   UNKNOWN  interval / number
OPTCHGTZ                       V81 Oracle   UNKNOWN   AT
OPTOVLPS                       V81 Oracle   UNKNOWN  OVERLAPS
OPTOVLPC                       V81 Oracle   UNKNOWN  OVERLAPS
OPTDCAST                       V81 Oracle   UNKNOWN  Casting Between Datetime Types
OPTINTN                        V81 Oracle   UNKNOWN  DTYINT=>DTYNUM
OPTNTIN                        V81 Oracle   UNKNOWN  DTYNUM=>DTYINT
CAST                           V81 Oracle   ARG 2    CAST
SYS_CONTEXT                    V81 Oracle   UNKNOWN  SYS_CONTEXT
SYS_OP_IIX                     V81 Oracle   UNKNOWN  IMAGE=>IMAGE

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_NII                     V81 Oracle   UNKNOWN  Get Null Image From Image
GROUPING                       V81 Oracle   NUMERIC  GROUPING
OPTTLC                         V81 Oracle   UNKNOWN  Truncate LONG To CHAR
TO_LOB                         V81 Oracle   BINARY   TO_LOB
SYS_OP_MSR                     V81 Oracle   UNKNOWN  SYS_OP_MSR
SYS_OP_CSR                     V81 Oracle   UNKNOWN  SYS_OP_CSR
OPTIDN                         V81 Oracle   UNKNOWN  Identity
OPTIAND                        V816 Oracle  UNKNOWN  IAND
OPTIOR                         V816 Oracle  UNKNOWN  IOR
OPTMKNULL                      V816 Oracle  UNKNOWN  MKNULL
OPTC2ITZ                       V816 Oracle  UNKNOWN  TSITZ<==>CHAR
OPTITZ2C2                      V816 Oracle  UNKNOWN  Array TSITZ=>CHAR
OPTITZ2C1                      V816 Oracle  UNKNOWN  TO_CHAR
OPTSRCSE                       V816 Oracle  UNKNOWN  Searched Case Expression
OPTAND                         V816 Oracle  UNKNOWN  AND
OPTOR                          V816 Oracle  UNKNOWN  OR
FROM_TZ                        V816 Oracle  DATETYPE FROM_TZ
SYS_CONNECT_BY_PATH            V816 Oracle  STRING   SYS_CONNECT_BY_PATH
OPTNTUB4                       V816 Oracle  UNKNOWN  DTYNUM=>DTYUB4
OPTUB4TN                       V816 Oracle  UNKNOWN  DTYUB4=>DTYNUM
OPTCIDN                        V816 Oracle  UNKNOWN  Compile Time Identity Function

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTT2TTZ1                      V816 Oracle  UNKNOWN  Struct Time=>Arr. Time with TZ
OPTT2TTZ2                      V816 Oracle  UNKNOWN  Struct Time=>Struct Time with TZ
OPTTTZ2T1                      V816 Oracle  UNKNOWN  Struct Time with TZ=>Arr. Time
OPTTTZ2T2                      V816 Oracle  UNKNOWN  Struct Time with TZ=>Struct Time
OPTTS2TSTZ1                    V816 Oracle  UNKNOWN  Struct Timestamp=>Arr. Timestamp with TZ
OPTTS2TSTZ2                    V816 Oracle  UNKNOWN  Struct Timestamp=>Struct Timestamp with TZ
OPTTSTZ2TS1                    V816 Oracle  UNKNOWN  Struct Timestamp with TZ=>Arr Timestamp
OPTTSTZ2TS2                    V816 Oracle  UNKNOWN  Struct Timestamp with TZ=>Struct Timestamp
SUM                            V816 Oracle  NUMERIC  SUM
AVG                            V816 Oracle  NUMERIC  AVG
COUNT                          V816 Oracle  NUMERIC  COUNT
VARIANCE                       V816 Oracle  NUMERIC  VARIANCE
STDDEV                         V816 Oracle  NUMERIC  STDDEV
MIN                            V816 Oracle  ARG 1    MIN
MAX                            V816 Oracle  ARG 1    MAX
FIRST_VALUE                    V816 Oracle  ARG 1    FIRST_VALUE
LAST_VALUE                     V816 Oracle  ARG 1    LAST_VALUE
LAG                            V816 Oracle  ARG 1    LAG
LEAD                           V816 Oracle  ARG 1    LEAD
RANK                           V816 Oracle  NUMERIC  RANK
DENSE_RANK                     V816 Oracle  NUMERIC  DENSE_RANK

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
CUME_DIST                      V816 Oracle  UNKNOWN  Window Percentile
NTILE                          V816 Oracle  NUMERIC  NTILE
RATIO_TO_REPORT                V816 Oracle  NUMERIC  RATIO_TO_REPORT
ROW_NUMBER                     V816 Oracle  NUMERIC  ROW_NUMBER
OPTWNOBY                       V816 Oracle  UNKNOWN  ORDER BY Pseudo-Function for Window
OPTWNPBY                       V816 Oracle  UNKNOWN  PARTITION BY Pseudo-Function for Window
OPT335                         V816 Oracle  UNKNOWN  UNUSED
OPTDESNL                       V816 Oracle  UNKNOWN   DESC NULLS LAST
OPTASCNF                       V816 Oracle  UNKNOWN   ASC NULLS FIRST
COVAR_POP                      V816 Oracle  NUMERIC  COVAR_POP
COVAR_SAMP                     V816 Oracle  NUMERIC  COVAR_SAMP
CORR                           V816 Oracle  NUMERIC  CORR
REGR_SLOPE                     V816 Oracle  NUMERIC  REGR_SLOPE
REGR_INTERCEPT                 V816 Oracle  NUMERIC  REGR_INTERCEPT
REGR_COUNT                     V816 Oracle  NUMERIC  REGR_COUNT
REGR_R2                        V816 Oracle  NUMERIC  REGR_R2
REGR_AVGX                      V816 Oracle  NUMERIC  REGR_AVGX
REGR_AVGY                      V816 Oracle  NUMERIC  REGR_AVGY
REGR_SXX                       V816 Oracle  NUMERIC  REGR_SXX
REGR_SYY                       V816 Oracle  NUMERIC  REGR_SYY
REGR_SXY                       V816 Oracle  NUMERIC  REGR_SXY

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
VAR_POP                        V816 Oracle  NUMERIC  VAR_POP
STDDEV_POP                     V816 Oracle  NUMERIC  STDDEV_POP
VAR_SAMP                       V816 Oracle  NUMERIC  VAR_SAMP
STDDEV_SAMP                    V816 Oracle  NUMERIC  STDDEV_SAMP
OPTDAT2TS1                     V816 Oracle  UNKNOWN  Srray Date=>Array Timestamp
OPTDAT2TS2                     V816 Oracle  UNKNOWN  Struct DATE=>Struct TIMESTAMP
OPTTS2DAT1                     V816 Oracle  UNKNOWN  array TIMESTAMP=>Array DATE
OPTTS2DAT2                     V816 Oracle  UNKNOWN  Struct TIMESTAMP=>Struct DATE
SESSIONTIMEZONE                V816 Oracle  DATETYPE SESSIONTIMEZONE
OPTNTUB8                       V816 Oracle  UNKNOWN  DTYNUM=>DTYUB8
OPTUB8TN                       V816 Oracle  UNKNOWN  DTYUB8=>DTYNUM
PERCENT_RANK                   V816 Oracle  NUMERIC  Window PERCENT_RANK
OPTITZS2A                      V816 Oracle  UNKNOWN  TS ITZ Struct=>Array
OPTITZA2S                      V816 Oracle  UNKNOWN  TS ITZ Array=>Struct
OPTITZ2TSTZ                    V816 Oracle  UNKNOWN  Struct TSITZ=>Struct TSTZ
OPTTSTZ2ITZ                    V816 Oracle  UNKNOWN  Struct TSTZ=>Struct TSITZ
OPTITZ2TS                      V816 Oracle  UNKNOWN  Struct TSITZ=>Struct TS
OPTTS2ITZ                      V816 Oracle  UNKNOWN  Struct TS=>Struct TSITZ
TO_TIME                        V816 Oracle  UNKNOWN  TO_TIME
TO_TIME_TZ                     V816 Oracle  UNKNOWN  TO_TIME_TZ
TO_TIMESTAMP                   V816 Oracle  DATETYPE TO_TIMESTAMP

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
TO_TIMESTAMP_TZ                V816 Oracle  DATETYPE TO_TIMESTAMP_TZ
TO_YMINTERVAL                  V816 Oracle  DATETYPE TO_YMINTERVAL
TO_DSINTERVAL                  V816 Oracle  DATETYPE TO_DSINTERVAL
NUMTOYMINTERVAL                V816 Oracle  UNKNOWN  NUMTOYMINTERVAL
NUMTODSINTERVAL                V816 Oracle  UNKNOWN  NUMTODSINTERVAL
SYS_EXTRACT_UTC                V816 Oracle  DATETYPE SYS_EXTRACT_UTC
SYS_OP_ITR                     V816 Oracle  UNKNOWN  Image TRansformation
SYS_OP_BIN2ADT                 V82 Oracle   UNKNOWN  BIN=>ADT
SYS_OP_DISTINCT                V82 Oracle   UNKNOWN  SYS_OP_DISTINCT
OPTSMCSE                       V82 Oracle   UNKNOWN  Simple Case Expression
NULLIF                         V82 Oracle   ARG 1    NULLIF
COALESCE                       V82 Oracle   ARG 1    COALESCE
OPTLLEN                        V82 Oracle   NUMERIC  LENGTH
OPTLLENB                       V82 Oracle   NUMERIC  LENGTHB
OPTLSBS                        V82 Oracle   UNKNOWN  SUBSTR
OPTLSBSB                       V82 Oracle   UNKNOWN  SUBSTRB
OPTLINS                        V82 Oracle   NUMERIC  INSTR
OPTLINSB                       V82 Oracle   NUMERIC  INSTRB
OPTLCAT                        V82 Oracle   UNKNOWN  ||
OPTLLPD                        V82 Oracle   UNKNOWN  LPAD
OPTLRPD                        V82 Oracle   UNKNOWN  RPAD

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTLLTR                        V82 Oracle   UNKNOWN  LTRIM
OPTLRTR                        V82 Oracle   UNKNOWN  RTRIM
OPTLTRM                        V82 Oracle   UNKNOWN  TRIM
OPTLLOW                        V82 Oracle   UNKNOWN  LOWER
OPTLUPR                        V82 Oracle   UNKNOWN  UPPER
OPTLNLOW                       V82 Oracle   UNKNOWN  NLS_LOWER
OPTLNUPR                       V82 Oracle   UNKNOWN  NLS_UPPER
OPTLNVL                        V82 Oracle   UNKNOWN  NVL
OPTLLIK                        V82 Oracle   UNKNOWN   LIKE
OPTLNLIK                       V82 Oracle   UNKNOWN   NOT LIKE
OPTLREPL                       V82 Oracle   UNKNOWN  REPLACE
SYS_OP_CL2C                    V82 Oracle   UNKNOWN  SYS_OP_CL2C
SYS_OP_BL2R                    V82 Oracle   UNKNOWN  SYS_OP_BL2R
PERCENTILE_CONT                V82 Oracle   NUMERIC  PERCENTILE_CONT
PERCENTILE_DISC                V82 Oracle   NUMERIC  PERCENTILE_DISC
RANK                           V82 Oracle   NUMERIC  RANK
DENSE_RANK                     V82 Oracle   NUMERIC  DENSE_RANK
PERCENT_RANK                   V82 Oracle   NUMERIC  PERCENT_RANK
CUME_DIST                      V82 Oracle   NUMERIC  CUME_DIST
OPTFSTLST                      V82 Oracle   UNKNOWN  First/Last Function
OPTAGGOBY                      V82 Oracle   UNKNOWN  Pseudo Function for Ordered Aggregates

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
WIDTH_BUCKET                   V82 Oracle   NUMERIC  WIDTH_BUCKET
RANKM                          V82 Oracle   NUMERIC  RANKM
DENSE_RANKM                    V82 Oracle   NUMERIC  DENSE_RANKM
PERCENT_RANKM                  V82 Oracle   NUMERIC  PERCENT_RANKM
CUME_DISTM                     V82 Oracle   UNKNOWN  CUME_DISTM
FIRSTM                         V82 Oracle   UNKNOWN  FIRSTM
PERCENTILE_CONT                V82 Oracle   NUMERIC  PERCENTILE_CONT
PERCENTILE_DISC                V82 Oracle   NUMERIC  PERCENTILE_DISC
OPTWNFSTLST                    V82 Oracle   UNKNOWN  Reporting First/Last
SYS_OP_VECOR                   V82 Oracle   UNKNOWN  SYS_OP_VECOR
SYS_OP_VECXOR                  V82 Oracle   UNKNOWN  SYS_OP_VECXOR
SYS_OP_VECAND                  V82 Oracle   UNKNOWN  SYS_OP_VECAND
GROUPING_ID                    V82 Oracle   NUMERIC  GROUPING_ID
GROUP_ID                       V82 Oracle   NUMERIC  GROUP_ID
OPTWNUAG                       V82 Oracle   UNKNOWN  User-defined Aggregate Window Function
SYS_XMLGEN                     V82 Oracle   UNKNOWN  SYS_XMLGEN
EXTRACT                        V82 Oracle   UNKNOWN  EXTRACT
SYS_DBURIGEN                   V82 Oracle   UNKNOWN  SYS_DBURIGEN
TO_CLOB                        V82 Oracle   STRING   TO_CLOB
TO_NCLOB                       V82 Oracle   STRING   TO_NCLOB
SYS_MAKEXML                    V82 Oracle   UNKNOWN  SYS_MAKEXML

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_UMAKEXML                   V82 Oracle   UNKNOWN  SYS_UMAKEXML
SYS_XQEXTRREF                  V82 Oracle   UNKNOWN  SYS_XQEXTRREF
OPTLICSCNVTST                  V82 Oracle   NUMERIC  SYS_OP_CSCONVTEST
BIN_TO_NUM                     V82 Oracle   NUMERIC  BIN_TO_NUM
SYS_OP_NUMTORAW                V82 Oracle   UNKNOWN  SYS_OP_NUMTORAW
SYS_OP_RAWTONUM                V82 Oracle   UNKNOWN  SYS_OP_RAWTONUM
SYS_OP_GROUPING                V82 Oracle   UNKNOWN  SYS_OP_GROUPING
OPTCELEM                       V82 Oracle   UNKNOWN  Collection ELEMent
OPTDOT                         V82 Oracle   UNKNOWN  Operator for DOTted Notation
SYS_AUDIT                      V82 Oracle   UNKNOWN  SYS_AUDIT
OPTPCONS                       V82 Oracle   UNKNOWN  Polymorphic Constructor
OPTUAG                         V82 Oracle   UNKNOWN  User-defined Aggregate
OPT441                         V82 Oracle   UNKNOWN  Unused
OPT442                         V82 Oracle   UNKNOWN  Unused
TZ_OFFSET                      V82 Oracle   UNKNOWN  TZ_OFFSET
ADJ_DATE                       V82 Oracle   UNKNOWN  ADJ_DATE
OPTUNSED445                    V82 Oracle   UNKNOWN  Unused
OPTTFD                         V82 Oracle   UNKNOWN  Functional Dependency
OPTTFDF                        V82 Oracle   UNKNOWN  Functional Dependency Foreign
ROWIDTONCHAR                   V82 Oracle   STRING   ROWIDTONCHAR
TO_NCHAR                       V82 Oracle   STRING   TO_NCHAR

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
RAWTONHEX                      V82 Oracle   STRING   RAWTONHEX
NCHR                           V82 Oracle   STRING   NCHR
SYS_OP_LBID                    V82 Oracle   UNKNOWN  SYS_OP_LBID
OPTOP2C                        V82 Oracle   UNKNOWN  Opaque Type=>CHAR
OPTC2OP                        V82 Oracle   UNKNOWN  CHAR=>Opaque Type
COMPOSE                        V82 Oracle   STRING   COMPOSE
DECOMPOSE                      V82 Oracle   STRING   DECOMPOSE
ASCIISTR                       V82 Oracle   STRING   ASCIISTR
UNISTR                         V82 Oracle   STRING   UNISTR
LENGTH2                        V82 Oracle   NUMERIC  LENGTH2
LENGTH4                        V82 Oracle   NUMERIC  LENGTH4
LENGTHC                        V82 Oracle   NUMERIC  LENGTHC
INSTR2                         V82 Oracle   NUMERIC  INSTR2
INSTR4                         V82 Oracle   NUMERIC  INSTR4
INSTRC                         V82 Oracle   NUMERIC  INSTRC
SUBSTR2                        V82 Oracle   STRING   SUBSTR2
SUBSTR4                        V82 Oracle   STRING   SUBSTR4
SUBSTRC                        V82 Oracle   STRING   SUBSTRC
OPTLIK2                        V82 Oracle   UNKNOWN   LIKE2
OPTLIK2N                       V82 Oracle   UNKNOWN   NOT LIKE2
OPTLIK2E                       V82 Oracle   UNKNOWN   LIKE2

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
OPTLIK2NE                      V82 Oracle   UNKNOWN   NOT LIKE2
OPTLIK4                        V82 Oracle   UNKNOWN   LIKE4
OPTLIK4N                       V82 Oracle   UNKNOWN   NOT LIKE4
OPTLIK4E                       V82 Oracle   UNKNOWN   LIKE4
OPTLIK4NE                      V82 Oracle   UNKNOWN   NOT LIKE4
OPTLIKC                        V82 Oracle   UNKNOWN   LIKEC
OPTLIKCN                       V82 Oracle   UNKNOWN   NOT LIKEC
OPTLIKCE                       V82 Oracle   UNKNOWN   LIKEC
OPTLIKCNE                      V82 Oracle   UNKNOWN   NOT LIKEC
SYS_OP_VECBIT                  V82 Oracle   UNKNOWN  SYS_OP_VECBIT
OPTNISTYP                      V82 Oracle   UNKNOWN  IS NOT OF TYPE
SYS_OP_NICOMBINE               V82 Oracle   UNKNOWN  SYS_OP_NICOMBINE
SYS_OP_NIEXTRACT               V82 Oracle   UNKNOWN  SYS_OP_NIEXTRACT
SYS_OP_VVD                     V82 Oracle   UNKNOWN  SYS_OP_VVD
OPTLCNVT                       V82 Oracle   UNKNOWN  CONVERT
OPTOPASN                       V82 Oracle   UNKNOWN  OPaque type ASsign
OPTOBY                         V82 Oracle   UNKNOWN  Pseudo Function for ORDER BY
SYS_XQEXTRACT                  V82 Oracle   UNKNOWN  SYS_XQEXTRACT
SYS_PXQEXTRACT                 V82 Oracle   UNKNOWN  SYS_PXQEXTRACT
OPTTREAT                       V82 Oracle   UNKNOWN  TREAT
OPTISTYPE                      V82 Oracle   UNKNOWN  IS OF TYPE

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_TYPEID                     V82 Oracle   UNKNOWN  SYS_OP_MST
SYS_OP_ADT2BIN                 V82 Oracle   UNKNOWN  ADT=>BIN
OPTXMLELEMENT                  V92 Oracle   UNKNOWN  XMLELEMENT
SYS_XMLANALYZE                 V92 Oracle   UNKNOWN  REWRITEANALYS
OPTXMLCOLELEM                  V92 Oracle   UNKNOWN  XMLFOREST
UPDATEXML                      V92 Oracle   UNKNOWN  UPDATEXML
EXISTSNODE                     V92 Oracle   UNKNOWN  EXISTSNODE
EXTRACTVALUE                   V92 Oracle   UNKNOWN  EXTRACTVALUE
XMLTRANSFORM                   V92 Oracle   UNKNOWN  XMLTRANSFORM
TO_BLOB                        V92 Oracle   UNKNOWN  TO_BLOB
OPTXMLPARSE                    V92 Oracle   UNKNOWN  XMLPARSE
SYS_XMLCONV                    V92 Oracle   UNKNOWN  SYS_XMLCONV
SYS_OP_PAR                     V92 Oracle   UNKNOWN  SYS_OP_PAR
SYS_OP_PARGID                  V92 Oracle   UNKNOWN  SYS_OP_PARGID
SYS_OP_LVL                     V92 Oracle   UNKNOWN  SYS_OP_LVL
SYS_OP_COUNTCHG                V92 Oracle   NUMERIC  SYS_OP_COUNTCHG
XMLISVALID                     V92 Oracle   UNKNOWN  XMLISVALID
SYS_DOM_COMPARE                V92 Oracle   UNKNOWN  SYS_DOM_COMPARE
XMLCONCAT                      V92 Oracle   UNKNOWN  XMLCONCAT
SYS_OP_ALSCRVAL                V92 Oracle   UNKNOWN  SYS_OP_ALEXPCOL
OPTALANYCONS                   V92 Oracle   UNKNOWN  Anydata-LOB: Anydata Constructor

NAME                           VERSION      DATATYPE DESCR
------------------------------ ------------ -------- --------------------------------------------------------------------------------
SYS_OP_CONVERT                 V92 Oracle   UNKNOWN  SYS_OP_CONVERT
OPTLICONVERT                   V92 Oracle   UNKNOWN  SYS_OP_CONVERT
SYS_OP_PAR_1                   V92 Oracle   UNKNOWN  SYS_OP_PAR
SYS_OP_PARGID_1                V92 Oracle   UNKNOWN  SYS_OP_PARGID
SYS_CHECKACL                   V92 Oracle   UNKNOWN  SYS_CHECKACL
SYS_XQCONCAT                   V92 Oracle   UNKNOWN  SYS_XQCONCAT
XMLISNODE                      V92 Oracle   UNKNOWN  XMLISNODE
SYS_XQEXVAL                    V92 Oracle   UNKNOWN  SYS_XQEXVAL
SYS_XQSEQ2CON                  V92 Oracle   UNKNOWN  SYS_XQSEQ2CON
SYS_XQCON2SEQ                  V92 Oracle   UNKNOWN  SYS_XQCON2SEQ
SYS_XQFNBOOL                   V92 Oracle   UNKNOWN  SYS_XQFNBOOL
SYS_XMLEXNSURI                 V92 Oracle   UNKNOWN  SYS_XMLEXNSURI
SYS_XQFNLNAME                  V92 Oracle   UNKNOWN  SYS_XQFNLNAME
SYS_XQFNNSURI                  V92 Oracle   UNKNOWN  SYS_XQFNNSURI
SYS_XQFNPREDTRUTH              V92 Oracle   UNKNOWN  SYS_XQFNPREDTRUTH
SYS_OP_CSCONVTEST              V92 Oracle   NUMERIC  SYS_OP_CSCONVTEST
SYS_OP_CSCONV                  V92 Oracle   UNKNOWN  SYS_OP_CSCONV
OPTLICSCNV                     V92 Oracle   UNKNOWN  SYS_OP_CSCONV
OPTXMLCOLATTVAL                V92 Oracle   UNKNOWN  XMLCOLATTVAL

921 rows selected

Script:Logfile Switch Frequency Map

该脚本可以用于列出Oracle日志文件切换的频率图:


REM Log Switch Frequency Map

col Day for a10
col Date for a10
set linesize 80


SELECT trunc(first_time) "Date",
       to_char(first_time, 'Dy') "Day",
       count(1) "Total",
       SUM(decode(to_char(first_time, 'hh24'), '00', 1, 0)) "h0",
       SUM(decode(to_char(first_time, 'hh24'), '01', 1, 0)) "h1",
       SUM(decode(to_char(first_time, 'hh24'), '02', 1, 0)) "h2",
       SUM(decode(to_char(first_time, 'hh24'), '03', 1, 0)) "h3",
       SUM(decode(to_char(first_time, 'hh24'), '04', 1, 0)) "h4",
       SUM(decode(to_char(first_time, 'hh24'), '05', 1, 0)) "h5",
       SUM(decode(to_char(first_time, 'hh24'), '06', 1, 0)) "h6",
       SUM(decode(to_char(first_time, 'hh24'), '07', 1, 0)) "h7",
       SUM(decode(to_char(first_time, 'hh24'), '08', 1, 0)) "h8",
       SUM(decode(to_char(first_time, 'hh24'), '09', 1, 0)) "h9",
       SUM(decode(to_char(first_time, 'hh24'), '10', 1, 0)) "h10",
       SUM(decode(to_char(first_time, 'hh24'), '11', 1, 0)) "h11",
       SUM(decode(to_char(first_time, 'hh24'), '12', 1, 0)) "h12",
       SUM(decode(to_char(first_time, 'hh24'), '13', 1, 0)) "h13",
       SUM(decode(to_char(first_time, 'hh24'), '14', 1, 0)) "h14",
       SUM(decode(to_char(first_time, 'hh24'), '15', 1, 0)) "h15",
       SUM(decode(to_char(first_time, 'hh24'), '16', 1, 0)) "h16",
       SUM(decode(to_char(first_time, 'hh24'), '17', 1, 0)) "h17",
       SUM(decode(to_char(first_time, 'hh24'), '18', 1, 0)) "h18",
       SUM(decode(to_char(first_time, 'hh24'), '19', 1, 0)) "h19",
       SUM(decode(to_char(first_time, 'hh24'), '20', 1, 0)) "h20",
       SUM(decode(to_char(first_time, 'hh24'), '21', 1, 0)) "h21",
       SUM(decode(to_char(first_time, 'hh24'), '22', 1, 0)) "h22",
       SUM(decode(to_char(first_time, 'hh24'), '23', 1, 0)) "h23",
       round(count(1) / 24, 2) "Avg"
  FROM V$log_history
 group by trunc(first_time), to_char(first_time, 'Dy')
 Order by 1
/

Script:Tablespace Report

该脚本用以汇总表空间使用情况报告:

REM tablespace report


set linesize 200


select a.tablespace_name,
       round(a.bytes_alloc / 1024 / 1024) megs_alloc,
       round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,
       round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,
       round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_Free,
       100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,
       round(maxbytes / 1048576) Max
  from (select f.tablespace_name,
               sum(f.bytes) bytes_alloc,
               sum(decode(f.autoextensible, 'YES', f.maxbytes, 'NO', f.bytes)) maxbytes
          from dba_data_files f
         group by tablespace_name) a,
       (select f.tablespace_name, sum(f.bytes) bytes_free
          from dba_free_space f
         group by tablespace_name) b
 where a.tablespace_name = b.tablespace_name(+)
union all
select h.tablespace_name,
       round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,
       round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
             1048576) megs_free,
       round(sum(nvl(p.bytes_used, 0)) / 1048576) megs_used,
       round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
             sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,
       100 -
       round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) /
             sum(h.bytes_used + h.bytes_free)) * 100) pct_used,
       round(sum(f.maxbytes) / 1048576) max
  from sys.v_$TEMP_SPACE_HEADER h,
       sys.v_$Temp_extent_pool  p,
       dba_temp_files           f
 where p.file_id(+) = h.file_id
   and p.tablespace_name(+) = h.tablespace_name
   and f.file_id = h.file_id
   and f.tablespace_name = h.tablespace_name
 group by h.tablespace_name
 ORDER BY 1
/


    SELECT d.tablespace_name "Name", 
                TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,990.900') "Size (M)", 
                TO_CHAR(NVL(t.hwm, 0)/1024/1024,'99999999.999')  "HWM (M)",
                TO_CHAR(NVL(t.hwm / a.bytes * 100, 0), '990.00') "HWM % " ,
                TO_CHAR(NVL(t.bytes/1024/1024, 0),'99999999.999') "Using (M)", 
	        TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), '990.00') "Using %" 
           FROM sys.dba_tablespaces d, 
                (select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) a,
                (select tablespace_name, sum(bytes_cached) hwm, sum(bytes_used) bytes from v$temp_extent_pool group by tablespace_name) t
          WHERE d.tablespace_name = a.tablespace_name(+) 
            AND d.tablespace_name = t.tablespace_name(+) 
            AND d.extent_management like 'LOCAL' 
            AND d.contents like 'TEMPORARY'
/


ttitle - 
   center  'Database Freespace Summary'  skip 2 
 
comp sum of nfrags totsiz avasiz on report 
break on report 

set pages 999
col tsname  format     a16 justify c heading 'Tablespace' 
col nfrags  format 999,990 justify c heading 'Free|Frags' 
col mxfrag  format 999,999 justify c heading 'Largest|Frag (MB)' 
col totsiz  format 999,999 justify c heading 'Total|(MB)' 
col avasiz  format 999,999 justify c heading 'Available|(MB)' 
col pctusd  format     990 justify c heading 'Pct|Used' 

select total.TABLESPACE_NAME tsname,
       D nfrags,
       C/1024/1024 mxfrag,
       A/1024/1024 totsiz,
       B/1024/1024 avasiz,
       (1-nvl(B,0)/A)*100 pctusd
from
    (select sum(bytes) A,
            tablespace_name
            from dba_data_files
            group by tablespace_name) TOTAL,
    (select sum(bytes) B,
            max(bytes) C,
            count(bytes) D, 
            tablespace_name
            from dba_free_space
            group by tablespace_name) FREE
where 
      total.TABLESPACE_NAME=free.TABLESPACE_NAME(+)
/


SELECT t.tablespace_name,
       CASE
         WHEN t.contents = 'TEMPORARY' AND t.extent_management = 'LOCAL' THEN
          u.bytes
         ELSE
          df.user_bytes - NVL(fs.bytes, 0)
       END / 1024 / 1024 used_mb,
       CASE
         WHEN t.contents = 'TEMPORARY' AND t.extent_management = 'LOCAL' THEN
          df.user_bytes - NVL(u.bytes, 0)
         ELSE
          NVL(fs.bytes, 0)
       END / 1024 / 1024 free_mb,
       fs.min_fragment / 1024 / 1024 min_fragment_mb,
       fs.max_fragment / 1024 / 1024 max_fragment_mb,
       (fs.bytes / 1024 / 1024) / fs.fragments avg_fragment_mb,
       fs.fragments,
       t.status,
       t.contents,
       t.logging,
       t.extent_management,
       t.allocation_type,
       t.force_logging,
       t.segment_space_management,
       t.def_tab_compression,
       t.retention,
       t.bigfile
  FROM dba_tablespaces t,
       (SELECT tablespace_name,
               SUM(bytes) bytes,
               MIN(min_fragment) min_fragment,
               MAX(max_fragment) max_fragment,
               SUM(fragments) fragments
          FROM (SELECT tablespace_name,
                       SUM(bytes) bytes,
                       MIN(bytes) min_fragment,
                       MAX(bytes) max_fragment,
                       COUNT(*) fragments
                  FROM dba_free_space
                 GROUP BY tablespace_name
                UNION ALL
                SELECT tablespace_name,
                       SUM(bytes) bytes,
                       MIN(bytes) min_fragment,
                       MAX(bytes) max_fragment,
                       COUNT(*) fragments
                  FROM dba_undo_extents
                 WHERE status = 'EXPIRED'
                 GROUP BY tablespace_name)
         GROUP BY tablespace_name) fs,
       (SELECT tablespace_name, SUM(user_bytes) user_bytes
          FROM dba_data_files
         GROUP BY tablespace_name
        UNION ALL
        SELECT tablespace_name, SUM(user_bytes) user_bytes
          FROM dba_temp_files
         GROUP BY tablespace_name) df,
       (SELECT tablespace_name, SUM(bytes_used) bytes
          FROM gv$temp_extent_pool
         GROUP BY tablespace_name) u
 WHERE t.tablespace_name = df.tablespace_name(+)
   AND t.tablespace_name = fs.tablespace_name(+)
   AND t.tablespace_name = u.tablespace_name(+)
/

Script:收集数据库安全风险评估信息

以下脚本可以用于收集数据库安全风险评估信息:

REM list database vulnerability assessment info

set escape on;
set linesize 140 ;
spool db_vulnerability_assessment.log

Select role
  from dba_roles r
 where role not in ('CONNECT',
                    'RESOURCE',
                    'DBA',
                    'SELECT_CATALOG_ROLE',
                    'EXECUTE_CATALOG_ROLE',
                    'DELETE_CATALOG_ROLE',
                    'EXP_FULL_DATABASE',
                    'WM_ADMIN_ROLE',
                    'IMP_FULL_DATABASE',
                    'RECOVERY_CATALOG_OWNER',
                    'AQ_ADMINISTRATOR_ROLE',
                    'AQ_USER_ROLE',
                    'GLOBAL_AQ_USER_ROLE',
                    'OEM_MONITOR',
                    'HS_ADMIN_ROLE')
   and not exists
 (Select 1 from dba_role_privs p where p.granted_role = r.role)
/

select tp.grantee, tp.table_name
  from dba_tab_privs tp, dba_users u
 where tp.owner = 'SYS'
   and (tp.table_name like 'V_$%' or tp.table_name like 'G_V$')
   and tp.grantee = u.username
   and u.username not in ('SYS',
                          'SYSTEM',
                          'SYSMAN',
                          'EXFSYS',
                          'WMSYS',
                          'OLAPSYS',
                          'OUTLN',
                          'DBSNMP',
                          'ORDSYS',
                          'ORDPLUGINS',
                          'MDSYS',
                          'DMSYS',
                          'CTXSYS',
                          'AURORA$ORB$UNAUTHENTICATED',
                          'XDB',
                          'FLOWS_030000',
                          'FLOWS_FILES')
 order by 1, 2
/


select *
  from (select 'Hidden User in DBA_USERS' ddview, name
          from sys.user$
         where type# = 1
        minus
        select 'Hidden User in DBA_USERS', username from SYS.dba_users) q1
union all
select *
  from (select 'Hidden User in ALL_USERS', name
          from sys.user$
         where type# = 1
        minus
        select 'Hidden User in ALL_USERS', username from SYS.all_users) q2
/



select grantee, granted_role
  from dba_role_privs
 where grantee in (select role from dba_roles)
 order by grantee, granted_role
/

select grantee, privilege, admin_option
  from dba_sys_privs sp, dba_users u
 where sp.GRANTEE = u.username
   and grantee not in ('SYS', 'SYSTEM')
   and privilege in (select name
                       from sys.system_privilege_map
                      where 0 = 1
                         or name like '%ANY%'
                         or name like '%DATABASE%'
                         or name like '%DIRECTORY%'
                         or name like '%LIBRARY%'
                         or name like '%LINK%'
                         or name like '%PROFILE%'
                         or name like '%RESTRICTED%'
                         or name like 'SYS%'
                         or name like '%SYSTEM%'
                         or name like '%TABLESPACE%'
                         or name like '%USER%')
 order by 1
/

select role,
       (select count(*)
          from dba_role_privs rp
         where rp.granted_role = r.role) GRANT_COUNT
  from dba_roles r
 where r.role in ('DBA', 'CONNECT', 'RESOURCE')
 order by 1
/

select grantee, granted_role, admin_option
  from dba_role_privs rp, dba_users u
 where rp.grantee = u.username
   and grantee not in ('SYS', 'SYSTEM')
   and granted_role in (select role
                          from dba_roles
                         where 0 = 1
                            or role like '%CATALOG%'
                            or role like '%DATABASE%'
                            or role like '%DBA%')
 order by 1
/

select distinct profile, resource_name, actual_limit 
from (select P.Profile, p.resource_Name,
             decode(p.limit, 'UNLIMITED', '9999999999999999999', 
                   'NULL', null, to_number(p.limit)) limit,
             limit actual_limit
      from ( select profile, resource_name, 
                    decode(resource_name,  'IDLE_TIME', decode(limit, 'DEFAULT', 'UNLIMITED', limit),
                                           'FAILED_LOGIN_ATTEMPTS', decode(limit, 'DEFAULT', '10', limit),
                                           'PASSWORD_LIFE_TIME', decode(limit, 'DEFAULT', 'UNLIMITED', limit),
                                           'PASSWORD_REUSE_MAX', decode(limit, 'DEFAULT', 'UNLIMITED', limit),
                                           'PASSWORD_REUSE_TIME', decode(limit, 'DEFAULT', 'UNLIMITED', limit),
                                           'PASSWORD_GRACE_TIME', decode(limit, 'DEFAULT', 'UNLIMITED', limit),
                                'PASSWORD_VERIFY_FUNCTION', decode(limit, 'NULL', '0', null, 0, 'DEFAULT', 0, 1), limit) limit
              from   dba_profiles
              where resource_name in ('IDLE_TIME', 'FAILED_LOGIN_ATTEMPTS',
                                      'PASSWORD_LIFE_TIME', 'PASSWORD_REUSE_MAX',
                                      'PASSWORD_REUSE_TIME','PASSWORD_GRACE_TIME',
                                      'PASSWORD_VERIFY_FUNCTION')) p ) 
where 1=0 
or    (RESOURCE_NAME = 'IDLE_TIME' AND LIMIT > 60)
or    (RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS' AND LIMIT > 3)
or    (RESOURCE_NAME = 'PASSWORD_LIFE_TIME' AND LIMIT > 90)
or    (RESOURCE_NAME = 'PASSWORD_REUSE_MAX' AND LIMIT > 20)
or    (RESOURCE_NAME = 'PASSWORD_REUSE_TIME' AND LIMIT > 180)
or    (RESOURCE_NAME = 'PASSWORD_GRACE_TIME' AND LIMIT > 3)
or    (RESOURCE_NAME = 'PASSWORD_VERIFY_FUNCTION' AND LIMIT = 0)
order by 1,2
/

Select s.owner, s.synonym_name, s.table_owner, s.table_name
  from sys.DBA_synonyms s
 where not exists (Select 'x'
          from sys.DBA_objects o
         where o.owner = s.table_owner
           and o.object_name = s.table_name)
   and db_link is null
   and s.owner <> 'PUBLIC'
 order by 1
/

Select distinct profile
  from dba_profiles
minus
Select distinct profile from dba_users
/

select table_name
  from dba_tab_privs
 where owner = 'SYS'
   and grantee = 'PUBLIC'
   and table_name in ('UTL_SMTP',
                      'UTL_TCP',
                      'UTL_HTTP',
                      'UTL_FILE',
                      'DBMS_RANDOM',
                      'DBMS_LOB',
                      'DBMS_SYS_SQL',
                      'DBMS_BACKUP_RESTORE',
                      'EMD_SYSTEM',
                      'DBMS_NAMESPACE',
                      'DBMS_SCHEDULER')
 order by 1
/ 
 

select username, password from dba_users order by 1
/


select tp.grantee, tp.table_name, tp.privilege
  from dba_tab_privs tp, dba_users u, dba_tables t
 where tp.owner = 'SYS'
   and tp.grantee = u.username
   and tp.owner = t.owner
   and tp.table_name = t.table_name
   and u.username not in ('SYS',
                          'SYSTEM',
                          'SYSMAN',
                          'EXFSYS',
                          'WMSYS',
                          'OLAPSYS',
                          'OUTLN',
                          'DBSNMP',
                          'ORDSYS',
                          'ORDPLUGINS',
                          'MDSYS',
                          'CTXSYS',
                          'AURORA$ORB$UNAUTHENTICATED',
                          'XDB',
                          'FLOWS_030000',
                          'FLOWS_FILES')
 order by 1, 2, 3
/
 
 select sp.grantee, sp.privilege
   from dba_sys_privs sp, dba_users u
  where sp.admin_option = 'YES'
    and u.username = sp.grantee
    and u.username not in ('SYS',
                           'SYSTEM',
                           'SYSMAN',
                           'EXFSYS',
                           'WMSYS',
                           'OLAPSYS',
                           'OUTLN',
                           'DBSNMP',
                           'ORDSYS',
                           'ORDPLUGINS',
                           'MDSYS',
                           'CTXSYS',
                           'AURORA$ORB$UNAUTHENTICATED',
                           'XDB',
                           'FLOWS_030000',
                           'FLOWS_FILES')
  order by 1, 2
/
  
  select p.grantee, p.owner, p.table_name, p.privilege
    from dba_tab_privs p, dba_users u
   where p.grantable = 'YES'
     and u.USERNAME = p.grantee
     and u.username not in ('SYS',
                            'SYSTEM',
                            'SYSMAN',
                            'EXFSYS',
                            'WMSYS',
                            'OLAPSYS',
                            'OUTLN',
                            'DBSNMP',
                            'ORDSYS',
                            'ORDPLUGINS',
                            'MDSYS',
                            'CTXSYS',
                            'AURORA$ORB$UNAUTHENTICATED',
                            'XDB',
                            'FLOWS_030000',
                            'FLOWS_FILES')
   order by 1, 2, 3, 4
/

select username
  from dba_users
 where account_status!='EXPIRED \& LOCKED'
 order by 1
/

Select s.synonym_name, s.table_owner, s.table_name
  from sys.DBA_synonyms s
 where not exists (Select 'x'
          from sys.DBA_objects o
         where o.owner = s.table_owner
           and o.object_name = s.table_name)
   and db_link is null
   and s.owner = 'PUBLIC'
 order by 1
/

select r.grantee, r.granted_role
  from dba_role_privs r, dba_users u
 where r.admin_option = 'YES'
   and u.username = r.grantee
   and u.username not in ('SYS',
                          'SYSTEM',
                          'SYSMAN',
                          'EXFSYS',
                          'WMSYS',
                          'OLAPSYS',
                          'OUTLN',
                          'DBSNMP',
                          'ORDSYS',
                          'ORDPLUGINS',
                          'MDSYS',
                          'CTXSYS',
                          'AURORA$ORB$UNAUTHENTICATED',
                          'XDB',
                          'FLOWS_030000',
                          'FLOWS_FILES')
 order by 1, 2
/


select username
  from dba_users
 where password = 'EXTERNAL'
 order by username
/

PMON: TERMINATING INSTANCE DUE TO ERROR 600 on 8i

Alert logfile reported as below:

*********************
Wed May 27 13:11:47 2009
Errors in file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc:
ORA-07445: exception encountered: core dump [memset()+116] [SIGSEGV] [Address not mapped to object] [0] [] []

From Trace file
********************
Dump file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /u01/app/oracle/product/817proa021
System name:	SunOS
Node name:	v08k01
Release:	5.8
Version:	Generic_117350-38
Machine:	sun4u
Instance name: proa021
Redo thread mounted by this instance: 1

Process Info
******************
Oracle process number: 117
Unix process pid: 9533, image: oracle@v08k01 (TNS V1-V3)

Error
*********
2009-05-27 13:11:47.847
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [memset()+116] [SIGSEGV] [Address not mapped to object] [0] [] []

Current SQL(Current SQL statement for this session)
***********************************************************************
:
SELECT COUNT(PO_LINE_ID) FROM PO_LINES_INTERFACE WHERE PO_HEADER_ID = :b1

Call Stack functions
*************************
ksedmp <- ssexhd <- sigacthandler <- memset


#####################################################################################
From Alert logfile
*********************
Wed May 27 13:18:39 2009
Errors in file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc:
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Wed May 27 13:18:56 2009
Errors in file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc:
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []


From Tracefile
*******************
Dump file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /u01/app/oracle/product/817proa021
System name:	SunOS
Node name:	v08k01
Release:	5.8
Version:	Generic_117350-38
Machine:	sun4u
Instance name: proa021
Redo thread mounted by this instance: 1

Process Info
****************
Oracle process number: 2
Unix process pid: 9584, image: oracle@v08k01 (PMON)


Error
********
2009-05-27 13:18:39.766
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []

Call Stack Functions:
****************************
ksedmp <- kgeriv <- kgesiv <- ksesic0 <- kssdch
<- ksuxds <- kssxdl <- kssdch <- ksudlp <- kssxdl
<- ksuxdl <- ksuxda <- ksucln <- ksbrdp <- opirip
<- opidrv <- sou2o <- main <- start

CURRENT SESSION'S INSTANTIATION STATE
*********************************************************
current session=8c8fdfbc
---- Cursor Dump ------
Current cursor: 0, pgadep: 0
Cursor Dump:
End of cursor dump
END OF PROCESS STATE
******************** Cursor Dump ************************
Current cursor: 0, pgadep: 0
Cursor Dump:
End of cursor dump
ksedmp: no current context area

ERROR: ORA-600 [1115]

VERSIONS: versions 6.0 to 10.1

DESCRIPTION: We are encountering a problem while cleaning up a state object.

The State Object is already on free list or has the wrong parent State Object.

FUNCTIONALITY: Kernal Service State object manager

IMPACT:
POSSIBLE INSTANCE FAILURE
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS: This error may be reported as a direct result of another earlier problem.

Lot of bugs reported

Bug 3837965 : Abstract: ORA-7445'S AND 600'S LEADING UP TO DB CRASH
Comp Version: 8.1.7.4.0
Fixed In Version: 9.2.0.
-------------------------------------------------------------

Bug 3134843 : Abstract: ORACLE PROCESSES CRASHING WITH ORA-7445 SEGVIO ON A NUMBER OF DATABASES
Comp Version: 8.1.7.4
Status: Closed, could not be reproduced
----------------------------------------------------------------

Bug 2760836: Abstract: PMON cleanup of dead shared servers/dispatchers can crash instance(OERI:26599 / OERI 1115)

--------------------------------------------------------------
Note 2760836.8 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI 26599 / OERI 1115)
----------------------------------------------------------------

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
1. One-off patch for Bug 2760836 has fixed this issue...so after customer apply the one-off patch...then this issue will be solved.

OR

2. 9.2.0.4 or later version has fixed this issue...so after customer upgrade to at least 9.2.0.4 version...then this issue will be solved.

The solution can be justified by the followings:

Note 2760836.8 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI 26599 / OERI 1115)

How does cpu_count parameter affect instance?

Parameter cpu_count is determined by Oracle Software when instance started, But we can set it manually. This parameter can affect lots of  hidden initialization parameters,see:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> host cat /proc/cpuinfo|grep processor
processor       : 0
processor       : 1

SQL> show parameter cpu_count

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cpu_count                            integer     2

create table  cpu_2_parameters as 
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
 FROM SYS.x$ksppi x, SYS.x$ksppcv y
 WHERE x.inst_id = USERENV ('Instance')
 AND y.inst_id = USERENV ('Instance')
 AND x.indx = y.indx;

SQL> alter system set cpu_count=128 scope=spfile;

System altered.

SQL> startup force;
ORACLE instance started.

Total System Global Area 1702887424 bytes
Fixed Size                  2093192 bytes
Variable Size             486543224 bytes
Database Buffers         1073741824 bytes
Redo Buffers              140509184 bytes
Database mounted.
Database opened.

SQL> show parameter cpu_count

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cpu_count                            integer     128


SQL> create table  cpu_128_parameters as 
  2  SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
  3   FROM SYS.x$ksppi x, SYS.x$ksppcv y
  4   WHERE x.inst_id = USERENV ('Instance')
  5   AND y.inst_id = USERENV ('Instance')
  6   AND x.indx = y.indx; 

Table created.


SQL> col name for a35
SQL> set linesize 200 pagesize 2000;
SQL> col "while_cpu_count=   2" for a20
SQL> col "while_cpu_count= 128" for a02
SQL>  col "while_cpu_count= 128" for a20
SQL> SELECT a.name,
  2    a.value "while_cpu_count=   2",
  3    b.value "while_cpu_count= 128",
  4    a.describ
  5  FROM cpu_2_parameters a,
  6    cpu_128_parameters b
  7  WHERE a.name=b.name
  8  AND a.value!=b.value 
  9  ORDER BY 1;

NAME                                while_cpu_count=   2 while_cpu_count= 128 DESCRIB
----------------------------------- -------------------- -------------------- --------------------------------------------------------------------------------
__db_cache_size                     33554432             536870912            Actual size of DEFAULT buffer pool for standard block size buffers
_cursor_db_buffers_pinned           445                  841                  additional number of buffers a cursor can pin at once
_db_block_buffers                   67184                126464               Number of database blocks cached in memory: hidden parameter
_db_block_lru_latches               8                    512                  number of lru latches
_enqueue_hash_chain_latches         2                    128                  enqueue hash chain latches
_enqueue_locks                      2300                 2490                 locks for managed enqueues
_flashback_generation_buffer_size   8388608              536870912            flashback generation buffer size
_log_parallelism_max                2                    8                    Maximum number of log buffer strands
_log_simultaneous_copies            4                    256                  number of simultaneous copies into redo buffer(# of copy latches)
_num_longop_child_latches           2                    128                  number of child latches for long op array
_parallel_min_message_pool          903840               1076000              minimum size of shared pool memory to reserve for pq servers
_small_table_threshold              1343                 2529                 threshold level of table size for direct reads
cpu_count                           2                    128                  number of CPUs for this instance
db_cache_size                       33554432             536870912            Size of DEFAULT buffer pool for standard block size buffers
db_writer_processes                 1                    16                   number of background database writer  processes to start
log_buffer                          6104064              136249344            redo circular buffer size
parallel_max_servers                40                   135                  maximum parallel query servers per instance
sga_max_size                        1065353216           1702887424           max total SGA size


SQL> show parameter sga_max_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 1016M

It looks like sga may grow while the instance has more processors. Oracle Parallel Servers can has more differ with cpu_count . Sometimes this parameter make performance issues.

ORA-00600 [kddummy_blkchk]错误一例

一套HP-UX Itanium平台上的10.2.0.2,实例意外终止,维护人员尝试重启实例,在数据库打开后数秒,smon后台进程报ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110]错误,实例再次意外终止。

部分告警日志如下:

Corrupt Block Found
TSN = 50, TSNAME = TS_DNI_AAL_12
RFN = 120, BLK = 849708, RDBA = 504166188
OBJN = 701796, OBJD = 701796, OBJECT = MAP_WOL_SILJUK, SUBOBJECT =
SEGMENT OWNER = DBOWN, SEGMENT TYPE = Table Segment
Corrupt Block Found
TSN = 50, TSNAME = TS_DNI_AAL_12
RFN = 121, BLK = 897927, RDBA = 508408711
OBJN = 701796, OBJD = 701796, OBJECT = MAP_WOL_SILJUK, SUBOBJECT =
SEGMENT OWNER = DBOWN, SEGMENT TYPE = Table Segment
Mon May 4 19:38:19 2009
Errors in file /oracle/admin/TDAY2DB/udump/tday2db_ora_2080.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [121], [897927], [6110], [], [], [], []
Mon May 4 19:38:19 2009
Errors in file /oracle/admin/TDAY2DB/udump/tday2db_ora_2077.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [849708], [6110], [], [], [], []

Mon May 4 21:58:55 2009
Recovery of Online Redo Log: Thread 1 Group 5 Seq 90582 Reading mem 0
Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log
Block recovery completed at rba 90582.42.16, scn 1858.566253676
ORACLE Instance TDAY2DB (pid = 22) - Error 81 encountered while recovering transaction (14, 22) on object 701796.
Mon May 4 21:58:55 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc:
ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234) is not readable
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], []
Mon May 4 21:58:55 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc:
ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234) is not readable
ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234) is not readable
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], []
Mon May 4 21:58:57 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_p020_17710.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], []
Mon May 4 21:58:58 2009
Doing block recovery for file 120 block 856039
Block recovery from logseq 90582, block 37 to scn 7980615489643
Mon May 4 21:58:58 2009
Recovery of Online Redo Log: Thread 1 Group 5 Seq 90582 Reading mem 0
Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log
Block recovery completed at rba 90582.42.16, scn 1858.566253676
Mon May 4 21:58:58 2009
SMON: Restarting fast_start parallel rollback
Mon May 4 21:58:58 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_p000_17661.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], []
Mon May 4 21:58:59 2009
Doing block recovery for file 120 block 856039
Block recovery from logseq 90582, block 37 to scn 7980615489643
Mon May 4 21:58:59 2009
Recovery of Online Redo Log: Thread 1 Group 5 Seq 90582 Reading mem 0
Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log
Block recovery completed at rba 90582.42.16, scn 1858.566253676
Mon May 4 21:58:59 2009
SMON: ignoring slave err,downgrading to serial rollback
Mon May 4 21:59:00 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], []
Mon May 4 21:59:09 2009
Errors in file /oracle/admin/TDAY2DB/bdump/tday2db_pmon_17633.trc:
ORA-00474: SMON process terminated with error
Mon May 4 21:59:09 2009
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 17633

当Oracle进程在读取数据块时会做一系列逻辑检测,当发现块当中存在逻辑讹误就会触发该ORA-00600 [kddummy_blkchk]等内部错误;[kddummy_blkchk]内部函数的功能大致与[kdBlkCheckError]相仿,它们都有3个参数argument:
ORA-600 [kddummy_blkchk] [file#] [block#] [check code]
ORA-600 [kdBlkCheckError]   [file#] [block#] [check code]

file#即问题块所在datafile的文件号,block#即问题块的块号,check code为发现逻辑讹误时的检测种类代码;我们也可以通过file#和block#查找到存在问题的对象,譬如这个case中的file#为120,block#为856039,检查种类代码为6110:

Select segment_name,segment_type,owner from dba_extents where file_id=120 and 856039 between block_id and block_id + blocks -1;

当然以上查询是建立在我们能够打开数据库的前提下的,针对由ORA-600[[kddummy_blkchk]或[kdBlkCheckError]引起的实例意外终止及启动实例失败等现象,我们可以通过修改db_block_checking和db_block_checksum 2个参数为false,来阻止Oracle进程对数据块的一些逻辑检测工作:

SQL> alter system set db_block_checking=false;
System altered.

SQL> alter system set db_block_checksum=false;
System altered.

以上参数能够一定程度上规避ORA-600[kddummy_blkchk]或[kdBlkCheckError]的出现;但因为10g中隐式参数_db_always_check_system_ts控制了Oracle是否对system表空间上的对象进行block check和checksum(_db_always_check_system_ts:Always perform block check and checksum for System tablespace),且该隐式参数默认为TRUE;因此你还是有一定概率无法打开数据库,如遇此类argument[a]对应为system表空间的ORA-600[kddummy_blkchk]内部错误,可以尝试使用10513来进一步阻止数据库打开后smon进程的事务恢复(transaction recovery)行为:

SQL> alter system set event='10513 trace name context forever,level 2' scope=spfile;
System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup ;
ORACLE instance started.

Total System Global Area 2634022912 bytes
Fixed Size                  2086288 bytes
Variable Size            2399144560 bytes
Database Buffers          218103808 bytes
Redo Buffers               14688256 bytes
Database mounted.
Database opened.

SQL> show parameter event
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10513 trace name context forever,level 2

在这个案例中我们尝试设置db_block_checksum 和 db_block_checking为false,打开了数据库,并进一步对存在问题块的表执行了导出导入的工作,最终解决了问题。
10g中默认参数db_block_checksum为TRUE,所以建议你在解决类似问题后,将该参数还原。

Oracle内部错误:ORA-00600[25012]一例

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638   QQ号:47079569    邮箱:service@parnassusdata.com

 

 

SQL> select count(*) from WWork;

COUNT(*)
----------
116114

select count(*) from WWork where Work_WorkID = 100;
select count(*) from WWork where Work_WorkID = 100
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [],
[]

Tablespace id 15 is the same where the index is created.

analyze table livelink.WWORK validate structure cascade;

analyze table livelink.WWORK validate structure cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [],
[]

analyze index livelink.WWORK_PRIMARY validate structure;
analyze index livelink.WWORK_PRIMARY validate structure
*
ERROR at line 1:
ORA-08100: index is not valid - see trace file for diagnostics

I'm wondering if the issue could be resolved recreating the index.

alter index WWORK_PRIMARY rebuild online noparallel;

On the alert log file, ORA-00600 began at:
Sun Jun 5 23:29:10 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_26554.trc:
ORA-00600: internal error code, arguments: [ktbair1], [1], [6], [], [], [], [], []
Mon Jun 6 00:35:51 2011
Thread 1 advanced to log sequence 303722
Current log# 19 seq# 303722 mem# 0: /u002/oradata/motpcom/redo19.log
Mon Jun 6 00:35:51 2011
And then below error often raised in alert log:
Mon Jun 6 02:45:00 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_28348.trc:
ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [], []
Mon Jun 6 02:50:01 2011
I also found other errors:
Mon Jun 6 05:00:01 2011
ORA-01555 caused by SQL statement below (Query Duration=18448 sec, SCN: 0x09f0.52bb91c8):
Mon Jun 6 05:00:01 2011
SELECT COUNT(d.dataid)
FROM allemployees a, networks_dataids d, kuaf k, dversdata v
WHERE k.name=a.user_id(+) AND d.userid=k.id AND a.user_id is null
Mon Jun 6 05:00:13 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_28348.trc:
ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [], []
Mon Jun 6 05:05:13 2011
And
Tue Jun 7 02:02:14 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_25842.trc:
ORA-07445: exception encountered: core dump [00000001011B8AD8] [SIGSEGV] [Address not mapped to object] [0x000000A88] [] []
Tue Jun 7 02:03:11 2011
And
Tue Jun 7 02:41:35 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_27325.trc:
ORA-00600: internal error code, arguments: [2662], [2544], [1396224900], [28954], [3445424704], [786437], [], []
Tue Jun 7 02:41:35 2011
Errors in file /u001/app/oracle/admin/motpcom/udump/motpcom_ora_27325.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [2544], [1396224900], [28954], [3445424704], [786437], [], []
Tue Jun 7 02:41:59 2011 

SQL> select count(*) FROM WWork where Work_WorkID=100;
select count(*) FROM WWork where Work_WorkID=100
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [],
[]


SQL> alter index WWORK_PRIMARY rebuild online noparallel;

Index altered.

SQL> select count(*) FROM WWork where Work_WorkID=100;

COUNT(*)
----------
0

Index corruptions do not always mean that there is a Bug.
Indexes corrupt when the transaction ID that associates it with its data does not match.
In majority of the cases, this happens when a table has a large amount of DDL or DML processing as in a OLAP
processing. The index buffer cache is over written with an incorrect transaction id and an error results.
The error could be a ORA-00600 [25027] error, an ORA-8102/8103, or another ORA-00600 error.
Possibly, adding another index may resolve the issue of relying on just one index.

In addition, the index space must be reviewed to determine whether there is enough space.
As in the first example above, if there isn't space, then the index can be overwritten and an error can appear.
I suggest reading My Oracle Knowledge Note 33343.1 "How to Find Out How Much Space an Index is Using" which provides select
statements to show the actual usage of blocks within an index. This gives an idea of how 'full' an index is and
allows the DBA to adjust next extent sizes etc.

In addition, you can start the Index Tuning Wizard from Enterprise Manager in order to get advice on the indexes within the database.

We would like to emphasize that the best method to resolve a corrupt index is to drop and recreate it and not use a rebuild.
If this index corrupts again, then we suggest that it be dropped and recreated.


ORA-600 [25012] "Relative to Absolute File Number Conversion Error"


Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:            
  This article discusses the internal error "ORA-600 [25012]", what 
  it means and possible actions. The information here is only applicable 
  to the versions listed and is provided only for guidance.
 
ERROR:              
  ORA-600 [25012] [a] [b] [c]
 
VERSIONS:
  versions 8.0 and above
 
DESCRIPTION:

  We are trying to generate the absolute file number given a tablespace 
  number and relative file number and cannot find a matching file number
  or the file number is zero.
 
ARGUMENTS:          
  Arg [a] Tablespace Number 
  Arg [b] Relative file number
  Arg [c] Absolute file number (This arg is present is more recent releases)
 
FUNCTIONALITY:      
  KERNEL FILE MANAGEMENT TABLESPACE COMPONENT
 
IMPACT:             
  POSSIBLE PHYSICAL CORRUPTION
 
SUGGESTIONS:        

  The possibility of physical corruption exists.

  Obtain the trace files and alert.log for this error and log a Service Request
  with Oracle Support Services for diagnosis.

  If the Arg [b] Relative file number returns 0 (zero), look for fake indexes
  that can cause this error.

  The following query list fake indexes :

  select a.*,b.flags from dba_objects a, sys.ind$ b
  where a.object_id = b.obj#
  and bitand(b.flags,4096)=4096;

  Known Issues:




Known Bugs
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:


    NB	Bug	Fixed	Description
    	5653641 	11.2.0.1 	Corrupt dictionary from DROP TABLESPACE containing _offline_rollback_segments
    * 	8198906 	10.2.0.5, 11.2.0.1 	OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents
    	4925342 	9.2.0.8, 10.2.0.3, 11.1.0.6 	OERI [25027] / OERI [25012] on IOT analyze estimate statistics
    	3258674 	9.2.0.7, 10.1.0.4, 10.2.0.1 	QMN process may dump or raise an internal error during DML
    	4186885 	10.2.0.1 	Partition numbers for IOT index/overflow segments are not synchronized
    	3751874 	9.2.0.6, 10.1.0.4, 10.2.0.1 	OERI[25012] can occur when _old_connect_by_enabled set to true
    	3430832 	9.2.0.6, 10.1.0.3, 10.2.0.1 	OERI[25012] in DML after ONLINE create index against PARTITIONED table
    	3915343 	9.2.0.7, 10.1.0.5, 10.2.0.1 	OERI [25012] on COMMIT with refresh ON-COMMIT Materialized view over cluster
    	4305391 	9.2.0.7, 10.1.0.5, 10.2.0.1 	OERI[25012] with kditalp can occur during a temporary LOB operation
    P* 	6047085 		Linux x64-64: SGA corruption / crash following any ORA-7445
    	2526334 	9.2.0.3, 10.1.0.2 	OERI:25012 from AND EQUAL with B-Tree and DOMAIN index
    	2531519 	9.2.0.3, 10.1.0.2 	OERI:[25012] from parallel direct load of bitmap managed segments
    	3150268 	9.2.0.5, 10.1.0.2 	OERI[kcbgcur_1] / OERI:25012 deleting rows from PARENT table with LIST subpartitions
    	3070856 	9.2.0.5, 10.1.0.2 	OERI:12700 / 25012 / ktrexc_1 on transported tablespace with SMU
    	3771508 	9.2.0.7 	OERI[kcbgtcr_1] / OERI[25012] selecting from V$AQ in a shared server
    	3900237 	9.2.0.7 	OERI[25012] changing length of indexed column for a global temporary table
    	1834530 	8.1.7.4, 9.0.1.4, 9.2.0.1 	OERI:25012 / wrong results after EXCHANGE 
        PARTITION with indexes with different FREELIST /FREELIST GROUPS
    	1698789 	9.2.0.1 	Wrong results, ORA-1410, ORA-8103, OERI:25012 on SELECT of UNSCOPED REF with ROWID
    	2189615 	8.1.7.4, 9.0.1.4, 9.2.0.1 	OERI:25012 / OERI:504 [cache buffers chains] selecting from certain V$ tables
    	1784708 	8.1.7.3, 9.0.1.1, 9.2.0.1 	OERI:KCBGTCR_1/OERI:25012 accessing LONG / LONG RAW in a HASH CLUSTER
    	1872985 	9.0.1.2, 9.2.0.1 	Dump / OERI:25012 from BITMAP CONVERSION of INDEX on GLOBAL TEMPORARY TABLE
    	1968815 	9.0.1.2, 9.2.0.1 	OERI:25012 possible from SMON following DROP TABLESPACE command
    	2287815 	9.0.1.4, 9.2.0.1 	OERI:KTSPISCHNT / OERI:25012 after exchange PARTITION with bitmap managed segments
    	2184731 	8.1.7.4, 9.2.0.1 	OERI:25012 possible from index prefetch
    	1837529 	8.1.7.3, 9.0.1.1, 9.2.0.1 	OERI:KFTR2BZ_1/OERI:25012 from CREATE sub-partitioned local INDEX ONLINE
    	2214167 	9.0.1.4, 9.2.0.1 	OERI:25012 / wrong results possible after TRUNCATE of bitmap managed index
    	2212389 	9.0.1.4, 9.2.0.1 	OERI:25012 / Cursor frame memory corruption when cursor with BINDS aged out / reloaded
    	1788648 	8.1.7.3, 9.0.1.1, 9.2.0.1 	OERI:25012 [2147483647] possible selecting from certain V$ views
    	1527982 	8.1.7.2, 9.0.1.0 	OERI:25012 / Bitmap indextable mismatch after UPDATE of PARTITION KEY moves rows
    	1949273 	8.1.7.3, 9.0.1.0 	OERI:25012 / ORA-1555 / ORA-22922 accessing LOB data after ALTER TABLE MOVE lob
    	1264970 	8.1.7.1, 9.0.1.0 	OERI:25012 / OERI:6050 possible coalescing index with freelists
    	1396571 	8.0.6.3, 8.1.6.3, 8.1.7.1, 9.0.1.0 	OERI:25012 possible importing with TRANSPORT_TABLESPACE=Y
    	1678963 	8.1.7.2, 9.0.1.0 	OERI:25012 / OERI:4142 possible on TRUNCATE of a table with a CLOB column
    	1297674 	8.0.6.2, 8.1.6.3, 8.1.7.0 	OERI:25012 Analyzing partitioned table with ESTIMATE
    	1138239 	8.1.6.2, 8.1.7.0 	OERI-25012 possible on direct read from plugged in (transportable) tablespace
    	1228658 	8.1.6.2, 8.1.7.0 	Create INDEX on SNAPSHOT/MV can produce corrupt index (OERI:13004 / OERI:25012 / ORA-1499)
    	1108002 	8.1.7.0 	OERI:25012 when DBMS_STATS tries to gather stats for a GLOBAL TEMPORARY table
    	986928 	8.1.7.0 	DBMS_SPACE.UNUSED_SPACE reports OERI:25012 for TEMPORARY tables
    	1312233 	8.1.6.3, 8.1.7.0 	OERI:25012 / OERI:KCBGCUR_1 possible on PQ STAR query with PARTITIONED fact table
    	718499 	8.0.6.1, 8.1.5.0 	OERI:25012 possible on OPS parallel create index
    	677243 	8.0.6.0 	OERI:kdddgbX on DELETE / UPDATE / SELECT for UPDATE with an invalid ROWID
    	679817 	8.0.5.1 	OERI:25012 from view containing 2+ LOB columns
    	595698 	8.0.4.3, 8.0.5.0 	DELETE on table with many child constraints may dump.

        '*' against a bug indicates that an alert exists for that issue.
        '+' indicates a particularly notable bug.
        'P' indicates a port specific bug.
        "OERI:nnnnn" is used as shorthand for ORA-600 [nnnnn]. 

Symptom(s)
~~~~~~~~~~

ORA-600 [25012] errors with same first argument and different
second arguments (second arguments changes during every SELECT Run)

Eg.:

ORA-600 [25012], [5], [1023], [], [], [], []


The first argument corresponds to a tablespace and second argument
corresponds to a file number.

The tablespace points to an index tablespace


Cause
~~~~~

Bug:2184731


Fix
~~~~

Bug:2184731 is fixed in 8.1.7.4 and 9.2

The workaround is to set _db_file_noncontig_mblock_read_count=1.


References
~~~~~~~~~~

Note:100073.1  ORA-600 [25012] "Relative to Absolute File Number 
                 Conversion Error"

Bug:2184731    ORA-600 [25012] WHEN SELECT FROM A TABLE USING AN INDEX

Most of library cache latches have gone in 11g

10g

SELECT t1.ksllasnam "parent_name",
t2.ksllwnam "location"
FROM x$ksllw t2, x$kslwsc t1
WHERE t2.indx = t1.indx
AND ksllasnam like '%library cache%'

parent_name location
-------------------------------------------------- ----------------------------------------------------------------
library cache kqlftc
library cache kqlmbfre: parent
library cache kqlmbpil: parent
library cache kqlmbinv: parent
library cache kqlmbfre: child: in loop
library cache kqlmbfre: child: no obj to free
library cache pin kqlmbpil: child
library cache pin kqlmbpil: child: free and continue
library cache pin kqlmbp: child
library cache pin kqlmbpil: child: post parent after timeout
library cache kgluka: parent
library cache kglScanDependency
library cache kglscn: parent
library cache kglsca: parent
library cache kglLockCursor
library cache kgldrp: child
library cache kgldrx: child
library cache kgldmc: parent
library cache kglhdiv: child
library cache kglivl: parent
library cache kglidp: child
library cache kgldtld: parent
library cache kgldte: parent
library cache kglilf: parent
library cache kglmvsca: parent
library cache kgldte: child 0
library cache kglget: KGLDSBYA
library cache kglget: set reserved lock
library cache kglget: hash collision
library cache kglget: unpin heap 0
library cache kglpin: child: KGLMX
library cache kglupi: child: outside loop
library cache kglkep: child
library cache kglukp: child
library cache kglupc: child
library cache kglgfc: child
library cache kglalt: child
library cache kglupd: child
library cache kglsts: child
library cache kglpur: child
library cache kglprg: child
library cache kglini: child
library cache kglver: child
library cache kglivl: child
library cache kglivr: child
library cache kgldte: child
library cache kglhdbrnl: child
library cache kglobr: child
library cache kglpnc: child
library cache kglati
library cache kglpim
library cache kglupkp
library cache kgllfr
library cache kglnti
library cache kglic
library cache kglpnp: child
library cache kglhfr: child
library cache kglrtl
library cache kglpin
library cache kglswp
library cache kgldti: 2child
library cache kgldtld: 2child
library cache kgl 2child pad56
library cache kgllkal: parent
library cache kglhdal: parent
library cache kglhdunp: parent: flush
library cache kglhdiv0: parent: invalidate
library cache kglhdbr0: parent: invalidate
library cache kgllldl: child:
library cache kglhdbr: child
library cache kgl parent pad2132
library cache kglhdgn: child:
library cache kglhdgc: child:
library cache kglhdgh: child:
library cache kglobpn: child:
library cache kglpndl: child: before processing
library cache kglhdiv0: child
library cache kglpndl: child: after processing
library cache kglobld
library cache kglpin: child: heap processing
library cache kglpnal: 2child
library cache load lock kglllal: llatch
library cache lock kglget: un-set reserved lock
library cache lock kgllkal: child: multiinstance
library cache lock kgllkal: child: in loop
library cache lock kgllkal: child: deadlk det: error
library cache lock kgllkdl: free heap 0
library cache lock kgllkdl: child: cleanup
library cache lock kgllkdl: child: multiinstance
library cache lock kgllkdl: child: no lock handle
library cache lock kgllkc: child
library cache lock kglpsl: child
library cache lock kglhdbrnl: child
library cache lock kglhdcb: child
library cache lock ksucallcbksafely: kqllhng
library cache pin ksucallcbksafely: kqlphng
library cache load lock ksucallcbksafely: kqldlhn
library cache pin kglobld: child:
library cache pin kgllkdl: child: free pin
library cache pin kglpnal: child: alloc space
library cache pin kglpnal: child: check granted
library cache pin kglpndl: child: multiinstance
library cache pin kglpnck
library cache pin kglupc
library cache pin kglpin: child: KGLMS
library cache pin kglupi: child: within loop
library cache pin kgldnp: child
library cache pin kglpnc: child
library cache pin kglpnp: child
library cache pin kglobf0
library cache pin kglpndl
library cache pin dummy
library cache pin kglivl0
library cache hash chains kglpnrel
library cache hash chains kglpnget
library cache hash chains spare
library cache pin allocation kglpnrel
library cache pin allocation kglpnget
library cache pin allocation spare1
library cache pin allocation spare2
library cache lock allocation kgllkrel
library cache lock allocation kgllkget
library cache lock allocation spare1
library cache lock allocation spare2
library cache load lock kglllal: llatch: in loop
library cache load lock kgllldl: llatch
library cache kgl 2child pad2137
library cache kgl 2child pad2138
library cache kksftc

11g

SELECT t1.ksllasnam "parent_name",
t2.ksllwnam "location"
FROM x$ksllw t2, x$kslwsc t1
WHERE t2.indx = t1.indx
AND ksllasnam like '%library cache%'

parent_name location
--------------------------------------- ---------------------------------------------
library cache load lock kglllal: llatch
library cache load lock ksucallcbksafely: kqldlhn
library cache load lock kglllal: llatch: in loop
library cache load lock kglllal: llatch: in loop 2
library cache load lock kgllldl: llatch

latch:
library cache lock
library cache lock allocation
library cache pin
library cache pin allocation
library cache

ALL above latches have gone(latch library cache load lock left), library cache lock/pin don't need acquire library cache any more in 11g ;

library cache lock/pin structure now are protected by Library cache type mutex also.
But We can not find out how kglpin/kgllkdl and else function are utlized with mutex from any V$/X$ dynamic views.
Mutex is more black-box than Latch.

SQL> select mutex_type ,location from v$mutex_sleep_history group by mutex_type,location;

MUTEX_TYPE LOCATION
-------------------------------- ---------------------------------------------
Library Cache kglhdgn2 106
Library Cache kglget1 1
Cursor Pin kksfbc [KKSCHLCREA]
Cursor Parent kksfbc [KKSPRTLOC1]
Library Cache kglrfcl1 79
Library Cache kgllkal1 80
Library Cache kgllkdl1 85
Cursor Pin kkslce [KKSCHLPIN2]
Library Cache kglhdgh1 64
Library Cache kglpin1 4
Library Cache kglpndl1 95
Cursor Pin kksfbc [KKSCHLPIN1]
Library Cache kglhdgn1 62
Library Cache kglpur1 28
Library Cache kglpnal1 90
Library Cache kglobpn1 71
Library Cache kglpnal2 91

沪ICP备14014813号

沪公网安备 31010802001379号