Re: drop user user_name cascade - question

On Sat, 12 Oct 2002 13:33:20 +0200, "Tom Miskiewicz" <miskiewicz2_at_no.spam.yahoo.com> wrote:

>Hello!
>
>I issued the drop user command as above. I know it can take some time to
>complete
>this operation, but can anyone tell me how long? Is there a way to check it
>Oracle
>is really doing something or if it hangs under Solaris? Top doesn't show
>much activity
>on the CPU or disks, is that ok?
>
>
>Thanks
>
>Tom
>

The time needed depends on the number of objects to be dropped and above all the number of extents used.
One easy way to check is to run repeatedly from a different session select object_type, count(*) from dba_objects where owner = '<user_to_be_dropped>' group by object_type

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Oct 12 2002 - 07:37:52 CDT