Re: heapdump every 13weeks + 1 day

On Tuesday, August 28, 2012 3:41:58 AM UTC-6, (unknown) wrote:
> > javacores can be analyzed with jca,
>
> > heapdumps with ha, the "a" stands for analyzer
>
> > you can find those at IBM
>
> thx
>
> ha does not show something suspect, neither nr of procs nor for memory
>
>
>
> ------------------
>
> >>My crystal ball says you are using e-business suite
>
> do not trust it, your ball(s) does not work ... is not ecommerce
>
> no payments at all, or another quarterly activity as I wrote before
>

You must mean another post in another newsgroup, possibly by another author, as I don't see anything in *your* original post that could even remotely be considered as stating it's not ecommerce nor is there anything stating there is no quarterly activity. Had you provided such information we'd have known not to ask. Here's the 'relevant' part of your original post -- apparently your memory is not what it should be:

"Every 13weeks + 1 day I receive 4 heapdumps(in few hours, below list of files)

I cannot see any scheduled task/job with such time-frame the same story on 3 nodes(set by the same person)

How or where I can check to know what it does, before open a service request with Oracle? using vi or em?

TIA
M_at_rio

oracle version 11.1.0.7.0 (without any patches since ~2010)"

Of course possibly I missed something between the lines that I should have seen; please feel free to highlight exactly where you stated that this is not an ecommerce or EBusiness database and that there is no quarterly activity related to these heapdumps.

I'll wait.

>
>
> >>"how to ask smart questions."
>
> probably there is also in the tubes a document
>
> "how to not answer if you do not know/want to answer"

No, I haven't found such a document; the general tactic is to avoid and ignore people who post with such little information and no evidence of effort to resolve the problem. You at least received a response for your less-than-informative post. I did find the page Joel recommended; since you failed to look for it out if a sense of indignity I took the liberty of finding it for you -- you should read it in its entirety before posting any other lacklustre responses:

http://www.catb.org/esr/faqs/smart-questions.html

>
> not everyone has to be "great" DBA programmer
>
> and can ask at least for direction?
>

Yes, you can ask for direction but it helps tremendously if you provide relevant information on which to base a usable response. You haven't done so until, possibly, now (of course all we get in addition to the little you originally provided is that this is NOT EBusiness or ecommerce and there is no quarterly database activity [at least that YOU know of -- there could be something you missed]).

We also know this is 11.1.0.7 and you haven't applied any patches so possibly that is the place to start your investigation? There are likely patches that address such behavior in 11.1.0.7. Searching Metalink there are a number of memory-related bugs that are patched that generate heapdumps; have you even looked inside one of these heapdump files to see what it's reporting? They are generated for a reason and examining them should have been your first step in an determining the problem and the possible resolution.

You have done little, it appears, to actually find a root cause for this behavior, instead relying on others to do your work for you.
>
>
> --------------------
>
> >> using vi or em?
>
> I meant what is already installed on sys

Please explain that statement as it's ambiguous at best. [ambiguous == unclear]

>
> >Real DBAs use vi.
>
> what to open with vi? /dev/random and look for "666" sequence?

Gee, do you think you could open just *one* of those pesky heapdumps about which you are complaining? They don't just arrive for no reason and they do contain information regarding the process or processes that generated them. Of course if you want to remain in the dark about this and rely on others to do work that you should be doing you could open /dev/null and look for errant characters while you wait for the answer to your problem to drop from the sky into your lap; trust me you will have a very long wait.

David Fitzjarrell Received on Tue Aug 28 2012 - 09:15:22 CDT