| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to calculate user load on the system
Raj,
Maybe another option would be to "audit session" for the database. For
each logon/logoff you would see the logical/physical reads and the logical
writes ( in dba_audit_session) by Oracle username (or osusername).
Chaim
"Aponte, Tony" <AponteT_at_hsn.net>@fatcity.com on 01/16/2002 06:15:24 PM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
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-----
Sent: Wednesday, January 16, 2002 5:54 PM
To: Aponte, Tony; ORACLE-L_at_fatcity.com
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-----
Sent: Wednesday, January 16, 2002 5:53 PM
To: ORACLE-L_at_fatcity.com
Cc: Rajendra.Jamadagni_at_espn.com
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Chaim.Katz_at_Completions.Bombardier.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 17 2002 - 08:59:42 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |