Re: Timed statistics and SQL_TRACE for already running session

From: <Cherie_Machler_at_gelco.com>
Date: Wed, 08 Aug 2001 10:50:37 -0700
Message-ID: <F001.00364AD5.20010808104759@fatcity.com>

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                                                  
                            
                    <stephane_paquette@        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com> 
                    yahoo.com>                 cc:                                     
                            
                    Sent by:                   Subject:     Re: Timed statistics and 
SQL_TRACE for already running 
                    root_at_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 <ineyman_at_perceptron.com> 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_at_perceptron.com
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> 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_at_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_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.com
> --
> Author: Igor Neyman
> INET: ineyman_at_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_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).

Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_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_at_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_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.com
--
Author:
  INET: Cherie_Machler_at_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_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 Wed Aug 08 2001 - 12:50:37 CDT