Re: spurious activities...

"JoeB" <nomail_at_nomail.com> schrieb im Newsbeitrag news:dkRRa.164$Ai3.34_at_newsfep4-winn.server.ntli.net...
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:bf5ves$p6r$1_at_news.fujitsu-siemens.com...
> > Hi!
> > Since a few months I'm in charge of an oracle db (9.2.0.3.0, linux).
> > A week ago I set the archive_lag target so I could see what happens
> > when there's no activity.
> > The result was that the db created 900K of redo info per hour, even if
> > nothing happens. The archived redologs are roughly similar in size
> > (890K-950K, once 500K). The redologs themselves are configured to
> > be 50M in size.
> > Is this redo activity normal?
> >
> > Lots of Greetings!
> > Volker
> >
>
> Why don't you use logminer to see what's going on when "nothing happens"?
I tried.
first, it always crashed its session as soon as I did more than one select against the view
(stopped responding, refused to be killed, blocked shutdown abort, had to manually clean up
after a startup force) and when I tried to get the data into a different table it died with
an ORA-00600. Can't say I'm too impressed with it so far. Maybe I'm doing something wrong?

Here's my script:
begin
dbms_logmnr.add_logfile(logfilename=>'/backup/oracle/ArchiveMirrors/ECADBIB/ 1_696.dbf', options=>dbms_logmnr.new);
dbms_logmnr.start_logmnr(
options =>
dbms_logmnr.dict_from_redo_logs+dbms_logmnr.ddl_dict_tracking+dbms_logmnr.co ntinuous_mine,
ENDTIME => to_date('20030722T050000','YYYYMMDD"T"HH24MISS') );
end;
/
drop table volkerperftest.vhe_logminer;
create table volkerperftest.vhe_logminer nologging as select * from v$logmnr_contents;
execute dbms_logmnr.end_logmnr();
create index volkerperftest.vhe_logminer_ind_scn on volkerperftest.vhe_logminer (scn) nologging; create index volkerperftest.vhe_logminer_ind_timestamp on volkerperftest.vhe_logminer (timestamp) nologging; create bitmap index volkerperftest.vhe_logminer_ind_username on volkerperftest.vhe_logminer (username) nologging; exit

I did the build with the redo option before.

Lots of Greetings and thanks!
Volker Received on Tue Jul 22 2003 - 14:49:30 CDT