Enqueue wait

[DaPi]

OOPS! Sorry if that was taken as being rude - I did want to make the point forcefully, as this is not the first time I've seen this sort of thing (e.g. not bothering to backup RBS TS). I do have your best interests at heart!

[abhaysk]

Originally posted by simply_dba
Heck no they are going up

then that transaction would be belonging to some other session.. join with v$session to see the details.


Abhay.

[simply_dba]

Originally posted by abhaysk
then that transaction would be belonging to some other session.. join with v$session to see the details.


Abhay.

There's only one row in v$transaction

[simply_dba]

Originally posted by DaPi
OOPS! Sorry if that was taken as being rude - I did want to make the point forcefully, as this is not the first time I've seen this sort of thing (e.g. not bothering to backup RBS TS). I do have your best interests at heart!

No hard feelings !!
You certainly made your point.
I was just being the nagging type

[simply_dba]

here is an output from v$enqueue_lock:

ADDR	                     KADDR     SID	TYPE	ID1	ID2	 LMODE	REQUEST	CTIME	BLOCK

00000003B5956368	00000003B5956388	5	TX	262290	3268756	6	0	36	1
00000003B59562E0	00000003B5956300	5	TS	3	1	      3	0	2047129	0
00000003B59560C0	00000003B59560E0	5	PS	1	0	      4	0	81164	  0
00000003B595B588	00000003B595B5A8	19	TX	262290	3268756	0	4	36	0

sid 5 being the smon and 19 being the current delete sql

[hrishy]

Originally posted by abhaysk
Wont help..

Abhay.

I thought bouncing the Db would kick in fast start parallel rollback.
or am i missing something ?

regards
Hrishy

[OracleDoc]

It's one of those "pay me now or pay me later" with SMON.
Either way SMON is going to do whatever he needs to do whether you let him clean up before shutdown or on startup.

Been there done that before and it sucks lol

[abhaysk]

Originally posted by simply_dba
There's only one row in v$transaction

Yes but which session that transaction belongs to.. did u check?

are you sure that its the dead sessions transaction?


Abhay.

[abhaysk]

Originally posted by hrishy
I thought bouncing the Db would kick in fast start parallel rollback.
or am i missing something ?

regards
Hrishy

That would any how have been invoked by smon process if that appropriate parameter is defined.. so why shutdown?

Abhay.