Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
-none-

-none-

2004-06-17       - By -not available-
Reply:     <<     111     112     113     114     115     116     117     118     119     120     >>  

=20

=20

Can somebody please explain me whats going on here.

=20

TIA,

Madhu

__ __ =20

Do you Yahoo!?
Take Yahoo! Mail with you!
<http://us.rd.yahoo.com/mail/taglines/*http:/mobile.yahoo.com/maildemo >
Get it on your mobile phone.


-- ---_=_NextPart_001_01C4546B.E3F52440
Content-Type: text/html; charset= "us-ascii "
Content-Transfer-Encoding: quoted-printable

<html >

<head >
<meta http-equiv=3DContent-Type content=3D "text/html; =
charset=3Dus-ascii " >
<meta name=3DGenerator content=3D "Microsoft Word 10 (filtered) " >

<style >
<!--
/* Font Definitions */
@(protected)
   {font-family:Tahoma;
   panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
   {margin:0cm;
   margin-bottom:.0001pt;
   font-size:12.0pt;
   font-family: "Times New Roman ";}
a:link, span.MsoHyperlink
   {color:blue;
   text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
   {color:blue;
   text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
   {margin:0cm;
   margin-bottom:.0001pt;
   font-size:12.0pt;
   font-family: "Times New Roman ";}
p
   {margin-right:0cm;
   margin-left:0cm;
   font-size:12.0pt;
   font-family: "Times New Roman ";}
span.EmailStyle19
   {font-family:Arial;
   color:navy;}
@(protected) Section1
   {size:595.3pt 841.9pt;
   margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
   {page:Section1;}
-- >
</style >

</head >

<body lang=3DEL link=3Dblue vlink=3Dblue >

<div class=3DSection1 >

<p class=3DMsoNormal > <font size=3D2 color=3Dnavy face=3DArial > <span =
lang=3DEN-US
style=3D 'font-size:10.0pt;font-family:Arial;color:navy ' >According to =
what I have
read, this indicates that you have started the trace in the middle of =
the
transaction. </span > </font > </p >

<p class=3DMsoNormal > <font size=3D2 color=3Dnavy face=3DArial > <span =
lang=3DEN-GB
style=3D 'font-size:10.0pt;font-family:Arial;color:navy ' >  </span > </fo=
nt > </p >

<div >

<p class=3DMsoAutoSig > <font size=3D3 color=3Dnavy face=3D "Times New =
Roman " > <span
lang=3DEN-US style=3D 'font-size:12.0pt;color:navy ' >Yannis =
Hatzistavrou </span > </font > </p >

</div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D2 =
face=3DTahoma > <span
lang=3DEN-US style=3D 'font-size:10.0pt;font-family:Tahoma ' >-- --Original
Message-- -- <br >
<b > <span style=3D 'font-weight:bold ' >From: </span > </b > Madhu Konda
[mailto:konda_madhusudhan@(protected)] <br >
<b > <span style=3D 'font-weight:bold ' >Sent: </span > </b > Thursday, June 17, =
2004 3:48
PM <br >
<b > <span style=3D 'font-weight:bold ' >To: </span > </b > =
oracle-l@(protected) <br >
<b > <span style=3D 'font-weight:bold ' >Subject: </span > </b > Event 10046 =
trace </span > </font > </p >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >  </span > </font > </p >

<div >

<div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span style=3D 'font-size:12.0pt ' >Hi =
All, </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >    We are
running Oralce 8.1.7. on HP-UX . Recently I traced a  application =
(third
party) and I see some the following information in the trace file =
. </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >  </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D <br >
PARSING IN CURSOR #6 len=3D181 dep=3D0 uid=3D8564 oct=3D6 lid=3D8564 =
tim=3D1314794115
hv=3D1049137217 ad=3D '712a38b0 ' <br >
UPDATE SIEBEL.S_EVT_ACT SET <br >
      LAST_UPD_BY =3D :1, <br >
      MODIFICATION_NUM =3D :2, <br >
      APPT_START_DT =3D :3, <br >
      LAST_UPD =3D :4 <br >
   WHERE <br >
      ROW_ID =3D :5 AND MODIFICATION_NUM =3D =
:6 <br >
END OF STMT <br >
PARSE =
#6:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D3,tim=3D131=
4794115 <br >
EXEC =
#6:c=3D0,e=3D1,p=3D0,cr=3D4,cu=3D27,mis=3D0,r=3D1,dep=3D0,og=3D3,tim=3D13=
14794116 <br >
WAIT #6: nam=3D 'SQL*Net message to client ' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0 <br >
WAIT #6: nam=3D 'SQL*Net message from client ' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0 <br >
EXEC =
#9:c=3D0,e=3D0,p=3D0,cr=3D0,cu=3D4,mis=3D0,r=3D1,dep=3D0,og=3D3,tim=3D131=
4794116 <br >
WAIT #9: nam=3D 'SQL*Net message to client ' ela=3D 0 p1=3D1413697536 =
p2=3D1 p3=3D0 <br >
WAIT #9: nam=3D 'SQL*Net message from client ' ela=3D 1 p1=3D1413697536 =
p2=3D1 p3=3D0 <br >
XCTEND rlbk=3D0, rd_onfiltered=3D0 <br >
WAIT #0: nam=3D 'log file sync ' ela=3D 0 p1=3D170 p2=3D0 p3=3D0 <br >
<strong > <b > <font face=3D "Times New Roman " > <span =
style=3D 'background:red ' >WAIT #0:
nam=3D 'SQL*Net message to client ' ela=3D 0 p1=3D1413697536 p2=3D1 =
p3=3D0 </span > </font > </b > </strong > <b > <span
style=3D 'background:red;font-weight:bold ' > <br >
<strong > <b > <font face=3D "Times New Roman " >*** 2004-06-10 =
13:55:28.184 </font > </b > </strong > <br >
<strong > <b > <font face=3D "Times New Roman " >WAIT #0: nam=3D 'SQL*Net =
message from
client ' ela=3D 36301 p1=3D1413697536 p2=3D1 =
p3=3D0 </font > </b > </strong > </span > </b > <br >
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D </span > </f=
ont > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span style=3D 'font-size:12.0pt ' >From the trace =
output I
can see that Parse#6,Fetch#6,WAIT#6 are attributed to Curosr #6 . But I =
am not
able to figure out what event is invoking the WAIT#9 and WAIT # 0 . Also =
I am
not able to figure out what event is causing this  huge =
wait
 (363.01 secs)  on SQL*Net message from client =
. </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >  </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >  </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span style=3D 'font-size:12.0pt ' >Can somebody =
please
explain me whats going on here. </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >  </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >TIA, </span > </font > </p >

</div >

<div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span =
style=3D 'font-size:12.0pt ' >Madhu </span > </font > </p >

</div >

</div >

</div >

<div class=3DMsoNormal align=3Dcenter =
style=3D 'margin-left:36.0pt;text-align:center ' > <font
size=3D3 face=3D "Times New Roman " > <span style=3D 'font-size:12.0pt ' >

<hr size=3D1 width=3D "100% " align=3Dcenter >

</span > </font > </div >

<p class=3DMsoNormal style=3D 'margin-left:36.0pt ' > <font size=3D3
face=3D "Times New Roman " > <span style=3D 'font-size:12.0pt ' >Do you =
Yahoo!? <br >
<a =
href=3D "http://us.rd.yahoo.com/mail/taglines/*http:/mobile.yahoo.com/mail=
demo " >Take
Yahoo! Mail with you! </a > Get it on your mobile phone. </span > </font > </p >

</div >

</body >

</html >
=00
-- ---_=_NextPart_001_01C4546B.E3F52440--
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --