Re: ORA-1031 when privileges have been granted

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 11 Jan 2009 11:07:16 -0800
Message-ID: <bf46380901111107o3ff93777v198e5f038b10d0aa_at_mail.gmail.com>



On Sat, Jan 10, 2009 at 6:37 PM, Yong Huang <yong321_at_yahoo.com> wrote:

> > 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.
>
>

You would think so, but something else appeared to be going on.

'alter session 10046' did not show recursive SQL.

'alter system 10046' did show recursive SQL.

This after running the same query in the same database and same account, immediately following the other query with only 'alter session'.

This was tangential to the problem at hand, I wasn't really interested in pursuing it.

It might be something worth exploring a bit.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jan 11 2009 - 13:07:16 CST

Original text of this message