-
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!
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle 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
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
here is an output from v$enqueue_lock:
Code:
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
Last edited by simply_dba; 05-06-2005 at 05:43 AM.
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
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
-
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
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|