Hi,
I did something similiar before. It cound be meaningful in some case.
My database was io-bound and top wait event was log file sync. It can because of
too much commit, I asked business guys and according to there data and business logic,
there cound't be so much transactions. I
Is it possible to find how many DML operations have ocurred on a given table in
a given time period? I'd like to be able to rank the tables in a database based
on the number of DML actions performed on them in a given time period. It would
be interesting to see which are the 'hot spots' so to
Alter table table_name monitoring;
then look in DBA_TAB_MODIFICATIONS
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, December 19, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Is it possible to find how many DML operations have ocurred
Is there any significant overhead to leaving tables in monitoring mode? For example,
if I left them as such for a few days or two, and then gathered the stats on them?
Thanks again,
-- Dan
On Fri, 19 Dec 2003, Goulet, Dick wrote:
Alter table table_name monitoring;
then look in
it may be helpful if u take the stats from V$SEGMENT_STATISTICS and compare
them over a period of time.
I believe this view might be available only from 9i upwards.
regards
ratnesh
-Original Message-
Sent: Friday, December 19, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Is
IIRC, Steve Adams said that the impact was 1%
Jared
Daniel Hanks [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/19/2003 01:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Finding the most actively