From Cherie_Machler@gelco.com Wed, 08 Aug 2001 10:50:37 -0700 From: Cherie_Machler@gelco.com Date: Wed, 08 Aug 2001 10:50:37 -0700 Subject: Re: Timed statistics and SQL_TRACE for already running session Message-ID: MIME-Version: 1.0 Content-Type: text/plain Stephane, This sounds very clever. However, it's too much work for me today as I have so irons in the fire. I'll keep it in mind for the future, though. Thanks for taking time to reply. Cherie paquette stephane yahoo.com> cc: Sent by: Subject: Re: Timed statistics and SQL_TRACE for already running root@fatcity.com session 08/08/01 12:09 PM Please respond to ORACLE-L There is another way. I'm managing user's environment with a procedure called by a db_startup on logon trigger. In that procedure, I'm changing the environment with dynamic sql depending on the user. This is how I'm setting up sort_area_size, hash_area_size,... specifically per user. HTH --- Igor Neyman a écrit : > You will have to turn on timed-statistics for the > entire database using > 'alter system set timed_statistics=true'. > > Igor Neyman, OCP DBA > Perceptron, Inc. > (734)414-4627 > ineyman@perceptron.com > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > > Sent: Wednesday, August 08, 2001 11:13 AM > > > > > > I used the following syntax/package to run a trace > on a user's already > > running > > session. > > > > EXECUTE > dbms_system.set_sql_trace_in_session(8,12,TRUE); > > > > I then ran tkprof on the resulting trace file. > It all worked fairly well > > but > > I didn't get any times on any of the statements > that executed. > > > > Is there a way to use timed_statistics with this > package? > > Or must I turn on timed statistics for the entire > database? > > > > The user is using a canned application so there is > no way > > for him to alter his session and set > timed_statistics before > > he starts his work. Is there any way that I can > alter his > > session and turn on timed_statistics for just his > session? > > > > Thanks for any clever ideas, > > > > Cherie Machler > > Oracle DBA > > Gelco Information Network > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: > > INET: Cherie_Machler@gelco.com > > > > Fat City Network Services -- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California -- Public Internet > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: ListGuru@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.com > -- > Author: Igor Neyman > INET: ineyman@perceptron.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@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). ===== Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant stephane_paquette@yahoo.com ___________________________________________________________ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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.com -- Author: INET: Cherie_Machler@gelco.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).