Re: ORA-1031 when privileges have been granted
Date: Sat, 10 Jan 2009 18:37:32 -0800 (PST)
> 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.
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 HuangReceived on Sat Jan 10 2009 - 20:37:32 CST