RE: How to speed up creating index problems
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 15:10:31 -0800
questions:
1. 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.
2. Is PCTFREE/USED set up such that this 1TB table has 1 row per block
:-0
3. Is the 15GB table index create statement a 42-way composite ?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Tuesday, November 22, 2005 2:58 PM
To: bunjibry@xxxxxxxxx; 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxx
For technical support please email
tech_support@xxxxxxxxxxx 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@xxxxxxxxxxxx
Other related posts:
