Re: Oracle stops responding

Can you post the alert log file entries? Maybe there's something interesting there.

Other things to check:

• Are your 100000 deletes all in a single transaction? If so, check the undo/rollbacks for a space issue.
• How do you know it is dead and not merely taking it's sweet old time?

It sounds like you need to hire a DBA consultant to fine-tune this. It is unwise to do 100000 operations without taking care of how you are actually doing the operations. Maybe they do not need to be in a single transaction, maybe it's the wrong way to benchmark you new Oracle database.

> I am experiencing some problems with an Oracle 9.2.0.1 database on RedHat
> 8.0 (I know it is not a supported plattform by Oracle...)
>
> My hardware is a dual Xeon system with 2 GB memory.
>
> The problem is as follows:
> From time to time Oracle stops responding. From what I have seen this can
> occur when I try to delete lot of records (for instance 100000 or more)
> from a table.
> When connecting with sqlplus from another machine, sqlpus is unable to
> connect to the database.
> When i try to shut restart Oracle (by using "service oracle stop") the
> instance is not shut down.
> To make Oracle respond again i have to perform a ssh connection to the
> server running Oracle, and do the following:
>
> su - oracle
> sqlplus /nolog
> connect sys/password as sysdba
> shutdown abort
> startup
>
> "shutdown immediate" make no success.
> After this procedure all seems to be working again.
>
> The server is being tested before going into production, and I sure would
> like to have this problem solved as soon as possible.
>
> Anyone that can give me some hints to what can solve the problem.
>
> --
> Regards,
> Tore Skogly
> Senior IT consultant

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Feb 19 2003 - 11:52:17 CST