RE: [hobbit] Roracle

["Levin, Alexandre" <alevin (at) reveredata.com>]

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:rlapuz (at) fcpp.fujitsu.com]
Sent: Wednesday, November 07, 2007 4:59 PM
To: hobbit (at) hswn.dk
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:Vernon.Everett (at) woodside.com.au>

	To: hobbit (at) hswn.dk

	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:skjoldar (at) gmail.com]
	Sent: Tuesday, 6 November 2007 10:18 PM
	To: hobbit (at) hswn.dk
	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.