You are here: > ESRI Forums > arcsde (9.1 and older) users online discussion forum > Thread Replies

ArcSDE (9.1 and older) Users Online Discussion Forum

ArcSDE: Oracle forum

Moving indexes to another tablespace   GIS User Apr 26, 2007
Re: Moving indexes to another tablespace   Vince Angelo Apr 27, 2007
Re: Moving indexes to another tablespace   GIS User May 02, 2007
Re: Moving indexes to another tablespace   Servizio Pianificazione generale e SIT Settore Urbanistica-SIT-Progetti Special Jul 16, 2008
Re: Moving indexes to another tablespace   Vince Angelo Jul 16, 2008
Re: Moving indexes to another tablespace   Servizio Pianificazione generale e SIT Settore Urbanistica-SIT-Progetti Special Jul 16, 2008
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Moving indexes to another tablespace 
Author GIS User 
Date Apr 26, 2007 
Message Hi,

I want to move the current indexes to another tablespace to improve the performance of my oracle database. Currently both the data and indexes are in the same tablespace. Is it possible to move the spatial indexes and other indexes created on the current datasets? Any information on this? Please let me know.

Database: Oracle 10g R2
SDE: ArcSDE 9.1 for Oracle 10g

Thanks and Regards
Venkat
 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Moving indexes to another tablespace 
Author Vince Angelo 
Date Apr 27, 2007 
Message
While *some* indexes can be moved just by changing the keyword
contents, placing the layer in LOAD_ONLY I/O mode and back
into NORMAL I/O mode, others could only be changed by using
database directives (which is unsupported). The best way to
do this is to drop and reload the table using an appropriate
DBTUNE keyword.

You may also be dealing with a database falacy. Moving indexes
to a different tablespace only generally helps if the new tablespace
is on a different disk spindle. In the common case of one large
RAID disk you might not see any performance benefit.

- V 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Moving indexes to another tablespace 
Author GIS User 
Date May 02, 2007 
Message Hi Vince Angelo,

Thanks for your prompt response. Actually all the tablespaces in the database are in the same disk and by moving the indexes, i would like to see any performance improvement. As per your message, it states that it won't improve the performance if the large file exists on the same disk. What other alternatives best suitable in this case to improve the performace ?

Regards
Venkat 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Moving indexes to another tablespace 
Author Servizio Pianificazione generale e SIT Settore Urbanistica-SIT-Progetti Special 
Date Jul 16, 2008 
Message Hi!
we have only 1 big tablesapce (5 Gb) for all data on oracle/SDE for all connection. DBMS have only 1 big disk.
Is it an intellegint idea to do different tablesapce for every owner? The sde/oracle performance now are very swloly...

Someone have a better idea?
Sde 9.2
Oracle 10g

Bye and Thanks!
 
  Giorgio Ovani
ArcSDE - Desktop User
--------------------------------
Comune di Riccione - Italy 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Moving indexes to another tablespace 
Author Vince Angelo 
Date Jul 16, 2008 
Message No, creating tablespaces for individual users is not likely to
significantly improve performance. 5Gb is a *tiny* spatial
database. Any performance issues you have are more likely
related to the hardware and database configurations. You
should review the hardware (RAM, disk speed, fragmentation)
and software (Oracle cache and other memory parameters)
before moving data about.

- V 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Moving indexes to another tablespace 
Author Servizio Pianificazione generale e SIT Settore Urbanistica-SIT-Progetti Special 
Date Jul 16, 2008 
Message Thank you.
But is a good idea move data that are "read only" in a tablespace and "editing" data in another tablespace?Is a better solution if i manage this form user's grant?

Thanks 
  Giorgio Ovani
ArcSDE - Desktop User
--------------------------------
Comune di Riccione - Italy