Re: Oracle 10g on HP-UX, Terrible Poor Performance!!

From: Alireza (delrish_at_gmail.com)
Date: 02/23/05 

Date: 23 Feb 2005 03:21:16 -0800

Hi,

STM wrote some logs during today's test with bonnie & iozone. These are
the logs:

-- Logtool Utility: View Formatted Summary --

Summary of: /var/stm/logs/os/log1.fmt2
Formatted from: /var/stm/logs/os/log1.raw.cur

  Date/time of first entry: Wed Feb 23 10:00:00 2005

  Date/time of last entry: Wed Feb 23 14:34:00 2005

  Number of LPMC entries: 0
  Number of System Overtemp entries: 0
  Number of LVM entries: 0
  Number of Logger Event entries: 0

  Number of I/O Error entries: 15

    Device paths for which entries exist:

       (1) 0/4/0/0.1
       (14) 0/4/0/0

    Products for which entries exist:

       (1) Fibre Channel Driver
       (14) Fibre Channel Interface

    Product Qualifiers for which entries exist:

       (1) Mass_Storage
       (14) HP6795A_Tachyon_XL2

    Logger Events for which entries exist:

       (1) fcp
       (14) td

    Device Types for which entries exist:

       (15) Interface

    Device Qualifiers for which entries exist:

       (1) Driver
       (14) FibreTL

These are details of those logs.( some of them that belong to FC
drivers and did not critical are omitted)

Entry Type: I/O Error
Entry logged on Wed Feb 23 10:21:13 2005
Entry id: 0x421cbb8900000000

    Device Path: 0/4/0/0
    Product: Fibre Channel Interface
    Product Qualifier: HP6795A_Tachyon_XL2
    Logger: td
    Device Type: Interface
    Device Qualifier: FibreTL

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

Event # : 40
Severity : Critical
Label : Unable to open previously opened target

Description of Error:

 lbolt value: 14340762

   Unable to access previously accessed target
   nport ID = 0x10200

Probable Cause / Recommended Action:

An attempt to re-open a device which had been opened earlier
  has failed.
      There should be additional logging messages which will
      allow diagnosis of the problem.

=-+-=-+-=-+-=-+-=- ( D E T A I L S O F F )
-=-+-=-+-=-+-=-+-=
=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=

Entry Type: I/O Error
Entry logged on Wed Feb 23 10:22:22 2005
Entry id: 0x421cbbce00000000

    Device Path: 0/4/0/0
    Product: Fibre Channel Interface
    Product Qualifier: HP6795A_Tachyon_XL2
    Logger: td
    Device Type: Interface
    Device Qualifier: FibreTL

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

Event # : 40
Severity : Critical
Label : Unable to open previously opened target

Description of Error:

 lbolt value: 14347662

   Unable to access previously accessed target
   nport ID = 0x10200

Probable Cause / Recommended Action:

An attempt to re-open a device which had been opened earlier
  has failed.
      There should be additional logging messages which will
      allow diagnosis of the problem.

=-+-=-+-=-+-=-+-=- ( D E T A I L S O F F )
-=-+-=-+-=-+-=-+-=
=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=-+-=

Entry Type: I/O Error
Entry logged on Wed Feb 23 10:23:31 2005
Entry id: 0x421cbc1300000000

    Device Path: 0/4/0/0
    Product: Fibre Channel Interface
    Product Qualifier: HP6795A_Tachyon_XL2
    Logger: td
    Device Type: Interface
    Device Qualifier: FibreTL

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

Event # : 40
Severity : Critical
Label : Unable to open previously opened target

Description of Error:

 lbolt value: 14354562

   Unable to access previously accessed target
   nport ID = 0x10200

Probable Cause / Recommended Action:

An attempt to re-open a device which had been opened earlier
  has failed.
      There should be additional logging messages which will
      allow diagnosis of the problem.

Regards,
Alireza