RE: How to calculate user load on the system
In Oracle 8.1.6 using autonomous transactions with a distributed query results in a 7445 error and a core dump. In 8.1.7.1 the error is trapped, reported ( I forget the error number, and no corp dump occurs. I don't know if that's what fixed means. Unless there was an additional fix in 8.1.7.2, you cannot use autonomous transacions in conjuction with a distributed query. Ian MacGregor Stanford Linear Accelerator [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 5:55 AM To: Multiple recipients of list ORACLE-L Yup I have logon triggers ... but I had to disable logoff triggers and DDL audit triggers because I used autonomous transactions to collect data. But in 816x, due to a bug, autonomous TX and distributed TX don't work well with each others. I am on 8161, this is fixed in 8172 I believe. 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: Sunday, January 20, 2002 4:30 AM To: Multiple recipients of list ORACLE-L Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Sorry Ian for the incorrect information. This behavior will be fixed in 9i R2 (whenever that is) according to Bug# 692232. 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: Tuesday, January 22, 2002 12:35 PM To: Multiple recipients of list ORACLE-L In Oracle 8.1.6 using autonomous transactions with a distributed query results in a 7445 error and a core dump. In 8.1.7.1 the error is trapped, reported ( I forget the error number, and no corp dump occurs. I don't know if that's what fixed means. Unless there was an additional fix in 8.1.7.2, you cannot use autonomous transacions in conjuction with a distributed query. Ian MacGregor Stanford Linear Accelerator [EMAIL PROTECTED] *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
RE: How to calculate user load on the system
Yup I have logon triggers ... but I had to disable logoff triggers and DDL audit triggers because I used autonomous transactions to collect data. But in 816x, due to a bug, autonomous TX and distributed TX don't work well with each others. I am on 8161, this is fixed in 8172 I believe. 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: Sunday, January 20, 2002 4:30 AM To: Multiple recipients of list ORACLE-L Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
Re: How to calculate user load on the system
Love is all you need. --- Rachel Carmichael [EMAIL PROTECTED] wrote: or, of course, the answer to life, the universe and everything is? --- Jared Still [EMAIL PROTECTED] wrote: If the question is Which episode of Star Trek was 'The Trouble with Tribbles', then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Hello all, My 2 cents' worth: Far too much time is spent by a number of users in the Oracle List sending e-mail of no worth whatsoever. Half the msgs I read are what charitably might be called 'chat'. I understand that there is an off-line site for 'chat' - why not use it and stop mucking up the e-mail waves with crap. Even a small drop in aimless e-mails would be appreciated; 90%+ directed, professional queries and replies would be wonderful. Please do not reply to this e-mail; this is my one-time attempt to bring about a positive change. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Love is all you need. --- Rachel Carmichael [EMAIL PROTECTED] wrote: or, of course, the answer to life, the universe and everything is? --- Jared Still [EMAIL PROTECTED] wrote: If the question is Which episode of Star Trek was 'The Trouble with Tribbles', then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET:
Re: How to calculate user load on the system
Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: How to calculate user load on the system
If the question is Which episode of Star Trek was 'The Trouble with Tribbles', then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Speaking of 42 ... In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move. --Douglas Adams Cheers, JoJo -Original Message- Still Sent: Sunday, January 20, 2002 1:30 PM To: Multiple recipients of list ORACLE-L If the question is Which episode of Star Trek was 'The Trouble with Tribbles', then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Sorry, you missed. The question is: what is the meaning of life, the universe and all the rest? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Sun, January 20, 2002 11:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to calculate user load on the system If the question is Which episode of Star Trek was 'The Trouble with Tribbles', then yes. ;) Jared On Sunday 20 January 2002 01:30, Mogens Nørgaard wrote: Yep. And we also found logoff-triggers in 8i to be useful for the same (and additional) purposes. But if I had to guess, I'm sure the answer would be 42 :-). Mogens [EMAIL PROTECTED] wrote: 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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?àãø_éçéàì? INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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; [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Raj - I found your question a bit unclear. Did you mean: - For 10 users, our application requires 50% of a 300-mhz CPU - There are two groups of users on the system. How do I figure out how many resources group A would use. I just thought you might get better assistance by clarifying your question. Thanks Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 2:27 PM To: Multiple recipients of list ORACLE-L Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases. Is anyone doing this? What is the best approach? Thanks in advance for your ideas ... 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA 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! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: How to calculate user load on the system
Take a look at V$SYSSTAT. I'm not sure if it's the answer because your question specifies a set of users. V$SYSSTAT includes all users not just a particular set. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases. Is anyone doing this? What is the best approach? Thanks in advance for your ideas ... 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Raj - I don't know DGUX, but if the users each have their own system login, the system administrator may be able to help. With forms, that may not help. From my experience, there isn't any ready way within Oracle. Another idea might be to sample the system load and number of users for each group from time to time and try to correlate system load by group. I've never tried that, though. If you have a test system, you could have group 1 run some representative work and measure the system load, then have group 2 run some representative work. That might give you a closer idea. Another thought. DB links can produce inefficient results. Are you sure that moving them to another system won't produce worse results? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 3:31 PM To: Multiple recipients of list ORACLE-L Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to calculate user load on the system
Thanks Dennis, Ian, Yes, that is another approach ... right now I am looking at what I can do within Oracle. As for DB links, very little stuff goes across for this application, so would not be a bottleneck right now. 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! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
RE: How to calculate user load on the system
Title: 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 PMTo: [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 *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
RE: How to calculate user load on the system
Title: 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 -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to calculate user load on the system Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (because it is their job). So, If I get some kind of metric (numbers ... numbers) then we might think of spinning these users and their application to another box in their own instance. They can talk to our application by db links, so that won't be a problem. I am looking for some kind of metric to either prove the need for another box and instance or otherwise. Hopefully this time it is little bit clear ... TIA 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!
RE: How to calculate user load on the system
Title: RE: How to calculate user load on the system Then you're in luck. I'd recommend starting withOracle 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 PMTo: 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 PMTo: [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