| Logminer Dictionary file- Large in Size [message #494245] |
Sat, 12 February 2011 03:17  |
 |
arunb1982
Messages: 34
Registered: December 2010
Location: Bangalore
|
Member |
|
|
Hi ,
There is a offline_dictionary.ir file created by Logminer which is like 13G in our "DIAG" directory.
What is the significance of this file and can it be removed?
I tried to search about this file, but couldn't get much on this.
This is what I got from metalink doc id 755838.1
Quote:2. HM_CREATE_OFFLINE_DICTIONARY
The job is created by the 11g script catmwin.sql which mentions that this is a job for creation of offline dictionary for Database Repair Advisor.
From unpublished Note 602459.1 - 'What Is OFFLINE_DICTIONARY': 'The system job SYS.HM_CREATE_OFFLINE_DICTIONARY executes the dbms_hm.create_offline_dictionary package which creates a LogMiner offline dictionary in the ADR for DRA name translation service. The job for generating the logminer dictionary is scheduled during the maintenance window. This job can be disabled. '
Thanks in advance.
Arun
|
|
|
|
|
|
| Re: Logminer Dictionary file- Large in Size [message #494249 is a reply to message #494247] |
Sat, 12 February 2011 04:09  |
|
arunb1982
Messages: 34
Registered: December 2010
Location: Bangalore
|
Member |
|
|
Hi Michel,
Thanks for the quick response and suggestions
We haven't enable any Logminer session and I checked all LOGMNR dictionary tables and all are returning 0 rows.
Usually I see this files getting populate during the maintenance window.
And about what job is to be disabled as per Oracle to disable this?
Are they talking about the scheduled maintenance window.(10PM to 6AM)?
Thanks,
Arun
[Updated on: Sat, 12 February 2011 04:11] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
