JDBC driver slowdown


I made some changes to our Oracle database and ever since then the JDBC
driver has been acting up. I don't know if it is related or not. I added
a column to include an email address and modified the view that the
driver uses to include the attribute. Since then the driver trace
occasionally spits stuff like this out:


Code:
--------------------
13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
--------------------


There will be thousands of those messages all with the same time stamp
and thousands more for the next second, and the next, etc. That
attribute is not the one I added however and I don't know why this
message is happening. The problem is that this delays the processing of
the event queue and gets things backed up. This may be more of a SQL
question but I thought I'd ask.


--
bobbintb
------------------------------------------------------------------------
bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
View this thread: https://forums.netiq.com/showthread.php?t=51753

  • On 9/15/2014 2:38 PM, bobbintb wrote:

    > Code:
    > --------------------
    > 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    > --------------------
    >


    Could you post more of the trace in context please? That will allow us to tell you what it is
    actually doing with that.


    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Partner http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  • descent;248743 Wrote:
    > On 9/15/2014 2:38 PM, bobbintb wrote:
    >
    > > Code:
    > > --------------------
    > > 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field

    > 'MV_CUTS_GROUPS', value = null
    > > --------------------
    > >

    >
    > Could you post more of the trace in context please? That will allow us
    > to tell you what it is
    > actually doing with that.
    >
    >
    > --
    > -----------------------------------------------------------------------
    > Will Schneider
    > Knowledge Partner http://forums.netiq.com
    >
    > If you find this post helpful, please click on the star below.


    I don't know if I can really. It's just that message over and over
    thousands of times. That's the problem really. It's just that
    occasionally that message will flood the system and I have to wait for
    it to stop before anything else gets processed. I suppose I could try
    and get a trace of it before and during but I never know when it will
    start.


    --
    bobbintb
    ------------------------------------------------------------------------
    bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
    View this thread: https://forums.netiq.com/showthread.php?t=51753

  • On 9/16/2014 11:27 AM, bobbintb wrote:

    > I don't know if I can really. It's just that message over and over
    > thousands of times. That's the problem really. It's just that
    > occasionally that message will flood the system and I have to wait for
    > it to stop before anything else gets processed. I suppose I could try
    > and get a trace of it before and during but I never know when it will
    > start.
    >
    >




    So is it literally:
    13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:22 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:23 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:24 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:25 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:26 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
    13:12:27 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null

    That doesn't seem right. Can you share the structure of your view?
    I'd like to see the few lines around what is generating this line. Without context it is difficult to say.

    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Partner http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  • descent;248821 Wrote:
    > On 9/16/2014 11:27 AM, bobbintb wrote:
    >
    > > I don't know if I can really. It's just that message over and over
    > > thousands of times. That's the problem really. It's just that
    > > occasionally that message will flood the system and I have to wait

    > for
    > > it to stop before anything else gets processed. I suppose I could try
    > > and get a trace of it before and during but I never know when it will
    > > start.
    > >
    > >

    >
    >
    >
    > So is it literally:
    > 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:22 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:23 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:24 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:25 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:26 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    > 13:12:27 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    > = null
    >
    > That doesn't seem right. Can you share the structure of your view?
    > I'd like to see the few lines around what is generating this line.
    > Without context it is difficult to say.
    >
    > --
    > -----------------------------------------------------------------------
    > Will Schneider
    > Knowledge Partner http://forums.netiq.com
    >
    > If you find this post helpful, please click on the star below.


    well, it is more like:

    13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    = null

    a few thousand times then:

    13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
    = null

    a few thousand times etc. which is part of the problem. the file size of
    the log is limited so by the time i notice it starts happening, the part
    the caused it has already been trimmed from the log. is there a way i
    can share the view without letting everyone see it?


    --
    bobbintb
    ------------------------------------------------------------------------
    bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
    View this thread: https://forums.netiq.com/showthread.php?t=51753

  • On 9/17/2014 4:27 PM, bobbintb wrote:
    > a few thousand times etc. which is part of the problem. the file size of
    > the log is limited so by the time i notice it starts happening, the part
    > the caused it has already been trimmed from the log. is there a way i
    > can share the view without letting everyone see it?
    >
    >


    You can email it to me directly at my first initial lastname [at] cisus [dot] com
    If there is something relevant I'll post the explanation only here and not specific code.


    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Partner http://forums.netiq.com

    If you find this post helpful, please click on the star below.

  • Thanks for the help but I think the issue has been resolved. I went back
    to look at the data in the view and something was up. When I added that
    attribute earlier I used the wizard to do it. Well the wizard screwed up
    something in the join statement and I'm pretty sure that was the cause.
    I need to quit using that wizard. I only use it to remove the
    possibility of human error but every time I have used it instead of
    manually changing the view, it has screwed something up. Thanks again.


    --
    bobbintb
    ------------------------------------------------------------------------
    bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
    View this thread: https://forums.netiq.com/showthread.php?t=51753

  • On 9/18/2014 10:29 AM, bobbintb wrote:
    >
    > Thanks for the help but I think the issue has been resolved. I went back
    > to look at the data in the view and something was up. When I added that
    > attribute earlier I used the wizard to do it. Well the wizard screwed up
    > something in the join statement and I'm pretty sure that was the cause.
    > I need to quit using that wizard. I only use it to remove the
    > possibility of human error but every time I have used it instead of
    > manually changing the view, it has screwed something up. Thanks again.
    >
    >

    Well at least that means I was onto the correct scent :)

    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Partner http://forums.netiq.com

    If you find this post helpful, please click on the star below.
  • On 9/18/2014 1:01 PM, Will Schneider wrote:
    > On 9/18/2014 10:29 AM, bobbintb wrote:
    >>
    >> Thanks for the help but I think the issue has been resolved. I went back
    >> to look at the data in the view and something was up. When I added that
    >> attribute earlier I used the wizard to do it. Well the wizard screwed up
    >> something in the join statement and I'm pretty sure that was the cause.
    >> I need to quit using that wizard. I only use it to remove the
    >> possibility of human error but every time I have used it instead of
    >> manually changing the view, it has screwed something up. Thanks again.
    >>
    >>

    > Well at least that means I was onto the correct scent :)


    As opposed to a wild goose smell chase? :)

    It is interesting how often odd things 'build up' in connected systems.



  • On 9/18/2014 1:01 PM, Will Schneider wrote:
    > On 9/18/2014 10:29 AM, bobbintb wrote:
    >>
    >> Thanks for the help but I think the issue has been resolved. I went back
    >> to look at the data in the view and something was up. When I added that
    >> attribute earlier I used the wizard to do it. Well the wizard screwed up
    >> something in the join statement and I'm pretty sure that was the cause.
    >> I need to quit using that wizard. I only use it to remove the
    >> possibility of human error but every time I have used it instead of
    >> manually changing the view, it has screwed something up. Thanks again.
    >>
    >>

    > Well at least that means I was onto the correct scent :)


    As opposed to a wild goose smell chase? :)

    It is interesting how often odd things 'build up' in connected systems.



  • On 9/18/2014 12:02 PM, Geoffrey Carman wrote:
    > As opposed to a wild goose smell chase? :)


    You have a stench of New Jersey in your Canadian Red Beard (are you a pirate?).
    I think you've been swimming in too many channels Jeff Carmen.


    --
    -----------------------------------------------------------------------
    Will Schneider
    Knowledge Partner http://forums.netiq.com

    If you find this post helpful, please click on the star below.