Deep Roy,
no hijacklin' a thread start your own, we're learning here!! :)
Hasta La pasta!
-----Original Message-----
From: deepchandra
[mailto:oracledba-ezmlmshield-x76221715.[Email address protected]
Sent: 31 August 2007 13:27
To: LazyDBA Discussion
Subject: RE: Fast index creation
Hi,
how to enable diagnostics at front end and at database level?
Thanks in advance
Deep Roy
-----Original Message-----
From: Rahul Dandekar
[mailto:oracledba-ezmlmshield-x57231098.[Email address protected]
Sent: Friday, August 31, 2007 8:28 PM
To: LazyDBA Discussion
Subject: RE: Fast index creation
What do you see in v$session_wait ? Anything unusal?
Rahul Dandekar
-----Original Message-----
From: Shalini Gupta
[mailto:oracledba-ezmlmshield-x12298688.[Email address protected]
Sent: Friday, August 31, 2007 4:41 PM
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
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
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
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
www.wipro.com
---------------------------------------------------------------------
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
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com
Oracle LazyDBA home page