Re: Checkpoint not complete error
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Apr 2009 08:12:31 -0700 (PDT)
It is better to start with understanding which job is causing high redo
generation and optimize that job before making changes to the redo log file
size, checkpoint related init parameters, etc.
select parsing_user_id, command_type, sum(executions), sum(rows_processed) from
V$sql
where command_type not in (0, 3) group by parsing_user_id, command_type order
by 4;
Above query can give you high level view about amount and frequency of changes
happening on your system.
things to check:
1) Check if you have any LOBS and DML's on LOBS, if their data is not needed on
DR standby, make them nocache and nologging
2) Check if you have any batch jobs doing mass inserts or deletes, if so, look
into the possibility of dropping index, DML, and creating index.
3) If you are creating any temporary or staging tables, check if they can be
made nologging or global temporary tables.
4) Convert statements like, delete * from emp, to truncate table emp;
......etc..
You can also look into top waitevents, top sql, etc from awr report and go from
there.
Thanks,
Sai
http://sai-oracle.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
