Do you have current statistics? Does the network have a lot of traffic?
Are there any long running jobs on the server? How much memory do you
have? What is the speed of your processor? How many processors do you
have? You know, everything cannot run to completion in 60 seconds!






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Shalini Gupta
[mailto:oracledba-ezmlmshield-x12298688.[Email address protected]
Sent: Friday, August 31, 2007 7:11 AM
To: LazyDBA Discussion
Subject: Fw: Fast index creation


Both the things are here, but still it is taking to much time.

Thanks & Best Regards,
Shalini Gupta






"Mahapatra Himanshu \(*IC\) " <Himanshu.[Email address protected]
08/31/2007 04:29 PM

To
SHALINI.[Email address protected]
cc

Subject
RE: Fast index creation






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Create index <The script> nologging parallel(4);
Nologging is important , avoid redo
Parallel will create in parallel

Thanks & Regards,
Himanshu Mahapatra
Corporate Oracle DBA
Warner Bros Entertainment UK Ltd
98 Theobald's Road
London
WC1X 8WB
[Email address protected]
* : +44 (0)207 984 5734
Mobile- 0044 -(0)7885990475

-----Original Message-----
From: Shalini Gupta
[Email address protected]
Sent: 31 August 2007 11:47
To: LazyDBA Discussion
Subject: Fast index creation


Hi,

Any one can tell me how can i do fast index creation on big table. table

size is approx 10G.
Its very urgent.

Thanks & Best Regards,
Shalini Gupta
ITC Data Center, Bangalore



**********Please visit us at www.itcportal.com**********

************************************************************************
******
This Communication is for the exclusive use of the intended recipient
(s) and shall
not attach any liability on the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. If you are the addressee, the contents of this email are
intended for your
use only and it shall not be forwarded to any third party, without first
obtaining
written authorisation from the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. It may contain information which is confidential and legally
privileged
and the same shall not be used or dealt with by any third party in any
manner
whatsoever without the specific consent of ITC Ltd./its Subsidiaries/its
Group
Companies.
************************************************************************
********


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







**********Please visit us at www.itcportal.com**********

************************************************************************
******
This Communication is for the exclusive use of the intended recipient
(s) and shall
not attach any liability on the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. If you are the addressee, the contents of this email are
intended for your
use only and it shall not be forwarded to any third party, without first
obtaining
written authorisation from the originator or ITC Ltd./its
Subsidiaries/its Group
Companies. It may contain information which is confidential and legally
privileged
and the same shall not be used or dealt with by any third party in any
manner
whatsoever without the specific consent of ITC Ltd./its Subsidiaries/its
Group
Companies.
************************************************************************
********


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page