Maximum String Size for asm_diskstring Parameter
In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*) , comma (,) and single-quote ('). This is limited by v$asm_disk.path column's datatype length.
In an ASM instance we can have multiple asm_diskstring parameters. But the values from them are combined. And the combined string value is controlled by v$parameter.value column's datatype length that is 4000. Though it will not error, the value of the Nth asm_diskstring parameter, that is falling after 4000 characters will be ignored.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请