Re: tables

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/10/28
Message-ID: <718obm$fte@dfw-ixnews6.ix.netcom.com>#1/1

If you analyze the table, there will be a column called num_rows in the dba_tables view. From that, you can tell how the changes of the number of rows for that particular tables. You can do so for all the tables. But beware that this may change you query to CBO. ANd if the tables are huge, it may really take quite some time.

Another method, if you really have time, query the sql_text from v$sql frequently, it will give you all the DML statement in the shared_pooh_area!

Winnie

daud11_at_hotmail.com wrote in message <715o7c$489$1_at_nnrp1.dejanews.com>...
>Hi
>
>In the last few days, space used in one of our tablespaces has been growing
>very fast and we had to increase the tablespace size. Is there a way to
find
>out which tables have had many rows inserted into them in the last few
days?
>We are using oracle 7.3.3.5.1 and oracle apps 10.7.0 (i think?) and the
>tablespace concern is OED.
>
>thanks
>Daud
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Oct 28 1998 - 00:00:00 CST