FAQ
Hi friends,
I have the following report extracted from trace.

SQL*Net message from client 18 13.29
113.66
The total time of the process was 34 seconds.

1.) What does it mean ? the 113.66 ?

2.) This event (SQL*Net message from client) occurs after or before
execution of the query ?

3.) What is the measure of 113.66 ?

Regards
Eriovaldo



********************************************************************************
select COD_DADO
from
DADOS where (COD=:b0 and PONTO=:b1)

call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 9 0.00 0.00 0 0
0 0
Execute 9 0.00 0.00 0 0
0 0
Fetch 18 0.00 0.00 0 18
0 9
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 36 0.00 0.00 0 18
0 9
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: RULE
Parsing user id: 59
Rows Row Source Operation
------- ---------------------------------------------------
1 INDEX RANGE SCAN IND_DADOS (cr=2 pr=0 pw=0 time=26 us)(object id
59871)

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
Waited
---------------------------------------- Waited ----------
------------
SQL*Net message to client 18 0.00
0.00
SQL*Net message from client 18 13.29
113.66
********************************************************************************

Search Discussions

  • Shanmugam, Satheesh B at Jan 6, 2012 at 6:33 am
    Hi All,
    I know OSW can be run as root as well as oracle user. I see that OSW in exadata machine should be run as root user. OSW in windows to be run as administrator account. In UNIX is there any advantage in running OSW as root user?
    Also an oracle note says it's ideal to run OSW and cluster health monitor (CHM) together. Anyone foresee that CHM will replace OSW completely in the near future.

    Regards,
    Satheesh Shanmugam
    This communication is for informational purposes only. It is not
    intended as an offer or solicitation for the purchase or sale of
    any financial instrument or as an official confirmation of any
    transaction. All market prices, data and other information are not
    warranted as to completeness or accuracy and are subject to change
    without notice. Any comments or statements made herein do not
    necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
    and affiliates.

    This transmission may contain information that is privileged,
    confidential, legally privileged, and/or exempt from disclosure
    under applicable law. If you are not the intended recipient, you
    are hereby notified that any disclosure, copying, distribution, or
    use of the information contained herein (including any reliance
    thereon) is STRICTLY PROHIBITED. Although this transmission and any
    attachments are believed to be free of any virus or other defect
    that might affect any computer system into which it is received and
    opened, it is the responsibility of the recipient to ensure that it
    is virus free and no responsibility is accepted by JPMorgan Chase &
    Co., its subsidiaries and affiliates, as applicable, for any loss
    or damage arising in any way from its use. If you received this
    transmission in error, please immediately contact the sender and
    destroy the material in its entirety, whether in electronic or hard
    copy format. Thank you.

    Please refer to http://www.jpmorgan.com/pages/disclosures for
    disclosures relating to European legal entities.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 5, '12 at 6:55p
activeJan 6, '12 at 6:33a
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase