How to check if tablespaces are autoextend - Ex Libris Knowledge Center

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

儒雅的企鹅 · 朱主爱变身“机器人”和“狙击手”，舞曲《SP ...· 4 周前 ·

稳重的铁链 · Exploitation· 1 月前 ·

稳重的企鹅 · Your request has been ...· 2 月前 ·

踢足球的镜子 · 合肥未来十年看滨湖？万字长文深度解析滨湖区的 ...· 2 月前 ·

闯红灯的雪糕 · HTML Video· 3 月前 ·

Question

How to check if Oracle tablespaces are in autoextend mode and what is the defined maximum size (in Oracle 11/11r2 the maximum is 32Gb)?

Answer

The following SQL from the aleph user prompt will show whether each Oracle datafile is autoextensible. (Autoextensibility is defined at the datafile level.):

> s+ aleph_admin select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like 'TS__';

Check the values in AUTOEXTENSIBLE column; if it’s NO this feature is not enabled on the file in column FILE_NAME.

Article last edited: 08-Oct-2013

推荐文章

儒雅的企鹅 · 朱主爱变身“机器人”和“狙击手”，舞曲《SPEEDING LOVE》上线_腾讯新闻

4 周前

稳重的铁链 · Exploitation

1 月前

稳重的企鹅 · Your request has been blocked. This could be due to several reasons.

2 月前

踢足球的镜子 · 合肥未来十年看滨湖？万字长文深度解析滨湖区的现状与未来（上）|巢湖|cbd|云谷_网易订阅

2 月前

闯红灯的雪糕 · HTML Video

3 月前