Spotlight on Oracle 10.6 - Release Notes

Database Objects and Privileges

Objects in the SYS schema (Oracle 11g Release 1 and earlier)

For Oracle 11g Release 1 and earlier, several objects have to be created in the SYS schema for Spotlight on Oracle to operate successfully. The only objects installed into the SYS schema are read-only views.

All v$ views are re-created; the exact number depends on the version of Oracle. These are not new objects, but we re-create them to cover the ones missed by Oracle.

New objects created in the SYS schema

For Oracle 11g Release 1 and earlier:

X$BH

X$KSUSECST

X$KSLES

X$KSLED

X$KSUSESTA

X$KSPPI

X$KSBDP

X$KSPPCV

X$KSPPSV

X$KSQRS

X$KSLEI

X$KSMLRU

X$KCBFWAIT

X$KSMSP

X$KSQST

X$KSUSE

X$KGLOB

X$KGLDP

X$KGLLK

X$KSLLT

X$KSLLD

X$KCBWDS

X$KCBWBPD

X$KTFBUE

X$KTFBFE

X$KTFBHC

Additional for Oracle 10 and later:

X$KSXPIA

X$KCCAGF

X$KMGSOP

X$KMGSCT

Additional for Oracle 11g Release 1 and later:

X$KSLLTR