Re: Tracefiles not generated

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 21 Sep 2006 06:31:54 -0700
Message-ID: <1158845514.828245.182260@i42g2000cwa.googlegroups.com>

nospam_kurt.laugesen_at_gmail.com wrote:
> Ana C. Dent skrev:
>
> >
> > Is TIMED_STATISICS=TRUE?
>
> oh yes.
> And as soon as I set tracefile_identifier to something, I can generate
> all the tracefiles I want (event 10046 level 12) so the problem is not
> that big really, it is just that I have been doing this for years and
> haven't seen this behaviour before.
> And - as for the dba's - they don't have a clue about what they have
> done differently this time :-)
> Regards
> Kurt

When I truss a session in which I have set sql_trace = true, I see the following system calls. What does your say? Do you see anything like what is below?

kread(8, "\015\0\006\0\0\0\0\00305".., 2064) (sleeping...)
kread(8, "0104\0\006\0\0\0\0\003 ^".., 2064)    = 260
times(0x0FFFFFFFFFFFA210)                       = 702069283
times(0x0FFFFFFFFFFF93F0)                       = 702069283
times(0x0FFFFFFFFFFF93F0)                       = 702069283
times(0x0FFFFFFFFFFF93F0)                       = 702069284
times(0x0FFFFFFFFFFF93F0)                       = 702069284
times(0x0FFFFFFFFFFF88B0)                       = 702069284
times(0x0FFFFFFFFFFF8960)                       = 702069284
times(0x0FFFFFFFFFFF8960)                       = 702069284
statx("/u02/admin/xwcbmw/udump", 0x0FFFFFFFFFFF5438, 176, 0) = 0
close(5)                                        = 0
statx("/u02/admin/xwcbmw/udump/xwcbmw1_ora_3915964.trc",

0x0FFFFFFFFFFF5750, 176, 01) Err#2 ENOENT statx("/u02/admin/xwcbmw/udump/xwcbmw1_ora_3915964.trc", 0x0FFFFFFFFFFF5750, 176, 0) Err#2 ENOENT open("/u02/admin/xwcbmw/udump/xwcbmw1_ora_3915964.trc", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE) = 5 Regards,

Steve Received on Thu Sep 21 2006 - 08:31:54 CDT