$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: true, vro: true, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

BR0863W No tables/indexes found to update/delete statistics

Hello,

after an upgrade to 12c no statistics will updated any more. We receive an "BR0863W No tables/indexes found to update/delete statistics" for all brconnect- Statistic operations. In the DB20 we can seee that some statistics are not actual.

What can be the reason for this behavior.

kind regards

Lutz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 07, 2016 at 08:18 AM

    Hello

    i got the same situation.

    the brconnect was running fine from unix session.

    but from Db13 i had this message.

    our issue was the version of the brconnect.

    from unix it was running brconnect from /usr/sap/SID/SYS/exe/run as on DB13 it was running from /usr/sap/SID/ASCS01/exe.

    don't  know why but the version was not the same and old in ASCS01 dir.

    May be the version of brconnect you have is not ok vor oracle 12.

    hope it will help

    best regards

    Patrice

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2016 at 10:33 PM

    Hi,

    First thing to mention is the having statistics that are not "actual" is not a problem.

    Second thing, the "standard" brconnect command does not "calculate" statistics.

    What it does is follow some rules to see if statistics are needed.

    In your case it has decided that new statistics are not needed.

    Why? Impossible to say with the information you have provided.

    If you attach the log file it might be possible that we could figure it out. Otherwise it would be guessing, looking at a crystal ball, vudú  or something like that.

    BTW, did you force statistics after the upgrade?

    Add comment
    10|10000 characters needed characters exceeded