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

Hi Patrick,

maybe i can help a little.

Patrick Tan wrote:

> 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?

For this operations you need the PERFORMANCE PACK for Enterprise Manager.

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

A very good tool for performance tuning is SQLab from Quest Software. You can download from 'www.quest.com'.

>
>
> Thanks,
> -Patrick-

RegardsUlrich Waldt Received on Fri Dec 05 1997 - 00:00:00 CST