On windows system, there is a huge difference of time between running CATALOG from 'DOS' Sqlplus and running from 'JAVA' SQLPLUS or SQLPLUS Worksheet. So always run from DOS on WIndows. The difference is greater than a factor 20 (My experience: 10' in DOS, 4H in JAVA).

You could stopped the JAVA task without problem and run it in DOS.


Degand Xavier

DX sprl


----- Original Message -----
From: "Adams Scott D. G6 - Contractor " <oracledba-ezmlmshield-x64233391.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: RE: Catalog.sql taking a long time
Date: Tue, 25 Oct 2005 14:45:44 -0400

>
> It can take that long. I find that to be the longest part a lot of time.
>
> Scott D. Adams
> Database Administrator
>
> -----Original Message-----
> From: Mathews Ansamma
> [mailto:oracledba-ezmlmshield-x91242927.[Email address protected]
> Sent: Tuesday, October 25, 2005 2:18 PM
> To: LazyDBA Discussion
> Subject: Catalog.sql taking a long time
>
> We have a 8.1.7 upgraded recently to Oracle 9.2
>
> Looks like there are some problems with some of the dictionary view. Tried
> to run catalog.sql and it
> seems to be taking too long. It has been running for last 1.5 hrs. How long
> it typically takes?
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page