Home » RDBMS Server » Server Administration » logminer issue
logminer issue [message #327199] Sat, 14 June 2008 14:26 Go to next message
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 #327203 is a reply to message #327199] Sat, 14 June 2008 20:42 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above


post results from
select sysdate from dual;
Re: logminer issue [message #327226 is a reply to message #327203] Sun, 15 June 2008 07:51 Go to previous messageGo to next message
orcl dba
Messages: 68
Registered: August 2005
Member
The query went through eventually. It just took some time as there were huge tables being queried.
Re: logminer issue [message #328710 is a reply to message #327199] Sun, 22 June 2008 00:48 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Oracle Data Block
Next Topic: how to find out edition of oracle 10G instance ?
Goto Forum:
  


Current Time: Sun Dec 04 20:51:26 CST 2016

Total time taken to generate the page: 0.04388 seconds