Hi Jared Someone mentioned that you have a perl+dba tool set, would you mind telling us more about it, etc etc.
Sorry guys but it is 02:56 and I am monitoring a db build, (100GB) need things to amuse me. Thx Ps: thx for all the people that send me scripts on how to monitor rollback segment usage by a session. Below is a modification of what was send to me by Kevin Lange [[EMAIL PROTECTED]]. Thx Kevin, One of the developers here are writing a little Delphi app as a front end for it to show using some nice graphics the output that is then further drill down-able to the actual query and more information about the relevant session. set lines 300 column name format a7 column sid format 9999 column serial# format 99999 column username format a10 column machine format a25 column status format a10 column cr_get format 99,999,999 column phy_io format 9,999,999 column used_ublk format 99,999,999 column "DB User" format a10 column "Sql Hash" format 9999999999 column command format a30 column "MB" format 99,999 column "MB Used" format 99,999.99 column "Start Time" format a18 column "%" format 99.99 SELECT r.NAME, -- rbs name s.sid, s.username, t.status, t.cr_get, -- consistent gets t.phy_io, -- physical IO t.used_ublk, -- Undo blocks used round(sg.blocks * ts.blocksize / 1048576, 2) "MB", (t.used_ublk*8192)/1024/1024 "MB Used", ((t.used_ublk*8192)/1024/1024)/(round(sg.blocks * ts.blocksize / 1048576, 2))*100 "%", s.sql_address "Address", s.sql_hash_value "Sql Hash", t.start_time "Start Time", s.machine, SUBSTR (s.program, 1, 78) "COMMAND" FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r, v$rollstat ss, sys.undo$ ud, sys.seg$ sg, sys.ts$ ts where ud.us# = ss.usn (+) and ud.file# = sg.file# and ud.block# = sg.block# and sg.ts# = ts.ts# and ss.usn = r.usn and t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_time; George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -----Original Message----- Sent: 27 October 2002 03:18 AM To: Multiple recipients of list ORACLE-L I seem to be missing part of this thread, and have been gone most the week. Re SNMP: I haven't played with it myself, but there are ~100 Perl modules dealing with SNMP. It would take some research to determine which are the most useful, and go from there. Definitely doable. Maybe "Perl for DBA's" 2nd edition. :) Jared On Wednesday 23 October 2002 16:16, John Kanagaraj wrote: > Raj, > > I looked at the TCL scripts that comes along with OEM, and did see that > SNMP is being used therein. If TCL can do it, I am sure Perl can do it. > Jared - Any inputs? > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > What would you see if you were allowed to look back at your life at the end > of your journey in this earth? > > ** The opinions and statements above are entirely my own and not those of > my employer or clients ** > > > -----Original Message----- > Sent: Wednesday, October 23, 2002 3:20 PM > To: Multiple recipients of list ORACLE-L > > > > Thanks Dennis, Gary > > I have tools at my disposal to monitor the db, and I have no problem with > that. I was just reading through snmp and was intrigues by the idea that I > could get some information without running scripts through sqlplus > interface and if so how to accomplish that. > > I know it is doable because IA does that, just wondering if it would be > feasible to do it be some scripting ... > > 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----- > <mailto:DWILLIAMS@;LIFETOUCH.COM> ] > Sent: Wednesday, October 23, 2002 6:04 PM > To: Multiple recipients of list ORACLE-L > > > Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable > will reply. I believe that SNMP underlies most of the monitoring tools on > the market today. OEM may even use SNMP. I can see two approaches for you. > 1. You write your own tool that will issue SNMP alerts. Perhaps this > would be a Unix daemon process that executes database queries, and then > based on what it finds, issues SNMP alerts. > 2. Use an existing tool to accomplish what you want. > > If your desire is to create a database monitoring tool that you can give > away for free, then sell to CA for a lot of money, take path #1. If your > goal is to become a better DBA, then I would go with #2. > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] < mailto:dwilliams@;lifetouch.com > <mailto:dwilliams@;lifetouch.com> > > > -----Original Message----- > Sent: Wednesday, October 23, 2002 4:39 PM > To: Multiple recipients of list ORACLE-L > > > > Has anyone implemented basic DB monitoring using snmp MIB information > rather > > than running queries against the db? > > I am looking into this and have no clue or available docs on how to do this > (esp on AIX). If someone can point me to the right direction, I would > really > > appreciate that. > > 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).