Re: ORA-1031 when privileges have been granted
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 10 Jan 2009 18:37:32 -0800 (PST)
Message-ID: <334316.29631.qm_at_web80601.mail.mud.yahoo.com>
> I tried doing this with setting 10046 at the session level,
> but it did not include the SYS queries to show how the
> dictionary was being queried.
Date: Sat, 10 Jan 2009 18:37:32 -0800 (PST)
Message-ID: <334316.29631.qm_at_web80601.mail.mud.yahoo.com>
> I tried doing this with setting 10046 at the session level,
> but it did not include the SYS queries to show how the
> dictionary was being queried.
Jared,
If you're talking about not seeing recursive SQLs in the SQL trace dump file, which happens quite often, it may well be because the dictionary cache already has the info so there's no need to read from data dictionary. If you flush shared pool, dictionary cache will need to be re-populated.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 10 2009 - 20:37:32 CST