For table to have a record in dba_tab_modifications it need to be monitored.
use alter table 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: Multipl
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 ex
you need to have turned monitoring on the the
table(s).
alter table 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 trunc
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 Up
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, 20
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, s
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
Gu
lhoska@calibre
sys.com To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subjec
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
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 clarificat
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 do
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
--- JOE TESTA <[EMAIL PROTECTED]> wrote:
> you have to turn monitoring on for each table.
>
> alter table monitoring;
>
> joe
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
you have to turn monitoring on for each table.
alter table monitoring;
joe
>>> [EMAIL PROTECTED] 07/16/01 10:36AM
>>>Hi,but in my 8.1.7 db. (on SOLARIS), NO ROWS
SELECTED when queriedDBA_TAB_MODIFICATIONS...Any init
parameters to be enabled??Arul.Christian Trassens
wrot
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/t
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
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
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
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
If you issue an alter table . monitoring for an
existing one or when you create issuing: create table
monitoring, the SMON will update that kind of
statistics every three hours or when you bounce and
startup the database. You can see them on the view
dba_tab_modifications. This helps for
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 te
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 co
Erik,
AFAIK, you will have to maintain that ... I don't think Oracle maintains
that information ... now in my wildest guess I could say you can use log
miner but then again that is just a guess.
HTH
Raj
__
Rajendra Jamadagni MIS, E
23 matches
Mail list logo
