Re: The penny hasn't dropped yet...

From: Noons <>
Date: Wed, 03 Mar 2010 23:01:48 +1100
Message-ID: <hmlirh$n38$>

vsevolod afanassiev wrote,on my timestamp of 3/03/2010 8:15 PM:

> I think it depends on the specifics of the case. If to investigate
> this case Oracle Support needs init.ora parametes
> or server patch level or similar then this information should be
> provided in one form or another.

Good. All they have to do is ask for it, if/when needed. Period.

> For example if I ask Oracle Support to investigate ORA-04031 errors
> then I would provide them with
> - init.ora parameters
> - contents of V$SGASTAT, STATS$SGASTAT
> - if this is 10g and ASMM is enabled then information from the views
> that show how memory was resized
> - ORA-04031 trace files
> - alert.log


> So may be they are asking for information that should have been
> provided from the beginning

Actually, they asked for nothing: they just sent that email as an auto follow-up to opening the SR, long before anyone had a look at it.

> However if they are using lack of OCM to justify a delay in the
> investigation when all necessary information has been provided then it
> is bad.

ORA-600 on a select from subpartitioned table, trace dump of simplified statement provided. What possible need would there be to know the MAC address of the network card in that system? Received on Wed Mar 03 2010 - 06:01:48 CST

Original text of this message