Re: Drop user takes too long

drop the tables first then the user and see how long the whole process takes.
spool droptabs.sql
select 'drop table '||owner||'.'||table_name||';' from dba_tables where owner='THE USER' order by table_name;
spool off
_at_droptabs.sql
drop user ...

Jim
"Eric Nguyen" <nguyenq_at_supernet.ca> wrote in message news:idrV7.11148$xB4.1624835_at_brie.direct.ca...
> Jim,
> That exactly my point,
> SQL>drop user blah; -- 100 tables+ 200 indexes
> and I sit there, and watch for 2 hrs;
> Any suffestions here. What should I change to make it run faster ?
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
> news:H18V7.1929$6p.15889_at_rwcrnsc54...
> > Do you mean:
> >
> > drop user blah;
> >
> > takes 2 hours?
> > That seems very unusual.
> > Jim
> > "Eric Nguyen" <nguyenq_at_supernet.ca> wrote in message
> > news:lm7V7.10999$xB4.1593624_at_brie.direct.ca...
> > > Hi,
> > > Can someone explain to me why Oracle needs 2 hours to drop a user
 ?
 I
> > > have Oracle 8.1.7 on unixware , drop a user with 100 tables and 200
 indexes
> > > takes normally 2 hours, same set up in Linux takes approx 15 minutes.
 Both
> > > system have approx 700Meg SGA and 500 Meg Rollback segments on a 2GIG
 Ram
> > > machines.
> > >
> > > I mean 2 hours is exetremely long, What should I verify in my
 setup
 ?
> > >
> > > Thanks for your help.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >

>
> Received on Sun Dec 23 2001 - 22:50:02 CET