RE: Dba_tab_modifications question

2002-05-16 Thread Cherie_Machler
AIL PROTECTED]> Subject: RE: Dba_tab_modifications question Sent by:

RE: Dba_tab_modifications question

2002-05-16 Thread Grabowy, Chris
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Dba_tab_modifications question Sent by: [EMAIL PROTECTED] om

RE: Dba_tab_modifications question

2002-05-16 Thread Kathy Duret
"Grabowy, Chris" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Dba_tab_modifications question

RE: Dba_tab_modifications question

2002-05-16 Thread Jesse, Rich
> -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 10:44 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Dba_tab_modifications question > > > Thanks Prakash. > > I was poking around in Metalink and discove

RE: Dba_tab_modifications question

2002-05-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
Information Network "Grabowy, Chris" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Dba_tab_modifications question

RE: Dba_tab_modifications question

2002-05-16 Thread Grabowy, Chris
Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 12:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Dba_tab_modifications question > > > > > > Hey Prakash, > > > > I never knew about that dictionary table,

RE: Dba_tab_modifications question

2002-05-16 Thread Deshpande, Kirti
Precisely :) - Kirti -Original Message- Sent: Thursday, May 16, 2002 9:23 AM To: Multiple recipients of list ORACLE-L So DBA/ALL/USER_TAB_MODIFICATIONS cannot be used to determine an accurate count of how many records were updated, but it can used to determine if the table has been upd

RE: Dba_tab_modifications question

2002-05-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
; > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 12:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Dba_tab_modifications question > > > > > > Hey Prakash, > >

RE: Dba_tab_modifications question

2002-05-16 Thread Cherie_Machler
is" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Dba_tab_modifications question

RE: Dba_tab_modifications question

2002-05-16 Thread Grabowy, Chris
for Life is here: http://www.gospelcom.net > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 20

RE: Dba_tab_modifications question

2002-05-15 Thread Deshpande, Kirti
y my own and not those of my > employer or clients ** > > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 12:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Dba_tab_modific

RE: Dba_tab_modifications question

2002-05-15 Thread John Kanagaraj
To: Multiple recipients of list ORACLE-L > Subject: Re: Dba_tab_modifications question > > > John: > > Not being so choosy, MONITORING is subject to latching. There > is a latch > called 'hash table allocation/modification latch' > which keeps the modifi

RE: Dba_tab_modifications question

2002-05-15 Thread Grabowy, Chris
mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 12:33 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Dba_tab_modifications question > > > Hey Prakash, > > I never knew about that dictionary table, so I looked it up > and found... > > The

Re: Dba_tab_modifications question

2002-05-15 Thread K Gopalakrishnan
* > > > > -Original Message- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 12:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Dba_tab_modifications question > > > > > > Hey Prak

RE: Dba_tab_modifications question

2002-05-15 Thread John Kanagaraj
statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 12:33 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Dba_tab_modifications quest

RE: Dba_tab_modifications question

2002-05-15 Thread BALA,PRAKASH (Non-HP-USA,ex1)
Chris, this table was modified around 3am and I checked this view around 10am. Maybe I need to create a TAR. Prakash -Original Message- Sent: Wednesday, May 15, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Hey Prakash, I never knew about that dictionary table, so I looked it

RE: Dba_tab_modifications question

2002-05-15 Thread Grabowy, Chris
Hey Prakash, I never knew about that dictionary table, so I looked it up and found... These views describe tables that have been modified since the last time table statistics were gathered on them. The views are populated only for tables with the MONITORING attribute. They are not populated imme