Interesting...
It worked for me from Oracle 9204 Client on XP laptop connecting to my 9205 Test Database
on HP-UX 11.
- 2004-07-22 11:56:02.723
WAIT #0: nam='SQL*Net message from client' ela= 65622001 p1=1413697536 p2=1 p3=0
PARSING IN CURSOR #1 len=60 dep=0 uid=21 oct=3 lid=21 tim=1527920099347 hv=2107553109
ad='c74ab030'
select 'By Kirti: From laptop running 9204 client' from dual
END OF STMT
PARSE #1:c=0,e=1544,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1527920099315
BINDS #1:
EXEC #1:c=0,e=157,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1527920099802
WAIT #1: nam='SQL*Net message to client' ela= 7 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=190,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1527920100225
WAIT #1: nam='SQL*Net message from client' ela= 1034 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1527920101673
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
- 2004-07-22 11:56:29.724
WAIT #1: nam='SQL*Net message from client' ela= 26364526 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=222 op='TABLE ACCESS FULL DUAL '
PARSING IN CURSOR #1 len=56 dep=0 uid=21 oct=3 lid=21 tim=1527946468723 hv=237134239
ad='c74ab990'
select to_char(sysdate, 'mm/dd/yy hh24:mi:ss') from dual
END OF STMT
PARSE #1:c=0,e=1562,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1527946468696
BINDS #1:
EXEC #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1527946469223
WAIT #1: nam='SQL*Net message to client' ela= 7 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=221,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1527946469651
WAIT #1: nam='SQL*Net message from client' ela= 1005 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1527946470993
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
- 2004-07-22 11:56:42.021
WAIT #1: nam='SQL*Net message from client' ela= 12004113 p1=1413697536 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=222 op='TABLE ACCESS FULL DUAL '
PARSING IN CURSOR #1 len=39 dep=0 uid=21 oct=3 lid=21 tim=1527958477354 hv=3219915378
ad='c5a29b20'
select 'end of test by kirti' from dual
END OF STMT
PARSE #1:c=0,e=1305,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1527958477325
BINDS #1:
EXEC #1:c=0,e=149,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1527958477808
WAIT #1: nam='SQL*Net message to client' ela= 6 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=223,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1527958478319
WAIT #1: nam='SQL*Net message from client' ela= 1015 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1527958479673
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
Regards,
- Kirti
- "Fedock, John (KAM.RHQ)" <John.Fedock_at_us.kline.com> wrote:
> I have noticed that on a new 9.2.0.5 HP-UX database, that after enabling:
> alter system set events '10046 trace name context forever, level 12';
>
> (It is a new system not yet live ... )
>
> That client sessions from 8i will produce a trace file.
> That client sessions from 9i will not produce a trace file.
> That a Unix session from the same server will produce a trace file.
>
> Any ideas as to why and what I can do? I did not see this issue on MetaLink.
>
> Thanks all.
>
>
>
> > John Fedock
> "K" Line Americ
> www.kline.com
>
>
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jul 22 2004 - 11:57:46 CDT