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

Home -> Community -> Usenet -> c.d.o.server -> Auditing SMON

Auditing SMON

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 16 May 2002 13:51:08 +0200
Message-ID: <3CE39D2C.D5B6D01@mytoys.de>


I am just digging into Oracles internals and found SMON executing

select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t
where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0;

Does anybody know ts$ and fet$ ?

Regards,

Knut Received on Thu May 16 2002 - 06:51:08 CDT

Original text of this message

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