How to Use nhiCollectDbPerfData to Gather Oracle Database Performance Information?

Document ID : KB000012647
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Introduction

nhiCollectDbPerfData gather application and Oracle database performance information to help diagnose performance related problems. The output of the program is saved in /loddisk2/eHealth/tmp/dbPerf.zip file.

Steps required to run the command

1. Make sure the ehealth is up and running

2. Go to $NH_HOME/bin/sys

3. ./nhiCollectDbPerfData

4. Running nhiCollectDbPerfData will create a zip file under $NH_HOME/tmp/dbPerf.zip, please post the zip file into the service cloud case.

Example on how to run the command

./nhiCollectDbPerfData

NOTE: eHealth services must be running to collect the full performance data

SNAP_ID BEGIN_INTERVAL_TIME  END_INTERVAL_TIME    SNAP_LEVEL

---------- -------------------- -------------------- ------------------

       148 01/09/2017 23:00:47  01/10/2017 00:00:52           1

       149 01/10/2017 00:00:52  01/10/2017 01:00:57           1

       150 01/10/2017 01:00:57  01/10/2017 02:00:01           1

       151 01/10/2017 02:00:01  01/10/2017 03:00:09           1

       152 01/10/2017 03:00:09  01/10/2017 04:00:14           1

       153 01/10/2017 04:00:14  01/10/2017 05:00:18           1

        ...............................................

        ....................................................

       351 01/18/2017 10:00:57  01/18/2017 11:00:04           1

       352 01/18/2017 11:00:04  01/18/2017 12:00:09           1

       353 01/18/2017 12:00:09  01/18/2017 13:00:14           1

       354 01/18/2017 13:00:14  01/18/2017 14:00:19           1

       355 01/18/2017 14:00:19  01/18/2017 15:00:24           1

       356 01/18/2017 15:00:24  01/18/2017 16:00:31            1

 

The snap ids are one hour apart, by default.

Enter start and end snap ids corresponding to hours under investigation.

It should be, preferably, the hour error occured or for the entire duration

of the job being investigated.

Enter snap id corresponding to BEGIN_INTERVAL_TIME [default: 148]:

352

Enter the snap id corresponding to END_INTERVAL_TIME [default: 356]:

356

START=352 END=356

Info was written to /eHealth632/tmp/dbPerf.zip

 

 

 

Question:

How to Use nhiCollectDbPerfData to Gather Oracle Database Performance Information?

Environment:
ehealth 6.3.2 or newer on any platforms
Answer:

Run a command of nhiCollectDbPerfData from $NH_HOME/bin/sys