I've had pretty crazy schedule for past few weeks related to OracleWorld and
some user group stuff, but now I'm back in action :)
Long time no C ;)
Tanel.
P.S. If anyone is interested in ASSM internals, slides of my OW presentation
can be downloaded from
http://integrid.info/Poder_Freelists_vs_ASSM.ppt
Any comments welcome.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, October 24, 2003 4:49 PM
> Hey stranger!
> Welcome back, long time no see.
>
> On 10/24/2003 08:35:58 AM, Tanel Poder wrote:
> > MessageHi!
> >
> > You can also write a wrapper package which uses dbms_system and grant
> > execute on it only...
> >
> > Tanel.
> >
> > ----- Original Message -----
> > From: Niall Litchfield
> > To: Multiple recipients of list ORACLE-L
> > Sent: Thursday, October 23, 2003 2:04 AM
> > Subject: RE: 10046 trace question
> >
> >
> > I'm not entirely sure what the problem with granting execute on
> > dbms_system is here? dbms_system.ksddt and dbms_system.ksdwrt seem to
> > give exactly what you wish?
> >
> > Niall
> >
> > -----Original Message-----
> > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> > Behalf Of Daniel Fink
> > Sent: 22 October 2003 21:10
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: 10046 trace question
> >
> >
> > Raj,
> > Could you create a stored proc/function that opens each of their
> > trace files, writes a line, then releases the file?
> >
> > Daniel Fink
> >
> > "Jamadagni, Rajendra" wrote:
> >
> > Thanks KG, I think I wasn't very clear so here is version 1.1
> > ...BTW this is all in a Oracle Forms custom application that we
> > (developed and) use in-house
> > a.. 07:00am Johndoe logs in and his session automatically
> > starts tracing 10046^8 through a login trigger.
> > b.. 10:00am Johndoe experiences slowness in the session.
> > c.. 10:01am johndoe runs a program in windows, that sends out
> > an email to admin group informing them about the slowness.
> > d.. 10:02am johndoe continues processing probably till COB so
> > the trace file is not complete.
> > e.. Plus johndoe has ONE windows session but multiple oracle
> > sessions, so (in most cases) neither user nor anyone else can tell us
> > which session out of 4 to 5 session experienced a problem. By the
> > time
> > we find out which session, it is too late anyway.
> > Now my question is "is there a way to be able to insert a
> > marker
> > (preferably a slow session indicator with timestamp) into the trace
> > file that is being generated on the server from another session?"I
> > probably want to do this on each session that user is running ...
> > just
> > to be safe. This way, later on I can scan through the trace files and
> > find the marker and see what was happening around the (slow session)
> > marker and maybe guess what happened?And no, I am not talking about
> > granting privileges on dbms_system to anyone, it is restricted to sys
> > and system only. Is this doable at all?
> >
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 !
> > -----Original Message-----
> > From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com]
> > Sent: Wednesday, October 22, 2003 3:19 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: 10046 trace question
> >
> > Raj: THe simple option is to run the ALTER SESSION command to
> > set some session level parameter like 1=1 and get the timings. Giving
> > the EXECUTE on DBMS_SYSTEM is not a good idea. KG
> > ----- Original Message -----
> > From: Jamadagni, Rajendra
> > To: Multiple recipients of list ORACLE-L
> > Sent: Wednesday, October 22, 2003 10:09 PM
> > Subject: 10046 trace question
> >
> > 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
> >
> >
> >
> >
> >
> > 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
>
>
>
> Note:
> This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee
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 Fri Oct 24 2003 - 10:04:27 CDT
