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
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday,
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
Which version of Oracle.
From 8.1.6 onwards, dbms_system contains
a call similar to set_sql_trace_in_session
which is name something like:
set_boll_param_in_session. Describe
dbms_system to check the proper
nmame and parms.
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few
:
Sent by: Subject: Re: Timed statistics and
SQL_TRACE for already running
[EMAIL PROTECTED] session
:
Sent by: Subject: Re: Timed statistics and
SQL_TRACE for already running
[EMAIL PROTECTED] session
by: Subject: Re: Timed statistics and
SQL_TRACE for already running
[EMAIL PROTECTED]session
om
Do you know what does procedure WAIT_FOR_EVENT in this package is doing?
Alex Hillman
-Original Message-
Sent: Wednesday, August 08, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Which version of Oracle.
From 8.1.6 onwards, dbms_system contains
a call similar to
This should do it; (works for me - I'm on 8.1.6.3)
as system/manager...
select sid,serial# from v$session where ...(to get process you want to
enable trace for);
exec dbms_system.set_sql_trace_in_session(sid,serial#,true);
exec
It's pure 8.1.6+
something like:
dbms_system.set_bool_param(sid, serial,'parameter',true/false);
I don't think there is ANYTHING sneaky
you can do prior to 8.1.6;
alter system is the only option for avoiding
the bounce.
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few
8.1.5 has some known performance problems, but 8.1.6 resolved them.
I always run timed_statistics = true.
There is a slow down of .1-5% depending on who you talk to, I don't think it
is much more than 1%.
Walking on water and developing software from a specification are easy if
both are
When you have timed statistics on all your doing is when oracle acquires a
resource it stores the time, then it is done, it stores a time. This is
very low resource task, even compared to many of the smallest transactions.
Most transactions outweigh the time to do this by 100 - 1000 fold or
Timed statistics has very little performance impact - most of the work is
already done internally anyway. It is very useful - for tkprof, wait
statistics, and a few other things. I always set it and have for years -
even on exceptionally hot OLTP systems. A guy I know from the Oracle Center
of
Greg,
No, though in early versions of Oracle 8 there are bugs that can trip you up.
At 8.1.6 timed_statistics is stable and low-cost in my experience. I've tried to
measure the performance hit but I've never noticed any difference at all.
I personally wouldn't run without it.
Regards,
Mike
Greg,
In general, the benefits of having timed_statistics set on far outweigh any
(usually negligible) performance hits.
Rachel
From: Greg Solomon [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: timed statistics
Date: Wed, 20
I believe the consensus is there is no substantial impact for running timed
stats and the benefits far outweigh any small performance impact. - E
-Original Message-
Sent: Wednesday, June 20, 2001 8:16 AM
To: Multiple recipients of list ORACLE-L
Hi
Has anyone experienced any problems
hardly makes a difference anymore, i think it used to be an
issue in early 7 days but no anymore, i dont think you'll even
notice.
joe
[EMAIL PROTECTED] 06/20/01 11:16AM
HiHas anyone experienced any problems after setting
timed_statistics to trueon a prod database (at system level) ?Can
Of course, to actually *measure* any performance difference,
you'd need to turn timed_statistics on anyway...lol.
Reminds me of Schrodinger's Cat.
-Original Message-
Sent: Wednesday, June 20, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
I believe the consensus is
On 8i there are several cursor sharing bugs (1210242,
918002, and others) where cursors aren't shared when
timed_statistics is enabled. Most of them have been
fixed in 8.1.6.3 and 8.1.7.1. A workaround for most
of them is to set _SQL_EXEC_PROGRESSION_COST=0.
Symptoms are contention on the
We have it on continuously. Have not seen any perfomance hits since we put
them on.
-Original Message-
Sent: Wednesday, June 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
Hi
Has anyone experienced any problems after setting timed_statistics to true
on a prod database (at
19 matches
Mail list logo