Re: system event waits

It was talked on the list and had been said that 1% of performance it affects nearly as I remember. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:23 AM Do you guys think making times statistic =true has any

RE: system event waits

1. If you have bug 1210242, then using timed_statistics=true will have a profound impact upon performance. Get a patch, and then go to 3. 2. If you use an HP-UX release older than release 10, then using timed_statistics=true will have a profound impact upon performance. Upgrade HP-UX, and then

RE: system event waits

And that package would be... ? Jared K Gopalakrishnan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John

Re: system event waits

recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views

RE: system event waits

Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

Re: system event waits

-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME

RE: system event waits

Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ... No luck using this one on 8.1.6/8.1.7/9.0.1... Any gotchas? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: system event waits

Here is the original reply ... From: Deshpande, Kirti Date: Thu, 20 Jun 2002 14:35:36 -0500 Subject: RE: DBMS_SYSTEM.KSDWRT question Addition: DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views. - Kirit I do not

system event waits

Hi List , In system_event i find total_waits , total_timeouts , time_waited and avg_wait . If total_waits and total_timeouts are high but there are 0 value for time_waited and avg_wait . What does this indicates ? TIA -Bp

RE: system event waits

That TIMED_STATISTICS is defaulted to FALSE... To obtain any meaningful information from Wait stats, this needs to be set to TRUE (followed by a Db bounce). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and

RE: system event waits

Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features  Mastering Oracle8i    Clark Griswold:

RE: system event waits

Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same

RE: system event waits

John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views. --- John Kanagaraj [EMAIL PROTECTED] wrote: Depending on the version of the database, timed_statistics

Re: system event waits

Thanks John and every body else . You guys rock . -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 12:53 PM Depending on the version of the database, timed_statistics may be dynamic and not require a database

Re: system event waits

Do you guys think making times statistic =true has any performance impact . Are there any other considerations ? -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 12:53 PM Depending on the version of the database,

Re: system event waits

setting it to true might have a very small performance impact. the impact of not having it set is that many of the statistics you gather for performance tuning are meaningless. If you need to get every possible millisecond of performance, turn timed_statistics on when you have problems and wait