read only taking long
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: read only taking long

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Talking

    Hi guys,
    I have 10 partitions in 10 different tablespaces. Only the current partition is being loaded.
    I tried to put the tablespace containing the oldest partition into read only mode but it's taking a long time(45 minutes). So I cancelled the operations. I can swear that no object in that particular tablespace is being loader,deleted,updated,etc, so I don't understand why changing the tablespace to read only is taking a long time.

    Any idea what's happening?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    expected behaviour.
    read only will take place only if there is no transactions in your database

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by pando
    expected behaviour.
    read only will take place only if there is no transactions in your database
    Pando, what do you mean by that? There is no such requirenment! Further more, there can even be active transactions on the segments of that particular tablespace when you put it in read only mode. The active transactions will be able to complete, but any new transactions on that tablespace will be prevented.

    The only restriction are that there must be no active rollback segment in that tablespace and that tablespace is not in backup mode.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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