Hi,
Thanks for the clarification. Always welcome.
shreepad
To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT
INTERNET@CCMAIL
cc:
However you can query the view dba_tab_modifications
for checking when and how many
updates/deletes/inserts/truncate have been
Guys,
can you please confirm to me you found dba_tab_modifications table. I
checked both 7.3.4 and 8i versions and I don't seem to find the table.
Thank you.
-Original Message-
Sent: Tuesday, July 17, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Hi,
Thanks for the
It is not a table - it is a view owned by sys. And it exists only in 8i+
Alex Hillman
-Original Message-
Sent: Tuesday, July 17, 2001 1:58 PM
To: Multiple recipients of list ORACLE-L
Guys,
can you please confirm to me you found dba_tab_modifications table. I
checked both 7.3.4 and 8i
sys.com To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Last Update
Sigh on as sys and you'll see it in 8i. I don't think it is part of the 7.3.4
database, but then I haven't looked.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 17, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L
Alex,
I did a describe on sys.dba_tab_modifications and it shows a lot of info. I select *
from the view and no rows were returned but I have inserted and truncated a lot of
data this morning. Does it matter the userid doing the work? I have created a userid
that has the insert, del, update,
8.1.7 on aix, it exists just fine.
joe
[EMAIL PROTECTED] 07/17/01 01:57PM
Guys,can you please confirm to me you found
dba_tab_modifications table. Ichecked both 7.3.4 and 8i versions and I
don't seem to find the table.Thank you.-Original
Message-Sent: Tuesday, July 17, 2001 9:41
I did a check -- you have to have MONITORING on on the table you are
modifying for the view to be filled.
From: Ron Rogers [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Last Update
Date: Tue, 17 Jul 2001 10:55:33 -0800
you need to have turned monitoring on the the
table(s).
alter table tablename monitoring;
joe
[EMAIL PROTECTED] 07/17/01 02:55PM
Alex,I did a describe on sys.dba_tab_modifications and it
shows a lot of info. I select * from the view and no rows were returned but I
have inserted and
If you want that other users like system can see it ,give grant select to
system as user sys...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 10:20:31 -0800
It is not a table - it is a view owned by sys. And it
For table to have a record in dba_tab_modifications it need to be monitored.
use alter table table_name monitoring
Also it takes some time for Oracle to change record in
dba_tab_modifications. Approximately 3 hours.
Alex Hillman
-Original Message-
Sent: Tuesday, July 17, 2001 2:56 PM
Hi Erik,
Check out the dba_objects tables.
There is a column called as Last_ddl_time , which will give the ddl
time. But if you want to capture select,insert,delete,update
times ?
I guess you will have to write trigger and capture the times.
HTH
shreepad
alter table monitoring.
--- Shreepad Vaidya [EMAIL PROTECTED]
wrote:
Hi Erik,
Check out the dba_objects tables.
There is a column called as Last_ddl_time , which
will give the ddl
time. But if you want to capture
select,insert,delete,update
times ?
I guess you will have to write
Hi,
but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried
DBA_TAB_MODIFICATIONS...
Any init parameters to be enabled??
Arul.
Christian Trassens wrote:
However you can query the view dba_tab_modifications
for checking when and how many
If you have just set a table as monitoring (and have no other tables
already set for this option), then you may not actually see any rows in this
table for a while. The one downfall with this option (if you want/need real
time info) is that this table may not update for some time after the
Andthen wait because the SMON updates it every
three hours or after an startup.
Regards.
PS: Even that you can manually wakeup the SMON through
oradebug wakeup orapid of SMON
--- JOE TESTA [EMAIL PROTECTED] wrote:
you have to turn monitoring on for each table.
alter table tablename
You could use logminer to see when something changed(the whole
sql) but it doesn't track a last updated date per se.
joe
[EMAIL PROTECTED] 07/13/01 02:55PM
Erik,AFAIK, you will have to maintain that ... I don't
think Oracle maintainsthat information ... now in my wildest guess I could
I am afraid the only fields I know about are the last_analyzed date in
DBA_TABLES and the last_DDL_time in the dba_objects table.
-Original Message-
Sent: Friday, July 13, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L
How can I tell when a table was last updated? I am able to
18 matches
Mail list logo