-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|