This forum is currently locked. You can't register or post questions at this time. (read more)

purpose to make DB hang

All posts relating to Oracle database administration.

Moderator: Tim...

baseballGuy
Member
Posts: 30
Joined: Thu Mar 22, 2012 7:08 pm

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?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: purpose to make DB hang

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

Hi.

- 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.

Cheers

Tim...
Tim...
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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron