Re: OMLETv4 - Configuration Questions

omar_adebisi_at_hotmail.com (Simon Adebisi) wrote in message news:<f1e58c26.0406161859.8773cd0_at_posting.google.com>...
> Amjad:
>
> As another former Oracle employee, I sympathize with having to contend
> with less experienced posters on these groups. Hang in there matey!
>
> Now a question for you....
>
> I have built a consulting practice on advanced performance tuning (hit
> ratios, I/O distribution, sql tuning and the like). Is the OMLETv4
> tool configurable to allow me to place my more critical metrics on top
> of the queue? For instance, as we all know, the Database Buffer Cache
> Hit-Ratio must be kept above 98%.....Can I take this critical metric
> and have it appear atop the output?
>
> Second, can I quickly detect and display colocated index and data
> segments in a single tablespace before they cause a complete
> performance degradation. We always separate the data and index
> segments by tablespace (i.e., spindle) on our on JBOD.
>
> Cheers Mate,
>
> Simon Adebisi, OCP, MBA
> Sr. Oracle Database Consultant

Simon,

Thank you for your support. Do not bother with the hog wash. Hit ratios are going to out-live the fools you talked about. They must have flunked their OS courses!.

I worked in the Sabre group/American Airlines for years as on-call DBA with the greatest DBA's in the world and we chose to deliver various hit ratios to our pagers 24 hours/day. I must admit that ratios are symptyms and you would need to look for causes, etc. But if your son's temp is above 40 degrees ..

Anyhow, I saw a bunch of the runners between offices who were lawyers-turned-dba's: HOGWASH! Received on Thu Jun 17 2004 - 10:56:41 CDT