Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1 - This article provides an overview of the main Automatic Storage Manager (ASM) enhancements in Oracle Database 11g Release 1.



Lesio said...

Perfect :)

Lisa Wilcox said...

Other sources say that REPAIR is thte default for the ALTER DISKGROUP.........CHECK command. Please check it.

Tim... said...

Hi.

Quotes:

Oracle 11.1 docs: "The default is NOREPAIR"
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_1006.htm#i2168804

Oracle 11.2 docs: "The default is NOREPAIR"
http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_1007.htm#i2168804

Both sets of docs say it is the default.

Cheers

Tim...

Lisa Wilcox said...

Thanks.
I think it's wrong in Sam Alapati's book.

Tim... said...

Hi.

Looking through the docs, it appears that the REPAIR option was the default in 10.1 and 10.2, but in 11.x it was switched to NOREPAIR.

I guess he's not realized the switch has been made. Changes to default settings are really to miss. :)

Cheers

Tim...

Jamsher said...

As per Oracle doc
after 20,000 extent its 4*AU and not 8*AU

1-20,000 Equal to AU
20,000-39,999 Equal to 4*AU
above 40,000 16*AU

Please correct me if I am wrong.

Thanks
Jamsher

Tim... said...

Hi.

The article was written against 11.1, where it was 1,8,64. In 11.2 that was changed to 1,4,16. I've made a note of this in the article.

Thanks for the heads-up. :)

Cheers

Tim...

Bertrand Drouvot said...

Hello Tim,

Regarding the preferred read feature: Be careful with Flex ASM 12.1 and extended cluster.

See:
https://bdrouvot.wordpress.com/2013/07/02/flex-asm-12c-12-1-and-extended-rac-be-careful-to-unpreferred-read/

Thx
Bertrand

jothikrishnan said...

its good . . . .
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired