Home » RDBMS Server » Backup & Recovery » 10g Archive log files fill disk
| 10g Archive log files fill disk [message #117506] |
Wed, 27 April 2005 10:57  |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
hi all,
I'm a newbie to Oracle 10g trying to prepare a migration from
Oracle 7 to Oracle 10g...
I created a test database that is running in archivelog mode.
I noticed that Oracle generates about 150 MB of archive log files a day although there are no transactions going on whatsoever. I just wonder if this is a normal behaviour...
Also if i start a stored procedure that's supposed to be run on a daily basis (if this once becomes a production database...),
Oracle generates another 600 MB of archive log files in addition... if i compare this to an average of 180 MB of archive log files a day, that our oracle 7 production database produces with quite some transactions over the day plus the before mentioned stored procedure, i tend to think that there is something going wrong...
with an estimated 1G+ of archive log files a day just for one instance (there are several more supposed to be running on the same box once) i'm a little afraid to have my discs filled up pretty fast...
any ideas how to fix this or do i just have to get used to this using 10g?
thanx in advance
Horst Borscht
|
|
|
|
| Re: 10g Archive log files fill disk [message #117653 is a reply to message #117506] |
Thu, 28 April 2005 14:31  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
The increased redo generation might be as a result of AWR's stats collection and metrics. Try to set STATISTICS_LEVEL=BASIC to disable this and let us know the results.
Just note: setting this parameter to BASIC will practically disable all 10g's "self management" features (auto stats collection, ADDM, etc.).
Best regards.
Frank
|
|
|
|
| Re: 10g Archive log files fill disk [message #117717 is a reply to message #117653] |
Fri, 29 April 2005 03:42 |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
hi Frank,
Thanks for your answer, indeed statistics_level was "typical",i set it to "basic" now, will tell you if it makes a difference...
You said that this will disable Oracles self management features... does this include stuff like Flashback logging and automatic undo management?
Regards
Horst
|
|
|
|
| Re: 10g Archive log files fill disk [message #117964 is a reply to message #117653] |
Mon, 02 May 2005 03:42 |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
hi Frank,
setting STATISTICS_LEVEL to BASIC seems to have reduced the archive log generation to like 100 MB a day... with still no user transaction going on at all... btw: I noticed that obviously flashback logging is not disabled by setting STATISTICS_LEVEL to BASIC... I assume that neither is automatic undo management... so that seems to already have answered my previous question concerning this...
Thanks again
Horst
|
|
|
|
| Re: 10g Archive log files fill disk [message #118007 is a reply to message #117653] |
Mon, 02 May 2005 10:01 |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
Hi Frank,
I was still a little puzzled about the 100 Mb of archive logs a day on a seemingly idle instance, so i ran dbms_logmnr.start_logmnr to find out about the content of my archive logs...
my query (select distinct SQL_REDO from v$logmnr_contents
where SQL_REDO is not null and SQL_REDO<>'Unsupported'; )
basically returned the following:
-----------------------
delete from "DBSNMP"."MGMT_RESPONSE_CAPTURE" where "INSTANCE_NUMBER" = '1' and "CAPTURE_ID" = '2526' and "HASH_VALUE" = '955553206' and "ADDRESS" = HEXTORAW('68de7fb4') and "ELAPSED_TIME" = '107852' and "EXECUTIONS" = '8' and ROWID = 'AAACKIAADAAABIgAAw';
delete from "SYSMAN"."MGMT_DB_HDM_METRIC_HELPER" where ROWID = 'AAAL72AADAAAGP4AAA';
delete from "SYSMAN"."MGMT_HA_MTTR" where ROWID = 'AAAL7FAADAAAGJ4AAA';
delete from "SYSMAN"."MGMT_JOB_EXECUTION" where "JOB_ID" = HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05') and "EXECUTION_ID" = HEXTORAW('784fcd98ae5e4f7785bd9aef785100ef') and "STEP_ID" = '220' and "SOURCE_STEP_ID" IS NULL and "ORIGINAL_STEP_ID" IS NULL and "RESTART_MODE" = '1' and "STEP_NAME" = 'REFRESH_FROM_METALINK_JOB' and "STEP_TYPE" = '7' and "COMMAND_TYPE" IS NULL and "ITERATE_PARAM" IS NULL and "ITERATE_PARAM_INDEX" = '-1' and "PARENT_STEP_ID" = '-1' and "STEP_STATUS" = '3' and "STEP_STATUS_CODE" = '0' and "NUM_CHILDREN" = '1' and "NUM_CHILDREN_COMPLETED" = '1' and "OUTPUT_ID" IS NULL and "ERROR_ID" IS NULL and "START_TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "END_TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "TIMEZONE_REGION" = '+02:00' and "SEQUENCE_NUMBER" = '-1' and "DISPATCHER_ID" = '-1' and "EMD_URL" IS NULL and ROWID = 'AAALxpAADAAAFp2AAA';
delete from "SYSMAN"."MGMT_JOB_EXEC_SUMMARY" where "JOB_ID" = HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05') and "EXECUTION_ID" = HEXTORAW('eb168deb48044a39aefc83f83311f343') and "SOURCE_EXECUTION_ID" = HEXTORAW('eb168deb48044a39aefc83f83311f343') and "TARGET_LIST_INDEX" = '1' and "STATUS" = '3' and "STATUS_BUCKET" = '-4' and "SCHEDULED_TIME" = TO_DATE('24.04.05', 'DD.MM.RR') and "START_TIME" = TO_DATE('23.04.05', 'DD.MM.RR') and "END_TIME" = TO_DATE('23.04.05', 'DD.MM.RR') and "TIMEZONE_REGION" = '+02:00' and "SUSPEND_EVENT" IS NULL and "SUSPEND_TIME" IS NULL and "SUSPEND_TIMEOUT" = '0' and "QUEUE_ID" IS NULL and "QUEUE_INDEX" IS NULL and ROWID = 'AAALxeAADAAAFocAAC';
delete from "SYSMAN"."MGMT_JOB_HISTORY" where "JOB_ID" = HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05') and "EXECUTION_ID" = HEXTORAW('eb168deb48044a39aefc83f83311f343') and "STEP_ID" = '164' and "SOURCE_STEP_ID" IS NULL and "ORIGINAL_STEP_ID" IS NULL and "RESTART_MODE" = '1' and "STEP_NAME" = 'REFRESH_FROM_METALINK_JOB' and "STEP_TYPE" = '7' and "COMMAND_TYPE" IS NULL and "ITERATE_PARAM" IS NULL and "ITERATE_PARAM_INDEX" = '-1' and "PARENT_STEP_ID" = '-1' and "STEP_STATUS" = '3' and "STEP_STATUS_CODE" = '0' and "NUM_CHILDREN" = '1' and "NUM_CHILDREN_COMPLETED" = '1' and "OUTPUT_ID" IS NULL and "ERROR_ID" IS NULL and "START_TIME" = TO_DATE('23.04.05', 'DD.MM.RR') and "END_TIME" = TO_DATE('23.04.05', 'DD.MM.RR') and "TIMEZONE_REGION" = '+02:00' and "SEQUENCE_NUMBER" = '-1' and "DISPATCHER_ID" = '-1' and ROWID = 'AAALxnAADAAAFpkAAe';
delete from "SYSMAN"."MGMT_JOB_OUTPUT" where "OUTPUT_ID" = HEXTORAW('db05c1b5b22848a7b589b75a8e7985e0') and "REFERENCE_COUNT" = '0' and ROWID = 'AAALxWAADAAAFnfAAH';
delete from "SYSMAN"."MGMT_STRING_METRIC_HISTORY" where ROWID = 'AAALrlAADAAAJh8AA/';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'AGENT_STATUS_MARKER' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '15' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'AGENTS_MARKED' and "VALUE" = '0' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/LABa';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'EMD_COLLECTION.Collection Subsystem' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'Collections' and "VALUE" = '1' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/LABO';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'LOADER' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" = 'XMLLoader0' and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '1' and "CLIENT_DATA" = 'D:\oracle\95s030011db_olav11\sysman\recv\70000001863.xml' and "HOST_URL" = '95s030011db_Management_Service' and ROWID = 'AAALyBAADAAAFsvAAN';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'MGMT_SYS_JOB' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '1' and "MODULE" = 'Repository_sessions' and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'metrics' and "VALUE" = '1' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/QABW';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'PURGE 1DAY' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '0' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAGZsABR';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'PURGE 1HOUR' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '78' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/LABE';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'PURGE ERROR LOG' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '0' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAGZsABS';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'PURGE PERFORMANCE LOG' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '153' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAGZsABT';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'PURGE RAW' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '1000' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '1523' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/LABC';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'ROLLUP 1DAY' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '0' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAGZsABP';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'ROLLUP 1HOUR' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '0' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '99' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAGZsABN';
delete from "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" where "JOB_NAME" = 'ROLLUP' and "TIME" = TO_DATE('30.04.05', 'DD.MM.RR') and "DURATION" = '1000' and "MODULE" IS NULL and "ACTION" IS NULL and "IS_TOTAL" = 'Y' and "NAME" = 'RECORDS' and "VALUE" = '1721' and "CLIENT_DATA" IS NULL and "HOST_URL" IS NULL and ROWID = 'AAALyBAADAAAH/LABA';
insert into "DBSNMP"."MGMT_RESPONSE_CAPTURE"("INSTANCE_NUMBER","CAPTURE_ID","HASH_VALUE","ADDRESS","ELAPSED_TIME","EXECUTIONS") values ('1','2498','1165636759',HEXTORAW('694424d4'),'46629351','33950');
insert into "SYSMAN"."MGMT_DB_HDM_METRIC_HELPER"("TARGET_GUID","COLLECTION_TIMESTAMP","TASK_AVAILABLE") values (HEXTORAW('cba0a3f5dd5e4422dc05799ded34d076'),TO_DATE('01.05.05', 'DD.MM.RR'),'1');
insert into "SYSMAN"."MGMT_HA_MTTR"("TARGET_GUID","COLLECTION_TIMESTAMP","ESTIMATED_MTTR") values (HEXTORAW('cba0a3f5dd5e4422dc05799ded34d076'),TO_DATE('01.05.05', 'DD.MM.RR'),'9');
insert into "SYSMAN"."MGMT_JOB_EXECUTION"("JOB_ID","EXECUTION_ID","STEP_ID","SOURCE_STEP_ID","ORIGINAL_STEP_ID","RESTART_MODE","STEP_NAME ","STEP_TYPE","COMMAND_TYPE","ITERATE_PARAM","ITERATE_PARAM_INDEX","PARENT_STEP_ID","STEP_STATUS","STEP_STATUS_CODE","NUM_CHILDREN ","NUM_CHILDREN_COMPLETED","OUTPUT_ID","ERROR_ID","START_TIME","END_TIME","TIMEZONE_REGION","SEQUENCE_NUMBER","DISPATCHER_ID ","EMD_URL") values (HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05'),HEXTORAW('ea46425533544205ae2b93659aab2d55'),'239','-1','-1','1','RefreshFromMetalink', '1','1',NULL,'-1','238','1','0','0','0',NULL,NULL,TO_DATE('01.05.05', 'DD.MM.RR'),NULL,'+02:00','-1','-1',NULL);
insert into "SYSMAN"."MGMT_JOB_EXEC_SUMMARY"("JOB_ID","EXECUTION_ID","SOURCE_EXECUTION_ID","TARGET_LIST_INDEX","STATUS","STATUS_BUCKET ","SCHEDULED_TIME","START_TIME","END_TIME","TIMEZONE_REGION","SUSPEND_EVENT","SUSPEND_TIME","SUSPEND_TIMEOUT","QUEUE_ID ","QUEUE_INDEX") values (HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05'),HEXTORAW('ea46425533544205ae2b93659aab2d55'),HEXTORAW('ea46425533544205ae2b93659aab2d55 '),'1','1','-1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL);
insert into "SYSMAN"."MGMT_JOB_HISTORY"("JOB_ID","EXECUTION_ID","STEP_ID","SOURCE_STEP_ID","ORIGINAL_STEP_ID","RESTART_MODE","STEP_NAME ","STEP_TYPE","COMMAND_TYPE","ITERATE_PARAM","ITERATE_PARAM_INDEX","PARENT_STEP_ID","STEP_STATUS","STEP_STATUS_CODE","NUM_CHILDREN ","NUM_CHILDREN_COMPLETED","OUTPUT_ID","ERROR_ID","START_TIME","END_TIME","TIMEZONE_REGION","SEQUENCE_NUMBER","DISPATCHER_ID ") values (HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05'),HEXTORAW('ea46425533544205ae2b93659aab2d55'),'239','-1','-1','1','RefreshFromMetalink', '1','1',NULL,'-1','238','1','0','0','0',NULL,NULL,TO_DATE('01.05.05', 'DD.MM.RR'),NULL,'+02:00','-1','-1');
insert into "SYSMAN"."MGMT_JOB_OUTPUT"("OUTPUT_ID","REFERENCE_COUNT","OUTPUT") values (HEXTORAW('c57c3ddfbfb845969cb87587ef81f099'),'1','
Oracle MetaLink-Autorisierung wird geprüft.
MetaLink-Benutzername:
MetaLink-Kennwort:
URL für Patch-Suche: http://updates.oracle.com
- Oracle MetaLink-ID-Daten sind falsch oder fehlen. Klicken Sie auf Patching Setup, um die erforderlichen Parameter festzulegen.');
insert into "SYSMAN"."MGMT_STRING_METRIC_HISTORY"("TARGET_GUID","METRIC_GUID","KEY_VALUE","COLLECTION_TIMESTAMP","STRING_VALUE") values (HEXTORAW('0c48c5ae0fafb42ed91f897ff398fc84'),HEXTORAW('e13060302dfe9a16f423d61f3cbe52a0'),'EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS ();',TO_DATE('01.05.05', 'DD.MM.RR'),'Mai 01, 2005 01:00:28 AM');
insert into "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG"("JOB_NAME","TIME","DURATION","MODULE","ACTION","IS_TOTAL","NAME","VALUE","CLIENT_DATA ","HOST_URL") values ('ROLLUP',TO_DATE('01.05.05', 'DD.MM.RR'),'0',NULL,NULL,'Y','RECORDS','1736',NULL,NULL);
rollback;
set transaction read write;
truncate table mgmt_db_file_gtt ;
truncate table mgmt_db_size_gtt ;
update "SYS"."COL_USAGE$" set "EQUALITY_PREDS" = '0', "EQUIJOIN_PREDS" = '0', "NONEQUIJOIN_PREDS" = '0', "RANGE_PREDS" = '0', "LIKE_PREDS" = '0', "NULL_PREDS" = '16', "TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') where "EQUALITY_PREDS" = '0' and "EQUIJOIN_PREDS" = '0' and "NONEQUIJOIN_PREDS" = '0' and "RANGE_PREDS" = '0' and "LIKE_PREDS" = '0' and "NULL_PREDS" = '15' and "TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') and ROWID = 'AAAAH/AABAAAA/FAAY';
update "SYS"."JOB$" set "LAST_DATE" = TO_DATE('30.04.05', 'DD.MM.RR'), "THIS_DATE" = NULL, "NEXT_DATE" = TO_DATE('30.04.05', 'DD.MM.RR'), "TOTAL" = ',00811342592592592592592592592592592592588', "FAILURES" = '0', "FLAG" = '0' where "LAST_DATE" = TO_DATE('30.04.05', 'DD.MM.RR') and "THIS_DATE" = TO_DATE('30.04.05', 'DD.MM.RR') and "NEXT_DATE" = TO_DATE('30.04.05', 'DD.MM.RR') and "TOTAL" = ',00810185185185185185185185185185185185181' and "FAILURES" = '0' and "FLAG" = '0' and ROWID = 'AAAADJAABAAAAXCAAC';
update "SYS"."JOB$" set "THIS_DATE" = TO_DATE('01.05.05', 'DD.MM.RR') where "THIS_DATE" IS NULL and ROWID = 'AAAADJAABAAAAXCAAA';
update "SYS"."JOB$" set "THIS_DATE" = TO_DATE('01.05.05', 'DD.MM.RR') where "THIS_DATE" IS NULL and ROWID = 'AAAADJAABAAAAXCAAB';
update "SYS"."JOB$" set "THIS_DATE" = TO_DATE('01.05.05', 'DD.MM.RR') where "THIS_DATE" IS NULL and ROWID = 'AAAADJAABAAAAXCAAC';
update "SYS"."JOB$" set "THIS_DATE" = TO_DATE('30.04.05', 'DD.MM.RR') where "THIS_DATE" IS NULL and ROWID = 'AAAADJAABAAAAXCAAC';
update "SYS"."SEQ$" set "INCREMENT$" = '1', "MINVALUE" = '1', "MAXVALUE" = '2000000000', "CYCLE#" = '1', "ORDER$" = '0', "CACHE" = '20', "HIGHWATER" = '42759', "AUDIT$" = '--------------------------------', "FLAGS" = '0' where "INCREMENT$" = '1' and "MINVALUE" = '1' and "MAXVALUE" = '2000000000' and "CYCLE#" = '1' and "ORDER$" = '0' and "CACHE" = '20' and "HIGHWATER" = '42739' and "AUDIT$" = '--------------------------------' and "FLAGS" = '0' and ROWID = 'AAAABDAABAAAAHqAAE';
update "SYS"."WRI$_SCH_CONTROL" set "LAST_VOTE" = '1114896163', "NUM_VOTES" = '80' where "LAST_VOTE" = '1114892560' and "NUM_VOTES" = '79' and ROWID = 'AAACAaAADAAAA1tAAA';
update "SYS"."WRI$_SCH_VOTES" set "VECTOR" = '16776960' where "VECTOR" = '8388352' and ROWID = 'AAACAcAADAAAA19AAF';
update "SYSMAN"."MGMT_AVAILABILITY_MARKER" set "MARKER_TIMESTAMP" = TO_DATE('01.05.05', 'DD.MM.RR') where "MARKER_TIMESTAMP" = TO_DATE('01.05.05', 'DD.MM.RR') and ROWID = 'AAALrPAADAAAE4kAAA';
update "SYSMAN"."MGMT_DB_HDM_METRIC_HELPER" set "COLLECTION_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR'), "TASK_AVAILABLE" = '1' where "COLLECTION_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') and "TASK_AVAILABLE" = '1' and ROWID = 'AAAL72AADAAAGP2AAA';
update "SYSMAN"."MGMT_EMD_PING" set "LAST_HEARTBEAT_TS" = TO_DATE('30.04.05', 'DD.MM.RR'), "LAST_HEARTBEAT_UTC" = TO_DATE('30.04.05', 'DD.MM.RR'), "CLEAN_HEARTBEAT_UTC" = TO_DATE('30.04.05', 'DD.MM.RR'), "STATUS_SYNC_UTC" = TO_DATE('30.04.05', 'DD.MM.RR'), "EMD_UPTIME_UTC" = TO_DATE('26.04.05', 'DD.MM.RR'), "HEARTBEAT_RECORDER_URL" = 'http://95s030011db:5501/em/upload/' where "LAST_HEARTBEAT_TS" = TO_DATE('30.04.05', 'DD.MM.RR') and "LAST_HEARTBEAT_UTC" = TO_DATE('30.04.05', 'DD.MM.RR') and "CLEAN_HEARTBEAT_UTC" = TO_DATE('30.04.05', 'DD.MM.RR') and "STATUS_SYNC_UTC" = TO_DATE('30.04.05', 'DD.MM.RR') and "EMD_UPTIME_UTC" = TO_DATE('26.04.05', 'DD.MM.RR') and "HEARTBEAT_RECORDER_URL" = 'http://95s030011db:5501/em/upload/' and ROWID = 'AAALyWAADAAAFvMAAA';
update "SYSMAN"."MGMT_FAILOVER_TABLE" set "LAST_TIME_STAMP" = TO_DATE('01.05.05', 'DD.MM.RR') where "LAST_TIME_STAMP" = TO_DATE('01.05.05', 'DD.MM.RR') and ROWID = 'AAALwEAADAAAFdVAAA';
update "SYSMAN"."MGMT_HA_MTTR" set "COLLECTION_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR'), "ESTIMATED_MTTR" = '9' where "COLLECTION_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') and "ESTIMATED_MTTR" = '9' and ROWID = 'AAAL7FAADAAAGJ2AAA';
update "SYSMAN"."MGMT_JOB_EXECUTION" set "NUM_CHILDREN" = '1' where "NUM_CHILDREN" = '0' and ROWID = 'AAALxpAADAAAFp2AAD';
update "SYSMAN"."MGMT_JOB_EXEC_SUMMARY" set "STATUS" = '1', "STATUS_BUCKET" = '-1', "SCHEDULED_TIME" = TO_DATE('02.05.05', 'DD.MM.RR'), "START_TIME" = TO_DATE('01.05.05', 'DD.MM.RR'), "TIMEZONE_REGION" = '+02:00' where "STATUS" = '1' and "STATUS_BUCKET" = '-1' and "SCHEDULED_TIME" IS NULL and "START_TIME" IS NULL and "TIMEZONE_REGION" IS NULL and ROWID = 'AAALxeAADAAAFoeAAC';
update "SYSMAN"."MGMT_JOB_HISTORY" set "JOB_ID" = HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05'), "EXECUTION_ID" = HEXTORAW('ea46425533544205ae2b93659aab2d55'), "STEP_ID" = '238', "SOURCE_STEP_ID" = '-1', "ORIGINAL_STEP_ID" = '-1', "RESTART_MODE" = '1', "STEP_NAME" = 'RefreshFromMetalinkJob', "STEP_TYPE" = '2', "COMMAND_TYPE" = NULL, "ITERATE_PARAM" = NULL, "ITERATE_PARAM_INDEX" = '-1', "PARENT_STEP_ID" = '237', "STEP_STATUS" = '1', "STEP_STATUS_CODE" = '0', "NUM_CHILDREN" = '1', "NUM_CHILDREN_COMPLETED" = '0', "OUTPUT_ID" = NULL, "ERROR_ID" = NULL, "START_TIME" = TO_DATE('01.05.05', 'DD.MM.RR'), "END_TIME" = NULL, "SEQUENCE_NUMBER" = '-1', "DISPATCHER_ID" = '-1' where "JOB_ID" = HEXTORAW('3c2e468b8c744e7bbcb3bc0027563c05') and "EXECUTION_ID" = HEXTORAW('ea46425533544205ae2b93659aab2d55') and "STEP_ID" = '238' and "SOURCE_STEP_ID" = '-1' and "ORIGINAL_STEP_ID" = '-1' and "RESTART_MODE" = '1' and "STEP_NAME" = 'RefreshFromMetalinkJob' and "STEP_TYPE" = '2' and "COMMAND_TYPE" IS NULL and "ITERATE_PARAM" IS NULL and "ITERATE_PARAM_INDEX" = '-1' and "PARENT_STEP_ID" = '237' and "STEP_STATUS" = '1' and "STEP_STATUS_CODE" = '0' and "NUM_CHILDREN" = '1' and "NUM_CHILDREN_COMPLETED" = '0' and "OUTPUT_ID" IS NULL and "ERROR_ID" IS NULL and "START_TIME" = TO_DATE('01.05.05', 'DD.MM.RR') and "END_TIME" IS NULL and "SEQUENCE_NUMBER" = '-1' and "DISPATCHER_ID" = '-1' and ROWID = 'AAALxnAADAAAFpmAAH';
update "SYSMAN"."MGMT_JOB_OUTPUT" set "REFERENCE_COUNT" = '0' where "REFERENCE_COUNT" = '1' and ROWID = 'AAALxWAADAAAFnfAAH';
update "SYSMAN"."MGMT_METRIC_COLLECTIONS" set "LAST_COLLECTED_TIMESTAMP" = TO_DATE('01.05.05', 'DD.MM.RR'), "STATUS_MESSAGE" = 'MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS returned 1 values' where "LAST_COLLECTED_TIMESTAMP" = TO_DATE('01.05.05', 'DD.MM.RR') and "STATUS_MESSAGE" = 'MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS returned 1 values' and ROWID = 'AAALsrAADAAAFDNAAG';
update "SYSMAN"."MGMT_OMS_PARAMETERS" set "VALUE" = '0,00' where "VALUE" = '0,00' and ROWID = 'AAALswAADAAAFD4AAH';
update "SYSMAN"."MGMT_PARAMETERS" set "PARAMETER_VALUE" = '16' where "PARAMETER_VALUE" = '15' and ROWID = 'AAALsvAADAAAFDtAAG';
update "SYSMAN"."MGMT_TARGETS" set "CATEGORY_PROP_1" = ' ', "CATEGORY_PROP_2" = ' ', "CATEGORY_PROP_3" = ' ', "CATEGORY_PROP_4" = ' ', "CATEGORY_PROP_5" = ' ', "LAST_LOAD_TIME" = TO_DATE('01.05.05', 'DD.MM.RR'), "LAST_UPDATED_TIME" = TO_DATE('01.05.05', 'DD.MM.RR'), "MONITORING_MODE" = '0' where "CATEGORY_PROP_1" = ' ' and "CATEGORY_PROP_2" = ' ' and "CATEGORY_PROP_3" = ' ' and "CATEGORY_PROP_4" = ' ' and "CATEGORY_PROP_5" = ' ' and "LAST_LOAD_TIME" = TO_DATE('01.05.05', 'DD.MM.RR') and "LAST_UPDATED_TIME" = TO_DATE('01.05.05', 'DD.MM.RR') and "MONITORING_MODE" = '0' and ROWID = 'AAALraAADAAAE58AAD';
update "SYSMAN"."MGMT_TARGET_ROLLUP_TIMES" set "ROLLUP_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') where "ROLLUP_TIMESTAMP" = TO_DATE('30.04.05', 'DD.MM.RR') and ROWID = 'AAALryAADAAAE8tAAA';
update "WKSYS"."WK$INSTANCE" set "INST_LASTMOD" = TO_DATE('01.05.05', 'DD.MM.RR') where "INST_LASTMOD" = TO_DATE('01.05.05', 'DD.MM.RR') and ROWID = 'AAALfyAADAAAEV1AAA';
update "WKSYS"."WK$_JOB_INFO" set "JI_ERROR" = 'Job Launched at 01 May 2005 01:00:04' where "JI_ERROR" = 'Job Launched at 01 May 2005 00:00:01' and ROWID = 'AAALhKAADAAAENtAAA';
----------------------------
Unfortunately i don't have a clue where to go from here...
but maybe this can give you a hint about what's going on?
Regards
Horst
[Updated on: Mon, 02 May 2005 10:03] Report message to a moderator |
|
|
|
| Re: 10g Archive log files fill disk [message #118042 is a reply to message #118007] |
Mon, 02 May 2005 17:01 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
Looks like you have DML on tables in the following schemas:
SYSMAN - Oracle Enterprise Manager database administration tasks
DBSNMP - Management Agent component of Oracle Enterprise Manager to monitor and manage the database
WKSYS - Oracle Ultra Search
Not sure how you disable all of these. Shutting down dbconsole (emctl stop dbconsole) might help for SYSMAN and DBSNMP.
Best regards.
Frank
|
|
|
|
| Re: 10g Archive log files fill disk [message #118132 is a reply to message #118042] |
Tue, 03 May 2005 03:38 |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
Thanks Frank,
I'll try to kill dbconsole and see what happens...
will tell you about the results asap...
btw...is there a tool equivalent to svrmgr? / how can i best perform my administrative tasks on the database avoiding dbconsole?
Thanks again
Regards
Horst
|
|
|
|
| Re: 10g Archive log files fill disk [message #118136 is a reply to message #118132] |
Tue, 03 May 2005 03:47 |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Svrmgr was replaced with sqlplus. For details, read the chapter "Migrating from Server Manager to SQL*Plus" in the Oracle Database Upgrade Guide.
However, a better approach might be to just startup DBCONSOLE when you need it.
Best regards.
Frank
|
|
|
|
|
|
| Re: 10g Archive log files fill disk [message #118308 is a reply to message #118042] |
Wed, 04 May 2005 04:44 |
horstborscht
Messages: 13
Registered: April 2005
|
Junior Member |
|
|
Hi Frank,
I shut down dbconsole and logswitches have almost dropped down to Zero (just 1 new archive log file(10MB) in the previous 24h)...i think i can live with that now...
Thanks a lot again for your help...
Regards
Horst
|
|
|
|
Goto Forum:
Current Time: Thu Nov 21 14:42:58 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
