"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F6A29ED.84D9A9D8_at_remove_spam.peasland.com...
> Where is your SELECT statement? It is missing from your trace file.
> Start the 10046 trace and then issue the SELECT statement again. See all
> of those lines that say "WAIT #1"? We need to see those lines that the
> SELECT statement is waiting on.
ahh - sorry - my mistake...
$ tail -f ora_7196.trc
- 2003.09.18.22.52.22.000
- SESSION ID:(31.119) 2003.09.18.22.52.22.000
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
PARSING IN CURSOR #1 len=71 dep=0 uid=73 oct=42 lid=73 tim=0 hv=2790799972
ad='27687108'
alter session set events='10046 trace name context forever, level 12'
END OF STMT
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
- 2003.09.18.22.52.58.000
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
PARSING IN CURSOR #1 len=39 dep=0 uid=73 oct=3 lid=73 tim=0 hv=1599411401
ad='276959d8'
SELECT * FROM Dealership ORDER BY Name
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0
BINDS #1:
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net more data to client' ela= 0 p1=1413697536 p2=2053 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=25 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
WAIT #1: nam='db file sequential read' ela= 0 p1=9 p2=1470079 p3=1
WAIT #1: nam='db file scattered read' ela= 0 p1=9 p2=1470080 p3=8
WAIT #1: nam='db file scattered read' ela= 0 p1=9 p2=1470088 p3=8
WAIT #1: nam='db file scattered read' ela= 0 p1=9 p2=1470096 p3=8
WAIT #1: nam='db file scattered read' ela= 0 p1=9 p2=1470104 p3=8
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
etc..
thanks
Received on Thu Sep 18 2003 - 17:17:27 CDT