Trying to learn Oracle and taking the OCP-track now.

Have installed Oracle 9i Release 2 on my Win XP Pro PC at home for
testing puposes. Everything was OK, but now suddenøy SQL*Plus has
gotten really slow.

CONNECTs, DESCs, CREATE TABLE and INSERT INTO work OK.
SELECT takes ages if I get a result at all.

If I run the same select as the same user in iSQL*Plus I get the
results at once. What's wrong?

Tried to uninstall and reinstall again, but no change. Just the one
difference that I had to give tha base another SID as the first one
probably was still in Registry, bur as I said this started before my
reinstall of Oracle so that's not the problem.

BTW: Is there a page that list what has to be removed manually to get
rid of an Oracle installation completely? Tried to search on OTN, but
either my search skills are no good or there are no articles about it
there.
--
When I'm fighting, it's like the whole world goes away.
I only know one thing: that I'm gonna win, and they're gonna lose.
I *like* that feeling.

Frank T. Rambøl wrote:

> Update:
>
> If I go into the File-menu and select Cancel I get the results.
> If the results go over several pages I get one page of a time each time
> I select cancel.
>
> This be strange, or maybe not? Is there a setting somewhere that has
> changed itself?
>
> All help is very much appreciated as this is a real nuisance.
>
> - Frank

SQL> Set pause off [-- on => hit enter to get next (and first) page.]

Svend

Ed prochaks fingre fremførte følgende fornøyelige frase:

> Almost sounds like you have PAUSE mode set ON

Thanks to the both of you but I remembered that setting a little
earlier tonight and you are right. It was set to ON.
Don't know how and when that could have happened as I never play with
those settings. Maybe a friend tried to be funny.

Oh well, problem is solved.
--
When I'm fighting, it's like the whole world goes away.
I only know one thing: that I'm gonna win, and they're gonna lose.
I *like* that feeling.