Caught YAPPing

2003-01-16 Thread Rajesh . Rao
Hello Everyone, Is there anything, called an "Average Response Time" for an Oracle database? I got a request from one of the application owners as under : < Snip> If I can get a log of AVERAGE response time for 1/2 hour periods starting at 9am and running thru 5 pm I would be in heaven. If I c

RE: Caught YAPPing

2003-01-16 Thread K Gopalakrishnan
Rajesh: You can schedule statspack snaps at 30 minutes interval and then compare the response times at each interval.. But the question is 'what do you mean by average response time?' KG Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Thursday, January

RE: Caught YAPPing

2003-01-17 Thread Cary Millsap
Raj, You can of course compute the average any list of numbers. However, if your list contains data from fundamentally different types of data, then your average will be meaningless. Example: A = {Response times for program 'a'} = {20:58.13, 42:19.28, 34:11.23} B = {Response times for program 'b'

RE: Caught YAPPing

2003-01-17 Thread Rajesh . Rao
ot;Cary Millsap" otsos.com> cc: Sent by: Subject: RE: Caught YAPPing