Re: DROPPING v7.0.x USERS

In article <36v4ci$24u_at_yoda.Syntex.Com>, ucdy_at_rvax.syntex.com () writes:
>
> Does anybody know how to reduce the time required for
>
> DROP USER <user> CASCADE;
>
> statements to execute? We have tried dropping all user objects and grants
> before issuing the drop command, but it doesn't seem to make much difference.
>
> Currently it takes anywhere from 6 to 30 minutes to drop users.
>
> Any info appreciated.
>
> Chas. Dye

I seem to remember that there is a bug about this. Check to make sure that your data dictionary indexes have been created. For example, make sure that the i_obj2 and i_objauth2 indexes exist. If not, get their definition from SQL.BSQ and create them.

You could set sql_trace to true and use TKPROF with EXPLAIN to find out exactly what ORACLE is doing behind the scenes.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285