-
Can somebody explain me the following ---
when we required the following
alter table CCADMIN.USER_AUDIT monitoring ;
-
When a table is created with "MONITORING" option, Oracle gathers the DML activities (INSERT, UPDATE, DELETE and TRUNCATE) on the table and stores it USER_TAB_MODIFICATIONS. This is helpful for automatically generating statistics on the table.
Remember that Oracle takes hours to populate the statistics after the DML activity is performed on the base table.
-
Will it affect the performance , let say if the tables are big enough and much DML activity.
???
Thanks for your reply ,
Madhu
-
The performance is not affected in a OLTP system.
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
|