Of course, if you just want to learn the file name, oradebug tracefile_name
will do the trick. Looks like this:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Oct 23 01:00:57 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> alter session set sql_trace=true;
Session altered.
SQL>
SQL>
SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name
/oracle/admin/o9i/udump/o9i_ora_22859.trc
SQL>
On 2003.10.23 00:54, Tim Gorman wrote:
> 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
>
>
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
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).
Received on Thu Oct 23 2003 - 01:04:24 CDT
