Re: Very slow revoke

Josh,

might you have gathered statistics on the sys schema via a dbms_stats.gather_database_stats call?

I haven't been keeping stats on the sys schema until 10.1.

select trunc(last_analyzed), count(1)
from dba_tables
where owner='SYS'
group by trunc(last_analyzed)
/

Paul

On Fri, 11 Mar 2005 10:34:48 -0800, Josh Collier <Josh.Collier_at_banfield.net> wrote:
> Greetings,
> =20
> We had a revoke select on table from public statement that normally=20
> executes in the blink of an eye, take over 10 hours last night. We've=20
> looked on metalink etc, to no avail, any ideas?
> =20
> Thanks,
> =20
> Josh C.=20
>
> Oracle version 9.2.0.3 enterprise
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier
> Sent: Friday, March 11, 2005 10:23 AM
> To: oracle-l_at_freelists.org
> Subject: Very slow revoke
>
> > Greetings,
> >=20
> > We had a revoke select on table from public statement that normally=20
> > executes in the blink of an eye, take over 10 hours last night. We've=20
> > looked on metalink etc, to no avail, any ideas?
> >=20
> > Thanks,
> >=20
> > Josh C.=20
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l