Exforsys

Online Training

Kindly provide the Reason

This is a discussion on Kindly provide the Reason within the Oracle Database forums, part of the Database category; Is there any reason or advantage of spreading multiple tablespaces across disks. If so can anyone mention the reasons....


Go Back   Exforsys > Database > Oracle Database

Kindly provide the Reason Kindly provide the Reason

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 12-14-2006, 04:45 AM
Member
  
Join Date: Apr 2006
Posts: 98
Angela is on a distinguished road
Kindly provide the Reason
Is there any reason or advantage of spreading multiple tablespaces across disks. If so can anyone mention the reasons.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-27-2006, 07:30 AM
Junior Member
  
Join Date: Dec 2006
Posts: 8
oracleobsessed is on a distinguished road
tablespaces across multiple disk....is that what u meant?

oracle recommends spreading tablespaces across multiple drives so as to balance i/o load as well as to safegaurd from disk corruption issues.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 12-28-2006, 02:48 PM
Senior Member
  
Join Date: Apr 2006
Posts: 141
Adrian is on a distinguished road
The main benefit of spreading multiple tablespaces across disks is to Minimize disk I/O contention.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Reply

« How to Uninstall | ORACLE initialization or shutdown in progress »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Kindly Provide Information about Next Release sammy SAP R/3 0 12-08-2006 01:45 AM
Good Net-Keeping Seal of Approval 2.0 (GNKSA 2.0) for Usenet Software Jeroen Scheerder Tech FAQ 0 06-05-2004 06:00 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit Tech FAQ 0 06-01-2004 06:00 AM
Good Net-Keeping Seal of Approval 2.0 (GNKSA 2.0) for Usenet Software Jeroen Scheerder Tech FAQ 0 05-01-2004 06:00 PM
Solaris x86 FAQ 2/2 Dan Anderson Tech FAQ 0 04-27-2004 07:24 PM


All times are GMT -4. The time now is 05:12 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.