Re: 10046 trace question
Title: Message
Hi!
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.ksdwrtseem to give exactly what
you wish?
Niall
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Daniel
FinkSent: 22 October 2003 21:10To: Multiple recipients
of list ORACLE-LSubject: Re: 10046 trace
questionRaj,
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
07:00am Johndoe logs in and his session
automatically starts tracing 10046^8 through a login
trigger.
10:00am Johndoe experiences slowness in the
session.
10:01am johndoe runs a program in windows,
that sends out an email to admin group informing them about the
slowness.
10:02am johndoe continues processing
probably till COB so the trace file is not
complete.
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:[EMAIL PROTECTED]]
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 reall
Re: 10046 trace question
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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
OT: 10046 trace question
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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
10046 trace question
Title: 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
Re: 10046 trace question
Title: 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
RE: 10046 trace question
Title: 10046 trace question
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
07:00am Johndoe logs in and his session automatically starts tracing
10046^8 through a login trigger.
10:00am Johndoe experiences slowness in the session.
10:01am johndoe runs a program in windows, that sends out an email to
admin group informing them about the slowness.
10:02am johndoe continues processing probably till COB so the trace
file is not complete.
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:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 3:19
PMTo: Multiple recipients of list ORACLE-LSubject: 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 an
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 07:00am Johndoe logs in and his session automatically starts tracing 10046^8 through a login trigger. 10:00am Johndoe experiences slowness in the session. 10:01am johndoe runs a program in windows, that sends out an email to admin group informing them about the slowness. 10:02am johndoe continues processing probably till COB so the trace file is not complete. 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:[EMAIL PROTECTED]] 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
RE: 10046 trace question
Raj, I'm not speaking from experience, but why don't you start the trace the same time you send the email. And maybe by limiting the size of the trace file you don't have to worry about turning the trace off. chaim Jamadagni, Rajendra [EMAIL PROTECTED]@fatcity.com on 10/22/2003 03:44:34 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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 07:00am Johndoe logs in and his session automatically starts tracing 10046^8 through a login trigger. 10:00am Johndoe experiences slowness in the session. 10:01am johndoe runs a program in windows, that sends out an email to admin group informing them about the slowness. 10:02am johndoe continues processing probably till COB so the trace file is not complete. 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- Sent: Wednesday, October 22, 2003 3:19 PM To: Multiple recipients of list ORACLE-L 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 - To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 22, 2003 10:09 PM 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
RE: 10046 trace question
Trace file size is not a problem ... the file system has 35GB ... the problem to be able to put some kind of marker in the live trace file when a problem is experienced. 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- [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Raj, I'm not speaking from experience, but why don't you start the trace the same time you send the email. And maybe by limiting the size of the trace file you don't have to worry about turning the trace off. chaim ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 10046 trace question
Thanks Daniel, I'd rather do that using Perl because this has to happen on both nodes of RAC also I'd do this if it is the last option. 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: Daniel Fink [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 10046 trace questionRaj, Could you create a stored proc/function that opens each of their trace files, writes a line, then releases the file? Daniel Fink **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
RE: 10046 trace question
Title: Message
I'm
not entirely sure what the problem with granting execute on dbms_system is here?
dbms_system.ksddt and dbms_system.ksdwrtseem to give exactly what you
wish?
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Daniel FinkSent: 22 October 2003 21:10To: Multiple
recipients of list ORACLE-LSubject: Re: 10046 trace
questionRaj,
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
07:00am Johndoe logs in and his session
automatically starts tracing 10046^8 through a login
trigger.
10:00am Johndoe experiences slowness in the
session.
10:01am johndoe runs a program in windows,
that sends out an email to admin group informing them about the
slowness.
10:02am johndoe continues processing probably
till COB so the trace file is not complete.
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:[EMAIL PROTECTED]]
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
Re: 10046 trace question
Title: 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 [EMAIL PROTECTED] 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
Re: 10046 trace question
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
