-
Hi,
We are on Oracle 8.0.5.
I am looking for some script which shows DML,DDL activities in the database within all tables/objects in a specific time frame.
Example: Betw 2:00 PM to 3:00 PM, which are the tables in which DML transactions have been made. Also if possible, in terms of number of blocks/extents increased.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Hmm, since you are on 8.0.5, you can't use logminer.
You could set sql_trace on for the instance during that time frame. That might give you the DML you are looking for.
Jeff Hunter
-
auditing
cant u use auditing for this?
OCP DBA 8i
ocpwannabe@yahoo.com
-----------------------------
When in doubt, pick 'C'.
-
Jeff,
sql_trace is set to true in init.ora. Now, how can I check the DML out of it?
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Re: auditing
There are thousands of tables and I don't want to increase any other overhead due to Auditing.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
1) Enable Auditing - heavy overhead
2) Enable SQL_trace - lots and lots of trace files.
3) dump the redlog file /archive log file for the period.-- need to know internal structures.
-
Originally posted by samdba
Jeff,
sql_trace is set to true in init.ora. Now, how can I check the DML out of it?
see steps 2 and 3 of this link: http://otn.oracle.com/docs/products/...4_str.htm#8760
Jeff Hunter
-
dump the redlog file /archive log file for the period.-- need to know internal structures.
- Infact, my original question is because, I want to know why lot of 100M Arch log files are getting generated. What makes these logs generated every 3-4 minutes inspite of low number of users and transactions.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Then u should firstr run utlbstat.estat to find out the
amount of redo generated,rollback generated , checkpoints done.
-
gpsingh,
I have already done that.
Is there any system table which stores block level information showing blocks inserted, updated, deleted for a particular table/index or datafile?
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|