Re: Log in Storm Caused Database Crash

  • From: Upendra nerilla <nupendra@xxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>, "raviteja.bellamkonda7@xxxxxxxxx" <raviteja.bellamkonda7@xxxxxxxxx>
  • Date: Mon, 2 Oct 2017 02:39:54 +0000

Is this an internet facing application or internal? If it is external facing 
application, investigate if there was DoS type attack or a spike in the user 
sessions due to any issues with application servers?


If you need to isolate where the connections originated from, you could look 
into DBA_Hist views.


You may want to start with this one.. 
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3125.htm#REFRN23400


DBA_HIST_ACTIVE_SESS_HISTORY - Oracle Help 
Center<https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3125.htm#REFRN23400>
docs.oracle.com
DBA_HIST_ACTIVE_SESS_HISTORY. DBA_HIST_ACTIVE_SESS_HISTORY displays the history 
of the contents of the in-memory active session history of recent system 
activity.


Also look into any application server logs and see if there were any issues 
with the application server itself..


-Upendra


________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf 
of Ravi Teja Bellamkonda <raviteja.bellamkonda7@xxxxxxxxx>
Sent: Sunday, October 1, 2017 9:25 PM
To: oracle-l
Subject: RE: Log in Storm Caused Database Crash

Hi List,

We ran into an issue recently and wanted some help in figuring out this issue.

Database was not responding and one thing from AWR observed before fail over 
was the login storm.

[Inline image 1]


Logons cumulative also increased during this interval.

[Inline image 2]

Logons cumulative were 1237 in total in the before AWR report. Any suggestions 
are highly appreciated.
--
Thanks & Regards,
Ravi Teja

PNG image

PNG image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2017