Re: Oracle 8.1.7 On Suse 8.0 (Statement processed)

Have you checked the alert log? If its in archivelog mode it may have hung if it filled up the filesystem where it
writes the archived logs too. Alert log will tell you.

    Can you connect via svrmgrl from another session.     Is oracle burning up the cpu (run top).     Any operating system error messages (dmesg).     Is there constant swapping (vmstat 1 10) ?????

Are you getting a continous list of "Statement processed?" how quick are they apart?
Have you sized the SGA too big or too small?

Liggs

"Tonton David" <akim_ziadi_at_hotmail.com> wrote in message news:3e5f79fb_1_at_news.vo.lu...
> Hello Gentlemen,
>
> We have installed Oracle 8.1.7 on Suse 8.0, We create a database Test for
> ( Use recommanded installation with private database file) the
installation
> finish well everything is OK/
> Now before we try to install the Database for the application we run
script
> catalog.sql and after few second i got this message whitout stopping, i
> leave it running 1 day. It apparenly loop or smoething like that.
> Statement processed
> Statement processed
> Statement processed
> Statement processed
> It's does not give me the svrmgrl prompt.
> Where can come from the problem ?
> Thanks a lot
>
>
>
>
>
Received on Fri Feb 28 2003 - 14:51:08 CST