Lion Soft Inc.

Excel Reporting Solution Provider

  • Home
  • Products
    • Tools for Oracle Reports
      • Rep2excel
      • Rep2excel Server
      • RepExpert
    • EasyHA Monitoring Tools
    • GTD Excel Report Server
    • Command Line Send Email Component
    • Rapid Word/PDF Reporting Tool
  • Purchase
    • Rep2excel & Rep2excel Server
    • RepExpert
  • FAQ
    • Rep2excel & RepExpert
    • EasyHA
  • Blog
    • Excel Reporting
    • Monitoring
    • Rep2excel

How to run java-rep2excel as Windows service

August 24, 2015 williamsvoon Monitoring

The java-Rep2excel is web-based application, although you can control it via Win32 GUI application. You may want the java-Rep2excel to be running even though you log off the Windows desktop. So you need to run java-Rep2excel as service.

 

How TO

The following steps guide you through the installation of Windows service.

 

  1. Open java-Rep2excel GUI manager, click Server, and then “Install/Uninstall Service”.
  2. The service will be installed. And in case the server has been installed before, and the server will be uninstall if you click the button again.
  3. Run services.msc, you will see the entry of java-rep2excel server in the list of service (local). You can start/stop the service by this command:

 

net start “j-Rep2excel Server”

net stop “j-Rep2excel Server”

 

Note

Please upgrade the version 1.60 or above in case you need the feature. Because there is bug in the version prior to version 1.60.

 

 

Oracle tablespace growth and usage monitoring by EasyHA

August 13, 2015 williamsvoon Monitoring

I want to create a mechanism to monitor growth of our oracle tablespaces and how much space is used in them. 

Step by Step Guide

1. Configure JDBC connections.

Provided you have install the free version of EasyHA, before you monitor your databaseDescription: build-conn-helper.pngs and business data (like tablespace usage), you should please create JDBC database connection to your Oracle database.

To create JDBC connection, please click “Setup” menu, and then click “Databases Overview” button. In the “Jdbcs” page, please click “Add Jdbc” button.

The “New Jdbc” form appears, it is very easy to fill in the form. You can also click “Help” link if you don’t know how to fill in URL box.

 

Now I have created a connection named gnbsprd-ozq. The settings of the connection is listed below:

2. Create item that will monitor your tablespace usage.

  1. Click “Items” menu.
  2. Now you will see the list of items.
  3. Click “Add Item” button in right upper corner.
  4. Select “Biz Data Monitor” from item type list.
  5. Select DB and fill in the SQL statement.
  6. Fill other fields like interval and description of field #1.
  7. Submit the form and review the item. The item looks like this:

 

The SQL statement is very critical.  This is sample SQL.

SELECT 
  D.TOT_GROOTTE_MB "SIZE MB",
  D.TOT_GROOTTE_MB – F.TOTAL_BYTES "USED SPACE MB"
  FROM (SELECT TABLESPACE_NAME,
  ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES,
  ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES
  FROM SYS.DBA_FREE_SPACE
  GROUP BY TABLESPACE_NAME) F,
  (SELECT DD.TABLESPACE_NAME,
   ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB
  FROM SYS.DBA_DATA_FILES DD
    WHERE dd.TABLESPACE_NAME='TABLESPACE1'
  GROUP BY DD.TABLESPACE_NAME) D
  WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 1

If you want to monitor specified table, for example named “emp”, the sql like:

SELECT SUM(bytes)/1024/1024 Mbytese
  FROM dba_segments
 WHERE tablespace_name ='TABLESPACE1'
   AND SEGMENT_NAME='EMP'
    ORDER BY Mbytese DESC

3. View the tablespace growth a few days later.

  1. Click “View” manu.
  2. Click “Graph View” button.
  3. Select item, and fill in date range, and click submit button.

The graph looks like:

Recent Posts

  • True Silent Printing PDF on Web based Application
  • Print report from your html page without ActiveX add-on
  • How to send email from command line through Gmail or hotmail account in windows
  • About the TimeOut directive in Apache configuration file
  • How to run java-rep2excel as Windows service

Archives

  • June 2016
  • May 2016
  • September 2015
  • August 2015
  • July 2015

Categories

  • Command Line Email
  • Excel Reporting
  • GTD Printing Tool
  • Monitoring
  • Rep2excel

Contact us

To contact our sales office regarding product/pricing inquiries, please send email to sales@lv2000.com.

You can also click the link below to send us message quickly.

Menu

  • Send us a message

Support

Feedback, questions and bug reports are welcome.
Customer support: support@lv2000.com.

Archives

  • June 2016
  • May 2016
  • September 2015
  • August 2015
  • July 2015

Categories

  • Command Line Email
  • Excel Reporting
  • GTD Printing Tool
  • Monitoring
  • Rep2excel

Recent Posts

  • True Silent Printing PDF on Web based Application June 23, 2016
  • Print report from your html page without ActiveX add-on May 27, 2016
© Lion Soft Inc.