Thanks Nanda I set statistic to all, made a select but statistic in this table didn't changed. I never used statistics, because I don't have really performance problems (depending on the database we have from 3 to 60 concurrent sessions), and when you don't have performance problems you don't learn to tune, the most I did is get a full trace log and send to www.oraperf.com, I study it to get my OCP, but never practice, neither have a real experience with events. Most of the time I'm developing. I know this is a stupid question 1. If I do a lock exclusive in one session, and in ther other I do the same, does this will generate a event? 2. What kind of situation will generate a change in the segments statistics in a table. SELECT OBJECT_NAME,STATISTIC_NAME, VALUE FROM V$SEGMENT_STATISTICS WHERE OWNER = 'DAZ' And OBJECT_NAME = 'DEFINICION_UNIDAD_PROGRAMACION'? 3. Could you giveme an example. ( the most simple you can do which will generate a change in a event in this table) Thanks for your patiente ----- Original Message ----- From: "Arup Nanda" <orarup@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, March 10, 2004 1:40 AM Subject: Re: V$SEGMENT_STATISTICS > Juan, > > I'm the author of that article. You don't have to use STATSPACK to get the > segment stats data. All you have to do is to set the STATISTICS_LEVEL > init.ora parameter to TYPICAL, or just don;t define it at all and the > v$segstat will be populated. If it's not populated, I would suspect the > parameter has been set to BASIC. You can reset it using ALTER SYSTEM. > > You can check the settings by: > SELECT ACTIVATION_LEVEL, STATISTICS_NAME, SYSTEM_STATUS, SESSION_STATUS > FROM V$STATISTICS_LEVEL > ORDER BY ACTIVATION_LEVEL, STATISTICS_NAME; > > Hope this helps. > > Arup > > ----- Original Message ----- > From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx> > To: <oracle-l@xxxxxxxxxxxxx> > Sent: Tuesday, March 09, 2004 4:34 PM > Subject: V$SEGMENT_STATISTICS > > > > Hi, I read an article http://www.dbazine.com/nanda1.html > > And this some tests, some one can share his experience using it, > > some tricks? > > > > For example is there a way to fill them without using statpacks > > I tried > > EXECUTE IMMEDIATE 'alter session set TIMED_STATISTICS=TRUE'; > > EXECUTE IMMEDIATE 'alter session set STATISTICS_LEVEL=ALL'; > > EXECUTE IMMEDIATE 'alter session set max_dump_file_size=UNLIMITED'; > > EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT > > FOREVER, LEVEL 12'''; > > and didn't worked > > > > Thank you :) > > > > > > p.d. there is a free oracle database day dba. > > http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10742.pdf > > > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------