Re: Partitioning

  • From: SJHussain@xxxxxxxxxxxxxxx
  • To: dofreeman@xxxxxxxxxxx
  • Date: Tue, 7 Sep 2004 16:48:02 +0300




Since you have RAID technology, I believe, no need to worry about where to
keep your partitions, either in the same tablespace or in the different
tablespaces.

Best Regards,

Syed Jaffar Hussain
OCP, DBA Consultant



                                                                           
             "Freeman, Donald"                                             
             <dofreeman@state.                                             
             pa.us>                                                     To 
             Sent by:                  "Oracle-L (E-mail)"                 
             oracle-l-bounce@f         <oracle-l@xxxxxxxxxxxxx>            
             reelists.org                                               cc 
                                                                           
                                                                   Subject 
             09/07/2004 04:44          Partitioning                        
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             dofreeman@xxxxxxx                                             
                   a.us                                                    
                                                                           
                                                                           




The system is Oracle 9.2.0.5 on Windows 2000.  We want to partition some =
of our tables for performance.  The data is loaded on 7 disks striped =
and mirrored.  My question is can I just create partitions in the =
original tablespace and benefit from partitioning or do the partitions =
have to be in separate tablespaces?   Is the parallelism enabled at the =
logical level through multiple partitions in different tablespaces or =
just physically through striping?

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology


--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/


Visit us on www.alfransi.com.sa
======  Banque Saudi Fransi - Privacy Notice  ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited.  If you have received this in error,  please
contact the sender and delete the material from  your computer.  Any
opinions and other information  contained in this message that do not
relate to the official  business  of  Banque  Saudi  Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
======  Banque Saudi Fransi - Privacy Notice  ======

--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - //www.freelists.org/archives/oracle-l/

Other related posts: