Database DataWarehousing (MOSC)

MOSC Banner

alert log shows log switch every 2 minutes, plus with ORA-00308/ORA-2703 looking for old logs in ale

edited Jun 20, 2018 11:03AM in Database DataWarehousing (MOSC) 9 commentsAnswered ✓
Our primary production DW environment has been slow for over a week now. Here are some of my findings:
I noticed in alertlog , there is no entry such as log switches: Beginning log switch checkpoint up to .....
and every other minutes seems archivelogs processed such as:

Mon Mar 25 19:56:52 2013
Archived Log entry 1157174 added for thread 1 sequence 602553 ID 0xffffffff8e195ecf dest 1:
Mon Mar 25 19:56:57 2013
Archived Log entry 1157175 added for thread 1 sequence 602552 ID 0xffffffff8e195ecf dest 1:
Mon Mar 25 19:57:19 2013
Hex dump of (file 344, block 49910) in trace file /admin/PRD/diag/diag/rdbms/prd/PRD/trace/
PRD_ora_611070.trc
Tue Apr 16 22:33:28 2013
Archived Log entry 1191514 added for thread 1 sequence 619723 ID 0xffffffff8e195ecf dest 1:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center