Enqueue wait - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Enqueue wait

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  2. #12
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  3. #13
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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

  4. #14
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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

  5. #15
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    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

  6. #16
    Join Date
    Jan 2001
    Posts
    2,828
    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

  7. #17
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  8. #18
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  9. #19
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  



Click Here to Expand Forum to Full Width