RE: How to calculate user load on the system

[Aponte, Tony]

Title: RE: How to calculate user load on the system

Then you're in luck.  I'd recommend starting with Oracle Response Time Analysis from www.orapub.com.  Although it won't give you exactly what you need, it will help you get to the next step.  Once you understand a session's response time components, it's a short hop to figuring out the V$SESSTAT statistics that make up the CPU time, physical/logical I/O operations and memory footprint.

 

HTH

Tony

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 5:54 PM
To: Aponte, Tony; [EMAIL PROTECTED]
Subject: RE: How to calculate user load on the system

Database Load ... is the main target at this time ...

 

Thanks Tony,

 

Raj

______________________________________________________

Rajendra Jamadagni              MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com

Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: Aponte, Tony [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 5:53 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: How to calculate user load on the system

Raj, sorry for me being confused.  Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)?

Tony