As an addition to Roracle, feel free to use following script ( on the
client in the ext folder ) to chart ( ncv ) tablespace usage:
================
#!/usr/local/bin/python
import os
import sys
import cx_Oracle
import StringIO
import socket
import time
import string
#
BB = os.environ["BB"]
BBTMP = os.environ["BBTMP"]
BBDISP = os.environ["BBDISP"]
os.environ['BBPROG'] = 'ora-tbs.py'
TEST = 'oratbs'
os.environ['TEST'] = TEST
MACHINE = socket.gethostname()
MACHINE = string.replace(MACHINE, '.', ',')
DATE = time.strftime("%a %b %d %H:%M:%S %Z %Y",
time.localtime(time.time()))
connection = cx_Oracle.connect("dbuser/password")
sql = """ SELECT F.TABLESPACE_NAME,
TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USED (MB)",
TO_CHAR (F.FREE_SPACE, '999,999') "FREE (MB)",
TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTAL (MB)",
TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')
PER_FREE
FROM (
SELECT TABLESPACE_NAME,
ROUND (SUM (BLOCKS*(SELECT VALUE/1024
FROM V$PARAMETER
WHERE NAME = 'db_block_size')/1024)
) FREE_SPACE
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME
) F,
(
SELECT TABLESPACE_NAME,
ROUND (SUM (BYTES/1048576)) TOTAL_SPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME
) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME ORDER BY 1
"""
cursor = connection.cursor()
cursor.arraysize = 50
cursor.execute (sql)
i1 = cursor.fetchall()
output = StringIO.StringIO()
for z in range(i1.__len__()):
print >> output, i1[z][0].ljust(15) + " : " + i1[z][4]
L0 = output.getvalue()
output.close()
COLOR = 'green'
LINE = "status " + MACHINE + "." + TEST + " " + COLOR + " " + DATE + "
Tablespaces on " + MACHINE + '\n' + L0
cmd = BB + ' ' + BBDISP + ' "' + LINE + '"'
os.system(cmd)
===============
Alexander Levin
From: Ryan Jay B. Lapuz [mailto:user-945139049f37@xymon.invalid]
Sent: Wednesday, November 07, 2007 4:59 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Roracle
Hi sir!
I'm running oracle on solaris sparc. Could you please help me make it
work. Right now I'm still monitoring tablespace manually because I was
not able to implement it with hobbit. Please make the procedure as
simple as possible because I have limited knowledge in oracle.
Thank you very much!
Ryan
----- Original Message -----
From: Everett, Vernon <mailto:user-9da1a1882f49@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
Sent: Wednesday, November 07, 2007 7:38 AM
Subject: RE: [hobbit] Roracle
Hi Stefan
If by Roracle you refer to bb-roracle script available from
deadcat, then yes, I have used it. (This contract, a few years back.
Still have the scripts and ksh binary)
Damn useful, once you get it working. Gave some good info. I
don't think it did any graphing, but I may be wrong.
The problem I encountered had to do with the subtle differences
between different implementations of ksh. I suspect this is where you
are getting stuck too.
Yes, ksh differs from one version to the next, and the
implementation I had on my server (Solaris Sparc) was just never going
to work.
Eventually, I got so fed up, I downloaded a different version of
ksh, and put it in the ~hobbit directory structure, and changed the #!
line to point to the new ksh.
It was a horrible fix, but the best I could do under the
circumstances. :-(
If you are running Solaris on Sparc, I can send you what I have,
but if you on a different architechture and OS, you are pretty much on
your own.
Cheers
V
From: Stefan van der Walt [mailto:user-651f11aa7267@xymon.invalid]
Sent: Tuesday, 6 November 2007 10:18 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] Roracle
Have any of you installed this addon into hobbit?
The instructions are sparse, and I just need to know how to get
the client to know the
addon is there?
Thanks
Stefan
NOTICE: This email and any attachments are confidential.
They may contain legally privileged information or
copyright material. You must not read, copy, use or
disclose them without authorisation. If you are not an
intended recipient, please contact us at once by return
email and then delete both messages and all attachments.