Re: Management Reports
This type of request is entirely too common. The problem is that measuring the performance of an Oracle system isn't like measuring the performance of a car in the Indy 500 by timing laps, but that is typically the perception of those asking. At my last employer, we developed application-specific performance monitors - how many orders pending at each stage of the process (approval, submitted, filled, etc.), average processing time (overall and per phase), etc. It was much more useful for identifying problems. Of course this added non-trivial load to the system. The best such single measure chart I've ever seen was part of the Precise (nee Savant) Diagnostic Center. It was the response time of the periodic poll to gather information. Other products may have something similar. What are you trying to measure? If it is generic response time, that approach might work. If you don't have anything already, you could write something that pulls some statistics periodically (not too often) and time it on each run, graphing how long it takes. Beware of the Heisenberg uncertainty principle though. The act of detection will likely influence the results. Performance problem may appear and disappear between polls - not showing up. Increasing the frequency of the poll will further denigrate the overall performance. This is a Pandora's box of potential issues. Also beware that an application-independent generic performance graph will not always reflect what the users see (e.g. due to application-specific issues - locking, etc.). Generic response time may not be what they want - and probably isn't. One problem with this approach is that often the generic response time is best when the application performance is at its worst! Why? Something else in the stack goes into a catatonic state so that the instance/database is freed up to service the response time query faster. I've seen it happen many times. [Actually, this can be a plus. Scenario: Them: Quick! Check the database! It seems slow! Me: No, its actually running much faster than normal. It seems that the app isn't submitting any/much work.] Another possible alternative is the Etch-a-Sketch approach. Give them whatever kind of nonsense appeases them to get them off your back so you can do useful work ;-) Of course, there are potential issues with this as well! Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 10:33 AM Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Management Reports
your ass :-) -Original Message- Sent: 13 June 2002 16:33 To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Management Reports
Keep the report short, just a page once a week, and have three key things highlighted -- your most important measurements of performance. People like to skim a report and focus on a few key things. A good idea for these metrics just might be the three most critical business transactions. A performance report could show whether they complete in a timely manner, week after week. That's the definition of performance, right? Simply measure how long they take - perhaps via trace/TKPROF. Keep the detailed TKPROF reports in a notebook and just provide Elapsed Time Total number for the management report. You could have these three totals in three graphs, so as weeks go by they can watch the graphs fill in and see if they are taking more, less, or the same amount of time to complete. Besides this there could be an optional Other Items section you sometimes include, in which you suggest ideas, report successes, or beg for more disk drives. ;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Management Reports
Title: RE: Management Reports I'm currently working on producing statistics for mid-managers. We have a lot of tools that collect statistics for our 30 production databases so my challenge it to map their individual repositories with the categories I want to report. But these are the categories I'm proposing, and they can be collected from v$ views and application tables: Total CPU time used DISK I/O counts Network I/O counts Session count (peak and average) Total number of Oracle transactions Total number of application transactions (the logical unit of work for the application. i.e. orders taken for our Order Entry app., packages shipped forFulfillment, IVR calls, outbound calls placed, etc.) HTH Tony -Original Message-From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 12:26 PMTo: Aponte, Tony; [EMAIL PROTECTED]Subject: RE: Management Reports Tony: Scorecard/historical. My management would not know what to make of a Spotlight screen if they sat on it. Can I say that? Mike -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 8:33 AMTo: [EMAIL PROTECTED]Cc: Vergara, Michael (TEM)Subject: RE: Management Reports Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?) Tony Aponte -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Management Reports Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Management Reports
Mike, Get him the free version of Quests Spotlight on Oracle. Puts a pretty interactive chart up on his screen. Green means good. Yellow means caution, Pink means almost danger. Red means bad. This should be a good start for him! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Mercadante, Thomas F 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: Management Reports
Title: RE: Management Reports Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?) Tony Aponte -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Management Reports Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Management Reports
Anything looking resolutely optimistic. Seriously, it means nothing. A database is not 'performant' per se, it's just layers of software easing the coding work to access and concurrently update data stored in file (sorry to be so down to earth). If developers have done a bad job, it will be slow, but do not blame the database. If you are attempting to manage terabytes of data on a second-hand machine which was an entry-level server 5 years ago, do not expect miracles either. The best you can do is provide 'availability' charts, showing when your database was up - you can getr this from the alert.log file. And check V$SQLAREA to get performance-killers - bad queries, that is. This is your insurance policy when your boss will come back to you saying 'users complain about DB performance' (IMHO it must already be the case, s/he wouldn't have thought about a report otherwise). - Original Message - From: Vergara, Michael (TEM) [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 13 Jun 2002 07:33:27 Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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). === --- - Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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: Management Reports
Log switches. This is a pretty good indicator of database usage. I haven't documented where I got this script but I've found it useful. Multiply log switches by log size and you have a very rough indicator of how many bytes per hour your database is doing. Management might understand that better than log switches. --oracle8_log_switch.sql select to_char(first_time,'MM/DD') day, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'00',1,0)),'99') 00, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'01',1,0)),'99') 01, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'02',1,0)),'99') 02, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'03',1,0)),'99') 03, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'04',1,0)),'99') 04, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'05',1,0)),'99') 05, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'06',1,0)),'99') 06, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'07',1,0)),'99') 07, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'08',1,0)),'99') 08, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'09',1,0)),'99') 09, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'10',1,0)),'99') 10, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'11',1,0)),'99') 11, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'12',1,0)),'99') 12, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'13',1,0)),'99') 13, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'14',1,0)),'99') 14, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'15',1,0)),'99') 15, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'16',1,0)),'99') 16, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'17',1,0)),'99') 17, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'18',1,0)),'99') 18, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'19',1,0)),'99') 19, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'20',1,0)),'99') 20, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'21',1,0)),'99') 21, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'22',1,0)),'99') 22, to_char(sum(decode(substr(to_char(first_time,'HH24'),1,2),'23',1,0)),'99') 23 from v$log_history group by to_char(first_time,'MM/DD') order by 1 Vergara, Michael To: Multiple recipients of list ORACLE-L (TEM) [EMAIL PROTECTED] mvergaracc: @guidant.comSubject: Management Reports Sent by: root 06/13/2002 11:33 AM Please respond to ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Thomas Day INET: [EMAIL PROTECTED] Fat City Network
RE: Management Reports
Tom - I like your style! Hit 'em when they are asking for it. If he just wants some color charts printed daily a creative solution from Don Burleson in his Oracle High-Performance Tuning with STATSPACK book is to get the statistics by doing queries on the STATSPACK tables and using grep and other Unix utilities to create some columns. Then cut and paste the data into Microsoft Excel. It produces good charts but it is a little time-consuming, so I like Tom's suggestion overall. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 13, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Mike, Get him the free version of Quests Spotlight on Oracle. Puts a pretty interactive chart up on his screen. Green means good. Yellow means caution, Pink means almost danger. Red means bad. This should be a good start for him! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Mercadante, Thomas F 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: 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: Management Reports
Title: RE: Management Reports Tony: Scorecard/historical. My management would not know what to make of a Spotlight screen if they sat on it. Can I say that? Mike -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 8:33 AMTo: [EMAIL PROTECTED]Cc: Vergara, Michael (TEM)Subject: RE: Management Reports Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?) Tony Aponte -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Management Reports Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Management Reports
LOL! But I'm already in the doghouse, so I don't think they'd see it as funny! -Original Message- Sent: Thursday, June 13, 2002 9:23 AM To: Multiple recipients of list ORACLE-L hi! select 1998, 'a lot to do' from dual; select 1999, 'even more to do' from dual; select 2000, 'ph ' from dual; select 2001, 'at full speed' from dual; select 2002, 'increase the DBAs salary from dual'; my boss was delighted about it daniel Vergara, Michael (TEM) wrote: Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Daniel Wisser 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: Vergara, Michael (TEM) 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: Management Reports
Dennis, I see your %OCP is growing! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Tom - I like your style! Hit 'em when they are asking for it. If he just wants some color charts printed daily a creative solution from Don Burleson in his Oracle High-Performance Tuning with STATSPACK book is to get the statistics by doing queries on the STATSPACK tables and using grep and other Unix utilities to create some columns. Then cut and paste the data into Microsoft Excel. It produces good charts but it is a little time-consuming, so I like Tom's suggestion overall. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 13, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Mike, Get him the free version of Quests Spotlight on Oracle. Puts a pretty interactive chart up on his screen. Green means good. Yellow means caution, Pink means almost danger. Red means bad. This should be a good start for him! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Mercadante, Thomas F 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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: Management Reports
Mike, My suggestion was silly, I agree. But it forces management to come up with a better question. How's the database running? is as silly a question as you asking your child How you feeling today?. Both answers are a flat fine. I would suggest you have a dialogue to ask what kind of information are they looking for? You already received a few decent ideas - # of log switches a day - a relative indicator of update usage; # hours per day/week/month database is available suck data from STATSPACK and put it into Excel showing disk/tablespace i/o etc. You mentioned that you were already in trouble - not sure what you meant by this, but start a discussion with your boss to figure out what he is looking for. Find a way to get out of trouble :) hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 1:30 PM To: Multiple recipients of list ORACLE-L LOL! But I'm already in the doghouse, so I don't think they'd see it as funny! -Original Message- Sent: Thursday, June 13, 2002 9:23 AM To: Multiple recipients of list ORACLE-L hi! select 1998, 'a lot to do' from dual; select 1999, 'even more to do' from dual; select 2000, 'ph ' from dual; select 2001, 'at full speed' from dual; select 2002, 'increase the DBAs salary from dual'; my boss was delighted about it daniel Vergara, Michael (TEM) wrote: Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Daniel Wisser 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: Vergara, Michael (TEM) 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: Mercadante, Thomas F 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: Management Reports
Thomas said: How's the database running? is as silly a question as you asking your child How you feeling today?. Both answers are a flat fine. My two year old would respond with don't know !!, could be a manager in the making or maybe a NT admin :-) But I had also wondered what the already in trouble was, get a clear dialogue going as to what is his pain so you can resolve it. And if you don't think you can resolve it polish the resume because whatever you do you may well find yourself bundled out of there sooner or later anyway. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-06-2002 10:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Management Reports Mike, My suggestion was silly, I agree. But it forces management to come up with a better question. How's the database running? is as silly a question as you asking your child How you feeling today?. Both answers are a flat fine. I would suggest you have a dialogue to ask what kind of information are they looking for? You already received a few decent ideas - # of log switches a day - a relative indicator of update usage; # hours per day/week/month database is available suck data from STATSPACK and put it into Excel showing disk/tablespace i/o etc. You mentioned that you were already in trouble - not sure what you meant by this, but start a discussion with your boss to figure out what he is looking for. Find a way to get out of trouble :) hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 1:30 PM To: Multiple recipients of list ORACLE-L LOL! But I'm already in the doghouse, so I don't think they'd see it as funny! -Original Message- Sent: Thursday, June 13, 2002 9:23 AM To: Multiple recipients of list ORACLE-L hi! select 1998, 'a lot to do' from dual; select 1999, 'even more to do' from dual; select 2000, 'ph ' from dual; select 2001, 'at full speed' from dual; select 2002, 'increase the DBAs salary from dual'; my boss was delighted about it daniel Vergara, Michael (TEM) wrote: Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Daniel Wisser 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
RE: Management Reports
Give your damagers a Quest Spotlight monitor ! It has all the nice gui stuff that damagers like to see, and they feel good about it. Plus it is different colours, which gives them the illusion they actually know what is going on inside and lets them think they are in control ! As for you, set up a real-time monitoring filter on your alert log, at least you know exactly why your sphincter suddenly tightens at the sight of ORA-00600 in your production DB alert log. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Please note 17 hour time difference between Melbourne and CA Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Thursday, 13 June 2002 8:33 AM To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Ferenc Mantfeld 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: Management Reports
On a more serious note, I have had to do this for my damagement team at a previous engagement. They wanted a shell script to execute every 15 minutes, tell them how many users were logged in (up to 2,500), and the timing for a simple query on some customer table, for which they had benchmarked results, and then to post this via XML to a web page which they could click on anytime to see the near-real-time 'performance' of the database. Easy enough, write a shell script, invoke it with cron, and send the results to awk which will get the necessary data and then do some web development magic to display the results to whomever is behind the firewall and is interested. Alternatively, if you're a masochist, do this in Oracle forms or VB. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Please note 17 hour time difference between Melbourne and CA Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Thursday, 13 June 2002 9:13 PM To: Multiple recipients of list ORACLE-L Give your damagers a Quest Spotlight monitor ! It has all the nice gui stuff that damagers like to see, and they feel good about it. Plus it is different colours, which gives them the illusion they actually know what is going on inside and lets them think they are in control ! As for you, set up a real-time monitoring filter on your alert log, at least you know exactly why your sphincter suddenly tightens at the sight of ORA-00600 in your production DB alert log. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Please note 17 hour time difference between Melbourne and CA Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Thursday, 13 June 2002 8:33 AM To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Ferenc Mantfeld 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: Ferenc Mantfeld 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).
