RE: How to speed up creating index problems

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Tue, 22 Nov 2005 15:10:31 -0800
Message-ID: <B9782AD410794F4687F2B5B4A6FF3501021D51FB@ex1.ms.polyserve.com>

questions:

Is that a 1TB table, or a table with 1TB space allocated to it? Scanning > 400MB/s and creating an index would require a bare minimum of 32 very hot CPUs. You must have a pretty nice system there.
Is PCTFREE/USED set up such that this 1TB table has 1 row per block :-0
Is the 15GB table index create statement a 42-way composite ?

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu

	Sent: Tuesday, November 22, 2005 2:58 PM
	To: bunjibry_at_gmail.com; Oracle-L
	Subject: How to speed up creating index problems
	
	
	40+ minutes to create an index on a 1 TB table - that is fast
for us.
	It took me the same time to create an index on a 15 GB table. 
	How come?  "alter session set sort_area_size"? Parallel?

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bryan Wells

		Sent: Tuesday, November 22, 2005 12:49 PM
		To: Oracle-L
		Subject: Creating index problems
		
		
		Hi... we are having issues trying to create indexes from

a remote location. we have access to the console and are running the create index on the server, but it takes 40+ minutes to create. BTW... this table is 1Tb. however, when performing the same operation at another location, same configuration as before, the index only takes 10min. what am i missing? both of these servers are SAN attached. the indexes are being created on the SAN.

		Bryan S Wells (Perpetually Stumped)
		Database Administrator 
		bunjibry_at_gmail.com
		 

		For technical support please email
tech_support_at_dp7uptx.com or you can
		call (972)721-8257. 
		This email has been scanned for all viruses by the

MessageLabs Email Security System.

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 22 2005 - 17:12:49 CST