Fine-Tuning and Monitoring: Can oracle 7.3.3. Enterprise Manager for NT help?

Hello,
I am currently experiencing problems with my Production Oracle Database. It is extremely slow in inserting records into certain tables lately.

We realize we made several mistakes such as:

• Using too many views to simplify SQL statements (reduces table joins).
• Too many constraints which caused lots of checking prior to deletion.
• Defragmented Tablespaces.

Does anyone know how I might be able to

• use Enterprise Manager to monitor performance problems, defragmentation etc?
• Any SQL queries which takes more than 10 secs to execute?

Any recommendations on tools (commercial or otherwise) which could help us improve
a Production Database's performance?

Thanks,
-Patrick- Received on Sat Nov 22 1997 - 00:00:00 CST