OraFAQ Forum: Server Administration » enq: TT - contention when trying to offline a temporary tablespace

Home » RDBMS Server » Server Administration » enq: TT - contention when trying to offline a temporary tablespace (10.2.0.4 Sun Solaris ( RAC ))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

enq: TT - contention when trying to offline a temporary tablespace [message #379662]

Wed, 07 January 2009 09:33

Orna
Messages: 62
Registered: November 2008

Member

Hi

I issued a 'alter tablespace temp offline' command yesterday on one of my 3 node RAC 10.1.0.4 database.
It is hanging since with 'enq: TT - contention'.

Any ideas ?
I failed to find any Metalink/other references that are helpful

Thanks
Orna

Report message to a moderator

Re: enq: TT - contention when trying to offline a temporary tablespace [message #379666 is a reply to message #379662]

Wed, 07 January 2009 09:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Been accounted as bug.

Report message to a moderator

Re: enq: TT - contention when trying to offline a temporary tablespace [message #379667 is a reply to message #379662]

Wed, 07 January 2009 09:52

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You should:

1. Gather evidence to log a call with Oracle Support. This will typically be 3 x systemstate dumps taken a couple of minutes apart.

2. Issue a shutdown abort and restart.

Please keep us in the loop.

Best of luck!

Frank

Report message to a moderator

Re: enq: TT - contention when trying to offline a temporary tablespace [message #379674 is a reply to message #379666]

Wed, 07 January 2009 10:29

Orna
Messages: 62
Registered: November 2008

Member

HI

Do you happen to have the bug number or metalink doc # ?
I cannot find it

Thanks!
orna

Report message to a moderator

Re: enq: TT - contention when trying to offline a temporary tablespace [message #379684 is a reply to message #379666]

Wed, 07 January 2009 11:35

Orna
Messages: 62
Registered: November 2008

Member

I believe its Bug 3833893

Report message to a moderator

Previous Topic:	Possible issues when migrating data from WE8ISO8859P1 to UTF8 (merged)
Next Topic:	IO error while trying to put tablespace in read only mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 02:13:33 CST 2025