Re: DB monitoring using SNMP MIBs

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 [kgel_at_ppoone.com].
>
> 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:george.leonard_at_za.didata.com
> 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_at_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.
> > dwilliams_at_lifetouch.com < mailto:dwilliams_at_lifetouch.com
> > <mailto:dwilliams_at_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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).