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!
Printable View
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!
then that transaction would be belonging to some other session.. join with v$session to see the details.Quote:
Originally posted by simply_dba
Heck no they are going up:confused:
Abhay.
There's only one row in v$transactionQuote:
Originally posted by abhaysk
then that transaction would be belonging to some other session.. join with v$session to see the details.
Abhay.
No hard feelings !!Quote:
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!
You certainly made your point.
I was just being the nagging type:D
here is an output from v$enqueue_lock:
sid 5 being the smon and 19 being the current delete sqlCode: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
I thought bouncing the Db would kick in fast start parallel rollback.Quote:
Originally posted by abhaysk
Wont help..
Abhay.
or am i missing something ?
regards
Hrishy
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 :p
Yes but which session that transaction belongs to.. did u check?Quote:
Originally posted by simply_dba
There's only one row in v$transaction
are you sure that its the dead sessions transaction?
Abhay.
That would any how have been invoked by smon process if that appropriate parameter is defined.. so why shutdown?Quote:
Originally posted by hrishy
I thought bouncing the Db would kick in fast start parallel rollback.
or am i missing something ?
regards
Hrishy
Abhay.