Re: Last Update
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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You
RE: Last Update
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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Last Update
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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
RE: Last Update
From 8.1.7 SQL select view_name from dba_views where view_name like 'DBA_TAB%'; VIEW_NAME -- DBA_TABLES DBA_TAB_COLUMNS DBA_TAB_COL_STATISTICS DBA_TAB_HISTOGRAMS DBA_TAB_COMMENTS DBA_TAB_PRIVS DBA_TAB_MODIFICATIONS DBA_TAB_PARTITIONS DBA_TAB_SUBPARTITIONS DBA_TABLESPACES 10 rows selected. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 lhoska@calibre sys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Last Update om 07/17/2001 12:57 PM Please respond to ORACLE-L 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Last Update
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, sel privs on the tables that get changed each morning. OS linux 7.0 Oracle 8.1.7 Your thoughts? ROR mª¿ªm [EMAIL PROTECTED] 07/17/01 02:20PM 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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
RE: Last 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 AMTo: Multiple recipients of list ORACLE-LHi,Thanks for the clarification. Always welcome. shreepadTo: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAILcc:However you can query the view dba_tab_modificationsfor checking when and how manyupdates/deletes/inserts/truncate have been done on thetable. If this is enough, great, don't you think so ?.Regards.--- Shreepad Vaidya [EMAIL PROTECTED]wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).=Eng. Christian TrassensSenior DBASystems Engineer[EMAIL PROTECTED][EMAIL PROTECTED]Phone :
RE: Last Update
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 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, sel privs on the tables that get changed each morning. OS linux 7.0 Oracle 8.1.7 Your thoughts? ROR mª¿ªm [EMAIL PROTECTED] 07/17/01 02:20PM 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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: Last Update
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 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, sel privs on the tables that get changed each morning.OS linux 7.0Oracle 8.1.7Your thoughts?ROR mª¿ªm [EMAIL PROTECTED] 07/17/01 02:20PM 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 PMTo: Multiple recipients of list ORACLE-LGuys,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 AMTo: Multiple recipients of list ORACLE-LHi,Thanks for the clarification. Always welcome. shreepadTo: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAILcc:However you can query the view dba_tab_modificationsfor checking when and how manyupdates/deletes/inserts/truncate have been done on thetable. If this is enough, great, don't you think so ?.Regards.--- Shreepad Vaidya [EMAIL PROTECTED]wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Last Update
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 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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: Last Update
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 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, sel privs on the tables that get changed each morning. OS linux 7.0 Oracle 8.1.7 Your thoughts? ROR mª¿ªm [EMAIL PROTECTED] 07/17/01 02:20PM 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 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 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 done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Last Update
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 shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Last Update
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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Last Update
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 updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: Last Update
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 table/data has been modified. Go back to it in an hour or so.. -Original Message- Sent: Monday, July 16, 2001 03:36 To: Multiple recipients of list ORACLE-L 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 updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: Last Update
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 monitoring; joe [EMAIL PROTECTED] 07/16/01 10:36AM 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 updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: 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 trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
RE: Last Update
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 say you can use logminer but then again that is just a guess.HTHRaj__Rajendra Jamadagni MIS, ESPN Inc.Rajendra dot Jamadagni at ESPN dot comAny opinion expressed here is personal and doesn't reflect that of ESPN Inc.QOTD: Any clod can have facts, but having an opinion is an art !*2This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Last Update
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 tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).