When you issue "ALTER TABLESPACE xxx READ ONLY",what will oracle do?
- acquire AT lock exclusive
- set datafile not modifyable
- Wait on any active TX to commit
(If a TX touches the tablespace at this time it gets ORA-372)
- Finish off updating TS to read only
- Release AT lock
AT lock是tablespace的enqueue,目的是序列化對錶空間的併發操作
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/85922/viewspace-899155/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- read only tablespace backup restoreREST
- QUESTION :What kind of shared storage do you use for Oracle RAC?Oracle
- What Happens When You Open a Database (297)APPDatabase
- oracle實驗記錄 (恢復read only tablespace(1))Oracle
- oracle實驗記錄 (恢復read only tablespace(2))Oracle
- 【HPUX】What to do when mount does not work on HP-UX?UX
- 關於tablespace在read only狀態下的DML ,DDL操作--Read-Only Tablespaces
- MySQL 報錯'Variable 'XXX' is a read only variable'MySql
- 重建控制檔案與 datafile offline,tablespace read only
- oracle 表空間和表 read only遷移後不再read onlyOracle
- You've got to find what you loveGo
- How do you pronounce IT?
- When you're goneGo
- What does "xargs grep" do?
- Oracle Isolation Levels : Read-only (317)Oracle
- Login Oracle Instance Even When sysdba Cannot Do SoOracle
- robbin的自白:You've got to find what you loveGo
- Innodb Read Only Mode
- TLS Poison - When TLS Hack youTLS
- ALTER DATABASE 與 ALTER TABLESPACE OFFLINE的區別Database
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- 事件驅動,Do you know?事件
- What you should know about JavaJava
- MySQL 中出現報錯提示: ‘Variable ‘XXX‘ is a read only variable‘的解決方法MySql
- For example, when you want to get the ball to the ground
- alter database datafile offline and alter database tablespace ...offlineDatabase
- Read-Only Tables in Oracle Database 11g Release 1OracleDatabase
- What You See Is What You Get 所見即所得 20240525~0526 心得記錄
- What is the Impact on the Database When Modifying the OS DateDatabase
- What are general rules when deciding on index?Index
- How do you think the GHD hair straightenersAI
- How do you find that an operation mode switch occurred?
- 事務的read only mode
- Oracle 11g 新特性:只讀表(Read-only)Oracle
- 【比較】Oracle不同版本中關於ALTER TABLESPACE的功能演進Oracle
- rhel5 oracle10.2.0.4_alter tablespace_擴充套件autoextendOracle套件
- do not have permission to view information for any of the hosts you requestedViewORM
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database