You can read all about it at: http::/www.oreilly.com/catalog/oracleperl and http://www.amazon.com/exec/obidos/tg/detail/-/0596002106
:) Jared On Saturday 26 October 2002 20:59, Leonard, George wrote: > 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).