Oracle database on chevre.

[Xiaokang Pan]

 Doreen,

      Actually, the database problem happened on Wednesday. When somebody
 tried to insert or delete a very large data sets, he/she thought that it
 took too long time to finish the job and then quit before the Oracle
 system committed the work. As a result, the system had to roll back
 the work slowly, which may significantly slow down the database. After
 that several people tried to create and drop tables in the database, they
 found that it took too long time to finish the jobs, so, they quit again.
 The system had to do more roll back work and it slowed down further. I
 was trying to shut down the database in normal option so that the system
 can be quickly recovered but I couldn't shut down it normally.

      I had been trying to fixed this problem since Wednesday. Last night,
 I found a method to fix it.

      Xiaokang


On Sun, 14 Oct 2001, Doreen Ware wrote:

> Xiaokang,
> 
> Thanks for taking care of the problem.
> 
> Can you explain to me what happened on Monday.
> 
> Thanks,
> 
> doreen
> 
> 
> 
> 
> >  Ok. The Oracle database on chevre has been fixed. It should be no
> >problems when you create, drop tables, or update data in any account.
> >Please try it.
> >
> >     Have a nice weekend!
> >
> >     Xiaokang
> 
> 
> -- 
> ======================================================================
> Doreen Ware
> Cold Spring Harbor Laboratory			voice: (516) 367-6979
> Freeman Bldg.					fax: (516) 367-8389
> 1 Bungtown Rd.					email: ware at cshl.org
> Cold Spring Harbor, NY. 11724			url: www.gramene.org
> ======================================================================
>