Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• ORA 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• ORA 01722 invalid number
 
Unaccounted for time

Unaccounted for time

2006-06-30       - By Collier,Joshua W - JDDO-6

 Back
What could explain the following unaccounted for time? And Yes I know
the app parses too much. I only get digest so please CC personal address
in responses as well. Thanks!

insert into table(TextId, TextLength, LongText)
values
(:TextID,:TextLength,:LongText)


call     count       cpu    elapsed       disk      query    current
rows
-- ---- -- ---  -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
-- ---- --
Parse       81      0.17       0.66          0          0          0
0
Execute     80      1.04     107.08         22         86        426
80
Fetch        0      0.00       0.00          0          0          0
0
-- ---- -- ---  -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
-- ---- --
total      161      1.21     107.75         22         86        426
80

Misses in library cache during parse: 1
Misses in library cache during execute: 8
Optimizer goal: FIRST_ROWS
Parsing user id: 46  

Elapsed times include waiting on following events:
 Event waited on                             Times   Max. Wait  Total
Waited
 -- ---- ---- ---- ---- ---- ---- ---- --   Waited  -- ---- --
-- ---- ----
 SQL*Net message to client                     319        0.00
0.00
 SQL*Net message from client                   320        0.02
0.61
 SQL*Net more data from client                  98        0.00
0.00
 db file sequential read                        22        0.01
0.18
************************************************************************
********


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Unaccounted for time</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=2 FACE="Arial">What could explain the following unaccounted for
time? And Yes I know the app parses too much. I only get digest so please CC
personal address in responses as well. Thanks!</FONT></P>

<P><FONT SIZE=2 FACE="Arial">insert into table(TextId, TextLength, LongText) <
/FONT>

<BR><FONT SIZE=2 FACE="Arial">values</FONT>

<BR><FONT SIZE=2 FACE="Arial">&nbsp;(:TextID,:TextLength,:LongText)</FONT>
</P>
<BR>

<P><FONT SIZE=2 FACE="Arial">call&nbsp;&nbsp;&nbsp;&nbsp; count&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; cpu&nbsp;&nbsp;&nbsp; elapsed&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; disk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; query&nbsp;&nbsp;&nbsp; current
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rows</FONT>

<BR><FONT SIZE=2 FACE="Arial">-- ---- -- ---&nbsp; -- ----- -- ---- -- -- -----
-- -- ---- -- -- ---- --&nbsp; -- ---- --</FONT>

<BR><FONT SIZE=2 FACE="Arial">Parse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 81&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp; 0.17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.66&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT>

<BR><FONT SIZE=2 FACE="Arial">Execute&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 1.04&nbsp;&nbsp;&nbsp;&nbsp; 107.08&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 426&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; 80</FONT>

<BR><FONT SIZE=2 FACE="Arial">Fetch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT>

<BR><FONT SIZE=2 FACE="Arial">-- ---- -- ---&nbsp; -- ----- -- ---- -- -- -----
-- -- ---- -- -- ---- --&nbsp; -- ---- --</FONT>

<BR><FONT SIZE=2 FACE="Arial">total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 161&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;<B> 1.21&nbsp;&nbsp;&nbsp;&nbsp; 107.75</B>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp; 86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 426&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">Misses in library cache during parse: 1</FONT>

<BR><FONT SIZE=2 FACE="Arial">Misses in library cache during execute: 8</FONT>

<BR><FONT SIZE=2 FACE="Arial">Optimizer goal: FIRST_ROWS</FONT>

<BR><FONT SIZE=2 FACE="Arial">Parsing user id: 46&nbsp; </FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">Elapsed times include waiting on following events:
</FONT>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; Event waited on&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Times&nbsp;
&nbsp; Max. Wait&nbsp; Total Waited</FONT>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; -- ---- ---- ---- ---- ---- ---- ---- --
&nbsp;&nbsp; Waited&nbsp; -- ---- --&nbsp; -- ---- ----</FONT>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; SQL*Net message to client&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; 319&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><B> <FONT SIZE=2 FACE=
"Arial">0.00</FONT></B>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; SQL*Net message from client&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.02&nbsp;&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><B> <FONT SIZE=2 FACE="Arial"
>0.61</FONT></B>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; SQL*Net more data from client&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; 98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><B> <FONT SIZE=2 FACE="Arial">0.00<
/FONT></B>

<BR><FONT SIZE=2 FACE="Arial">&nbsp; db file sequential read&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp; 0.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><B>
<FONT SIZE=2 FACE="Arial">0.18</FONT></B>

<BR><FONT SIZE=2 FACE="Arial">*************************************************
*******************************</FONT>
</P>

</BODY>
</HTML>