Re: KOTTD$ and KOTTB$
Date: Wed, 5 Nov 2008 14:40:38 -0800
Message-ID: <bf46380811051440t19c1ce58r25075dba3dc65dd7@mail.gmail.com>
On Wed, Nov 5, 2008 at 6:33 AM, <Rajesh.Rao_at_jpmchase.com> wrote:
>
>
> On one of our databases (3 node RAC 10.2.0.3 on Solaris 10), I see that
> indexes on the above 2 objects belonging to sys consume about 15% of the
> logical reads that happen, and are the top 2 segments experiencing the most
> logical reads. Can someone shed light on what these objects are?
>
>
As per ML Note 175982.1 I would suspect it has something to do with
objects used in the data dictionary. You may have noticed there is a
corresponding type for each table.
You'll probably need to open an SR to pursue this further:
select * from kottd$
*
ERROR at line 1:
ORA-30732: table contains no user-visible columns
*ORA-30732: table contains no user-visible columns* *Cause:* An attempt was made to query on a system table which has no user-visible columns. *Action:* Do not query on a system table that has no user-visible columns.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 05 2008 - 16:40:38 CST