| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DB monitoring using SNMP MIBs
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
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 "%",
t.start_time "Start Time", s.machine,
v$rollstat ss,
sys.undo$ ud,
sys.seg$ sg,
sys.ts$ ts
where ud.us# = ss.usn (+)
and ud.file# = sg.file#
and ss.usn = r.usn
and t.addr = s.taddr
AND t.xidusn = r.usn
ORDER BY t.start_time;
George
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonard, George INET: george.leonard_at_farnell.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).Received on Sat Oct 26 2002 - 22:59:10 CDT
 |
 |