Re: 10046 trace question

DBMS_SYSTEM.KSDWRT should do what you want. First parameter is a numeric value 1 or 2, second is a string. If 1, the string is written to a ³.trc² file (which is what you want). If 2, then string is written to the alert log.

on 10/22/03 9:39 AM, Jamadagni, Rajendra at Rajendra.Jamadagni_at_espn.com wrote:

> Hi all,
>
> I am monitoring a production database and while we have performance issues
> looked at, I have 10046^8 running on all user session in this RAC db.
>
> The scenario is as follows ... user logs in through a windows terminal server,
> opens multiple sessions (oracle forms) to connect to database. Whenever they
> see a performance issue (AKA slowness) they hit a button on their windows
> session, that sends an email to us informing that user experienced slowness at
> say 10am.
>
> Now normally because users don't exit their session till COB, the trace files
> are still incomplete at the time when user reported slowness. While these
> trace files are useful to look at next day, there is no way (that I know of)
> to go into the trace file and answer questions like "what was this user doing
> around 10am" ... is there?
>
> Also is there an easy way to put a marker in the trace file (something like
> dbms_system.ksdddt) that can be invoked preferable triggered from a script ...
> and then we can go back to trace file and find out what the session was doing
> by looking at trace lines around the marker?
>
> I don't know if anyone has done this before, or I am really trying to offset
> the US debt by collecting pennies?
>
> Any help in this regard is greatly appreciated.
> Raj
> ------------------------------------------------------------------------------
> --
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
> ******************************************************************************
> ********
> This e-mail message is confidential, intended only for the named recipient(s)
> above and may contain information that is privileged, attorney work product or
> exempt from disclosure under applicable law. If you have received this message
> in error, or are not the named recipient(s), please immediately notify
> corporate MIS at (860) 766-2000 and delete this e-mail message from your
> computer, Thank you.
> ******************************************************************************
> ********4

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).