| logminer issue [message #327199] |
Sat, 14 June 2008 14:26  |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
Hi all,
I was trying to use logminer to analyse the files during a particular period.
EXECUTE DBMS_LOGMNR.START_LOGMNR( -
STARTTIME => '14-JUN-2008 11:00:00', -
ENDTIME => '14-JUN-2008 13:00:00', -
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -
DBMS_LOGMNR.CONTINUOUS_MINE);
select seg_owner, seg_name, operation, count(*) from v$logmnr_contents where seg_owner != 'SYS' group by
seg_owner, seg_name, operation;
When I try to query the view v$logmnr_contents , it just hangs there forever without giving any output.
Am I missing something here?
oracle database:10.2.0.2
|
|
|
|
|
|
|
|
| Re: logminer issue [message #328710 is a reply to message #327199] |
Sun, 22 June 2008 00:48  |
ora110
Messages: 42
Registered: September 2007
Location: China
|
Member |
|
|
of course.
It will take a long time to select table v$logmnr_contents which is huge table.
--------------
just finish it in command line.do not use the GUI TOOLS .
|
|
|
|
| Re: logminer issue [message #328711 is a reply to message #328710] |
Sun, 22 June 2008 01:38 |
 |
Michel Cadot
Messages: 68682
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
1/ In all what you posted today I don't see anything valuable. Just a yes, no, of course on topic already answered at least one week ago. What is your purpose?
2/ OP USED statement and NOT GUI, read his post.
3/ v$logmnr_contents is NOT a table.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
