purpose to make DB hang

All posts relating to Oracle database administration.

Moderator: Tim...

purpose to make DB hang

Postby baseballGuy » Tue Dec 18, 2012 4:49 pm

Hi Tim,

I need to write some use cases and one of them is how to resolve the situation when DB is hung. any suggestions of how to make DB hung?
Posts: 30
Joined: Thu Mar 22, 2012 7:08 pm

Re: purpose to make DB hang

Postby Tim... » Tue Dec 18, 2012 8:32 pm


- Turn the database into archivelog mode.
- Set the archivelog destination to a file system with very little free space, but not an important OS one!
- Wait for the archivelogs to fill the remaining space.
- Database will hang.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Site Admin
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests