Home » RDBMS Server » Server Administration » ASM File size (11g R2)
ASM File size [message #486654] Sat, 18 December 2010 00:52 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi, we are new to ASM storage.
In 10g and above,with normal fize system ,we used to have multiple files for each tablespaces, with same size.
eg :Tablespace USERS
Users1.dbf 4gb
Users2.dbf 4gb
Users3.dbf 4gb etc...

What is the best option,with an ASM storage.Create a sigle file of 12GB or use multiple files ? Thanks
Re: ASM File size [message #486655 is a reply to message #486654] Sat, 18 December 2010 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use single file and let ASM manages the "physical" layer.

Regards
Michel
Re: ASM File size [message #486657 is a reply to message #486654] Sat, 18 December 2010 01:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>we used to have multiple files for each tablespaces, with same size
What was the purpose before?
Why were you using multiple file for each tablespace instead of one datafile?
Re: ASM File size [message #486670 is a reply to message #486654] Sat, 18 December 2010 03:24 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks Mike.

@MR:
To distribute I/O to multilpe filesystem.
And better rman backup perfomance(i am still not sure how).

Would rman backup perfomance gona affect having a single large file ?
Re: ASM File size [message #486671 is a reply to message #486670] Sat, 18 December 2010 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Would rman backup perfomance gona affect having a single large file ?

Not with ASM, a file does not mean a single disk (unless you only have one physical disk).

Regards
Michel

[Updated on: Sat, 18 December 2010 03:35]

Report message to a moderator

Re: ASM File size [message #486672 is a reply to message #486671] Sat, 18 December 2010 03:41 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i just read about "SECTION SIZE" in rman , to enable "Multi-section backups" .I gues its a new 11g feature.
I need to do r&d wit this. I will update you if any finding.
Please share your exp if you are already using it. THANKS
Previous Topic: extra space in file_location for alter command
Next Topic: How to get the tables in Oracle 10g
Goto Forum:
  


Current Time: Fri Nov 29 08:43:03 CST 2024