This discussion is archived
1 2 3 Previous Next 30 Replies Latest reply: Aug 15, 2013 3:30 AM by yxes2013 RSS

App Hangs in 3 consecutive days

yxes2013 Newbie
Currently Being Moderated

Hi all,

 

11.2.0.1

Aix 6.1

 

Our database & app hangs for the first time, 3 consecutive days (Aug 11,12,13)  during run of batch jobs at 12AM.

The batch operator said the batch job is deleting a table with only less than 1000 rows but was not able to lock the table as there lots of updates queues from lots of client app.

 

I check the alert log for the said time period and this is the output. I saw similar occurences at 1AM

 

Tue Aug 13 01:20:45 2013
Clearing standby activation ID 2855092487 (0xaa2d4107)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 10 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl7.f' SIZE 262144000;
Tue Aug 13 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Aug 13 04:36:07 2013
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [9.53%] pct of memory swapped out [23.33%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Tue Aug 13 05:07:14 2013
Thread 1 cannot allocate new log, sequence 49033
Private strand flush not complete


AlertSunday Aug 11

https://app.box.com/s/6ut7uk0o5y6tg2sjfzvn

AlertMonday Aug 12

https://app.box.com/s/gafa2d1ngn7hpen6tfky

AlertTuesday Aug 13
https://app.box.com/s/o5v5gtul1mr3yra6vbgj


Do you have any idea what causes tha hang? Its weird because these did not happened before.


Please help...


Thanks a lot,


zxy

1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points