find out oracle update user table

Dear all,

any tools/script to find out all the updated table in anytime and ordre in in asc and/or desc way ?

I want to see which table change most frequently and the second and third one.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
sdstuberCommented:
it doesn't matter "how" the updates occur.  CDC or manual sql statements or anything in between.  Auditing and/or log miner will show you what you are looking for.


If you use application logs, then it might matter. - but that would be your code, so only you can determine if they are applicable.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please clarify what exactly you understand by "change"?
are you referring to UPDATE statments, and INSERT/DELETEs, or really the ALTER TABLE (changing structures...)

In short, without have some "audit" information (saving the events of changes in a dedicated table) you will not have such numbers with a "system query"
0
 
sdstuberCommented:
if you don't have auditing or application logs then you'll need to use log miner, sifting through archive logs .


http://docs.oracle.com/cd/E11882_01/server.112/e22490/logminer.htm#SUTIL019
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
marrowyungSenior Technical architecture (Data)Author Commented:
Guy Hengel,

"are you referring to UPDATE statments, and INSERT/DELETEs, or really the ALTER TABLE (changing structures...)"

as I tried to setup Async CDC for the oracle, so I would like to try/test on a table which has update. so I source for one in oracle, so any kind of update/insert/delete are welcome

sdstuber,

I want to find a frequently update table as the candidates for the Async CDC hotlog setup. so that I can see how well is the Async CDC perform.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
" Auditing and/or log miner will show you what you are looking for."

I don't use log miner as I study this here before and later on we found that CDC is what we want,.

but I need a table has update for us to show what will be the CDCed record looks like.

"If you use application logs, then it might matter. - but that would be your code, so only you can determine if they are applicable. "

we need DB level.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
I will use this one :http://amit7oracledba.blogspot.hk/2013/08/how-to-implement-change-data-capture-in.html

to implement what I want as this is 90% close to the version  I am going to use and this link is easlier to read.

then you know why I need CDC ..
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
may I know how to find table order by most frequently update ?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
guys sorry, focus on other post and in new company now focusing on SQL server replication envirionemnt .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.