Hi,
We are running Oracle 8i on a Solaris platform. Our tables have a maximum row size of 150,000 rows. We have our production and development schema on the same database. While developing we happen to run some wrong queries like joining a couple of tables without joining properly. Thus, the database cpu usage goes to maximum and slows down all queries in the production schema as well. Even though the query returns a value, our database slows down fully and only after we restart our system does the database come back to its original speed.

PS: I am not a Database Administrator, but I need to resolve this issue. Can somebody please help me.

Thank you,
Vidya