England of course - it's cold, we've had a year's worth of rain in a few days and we're sinking.
-----Original Message-----
From: Joel [mailto:mssqldba-ezmlmshield-x32736831.[Email address protected]
Sent: 28 June 2007 16:10
To: LazyDBA Discussion
Subject: RE: please help
Cold in June? Where are you?
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Louis Botes [mailto:mssqldba-ezmlmshield-x69761799.[Email address protected]
Sent: Thursday, June 28, 2007 11:08 AM
To: LazyDBA Discussion
Subject: RE: please help
The good news is that work for Thursday is officially done, I will be outta here soon enough to get to my Le Red Wine - It is damned cold...
I archived 20GB's worth of databases today and Upgraded a CRM system (was only 12 patches behind current) so tomorrow I am really not doing anything whatsoever.
-----Original Message-----
From: Vanessa van Gelder [mailto:mssqldba-ezmlmshield-x57180864.[Email address protected]
Sent: Thursday, June 28, 2007 4:59 PM
To: LazyDBA Discussion
Subject: RE: please help
Le Whiskey/whisky/bourbon is calling :)
-----Original Message-----
From: Joel [mailto:mssqldba-ezmlmshield-x35940110.[Email address protected] Sent: 28 June 2007 04:57
To: LazyDBA Discussion
Subject: RE: please help
Yes,
He starts Friday every Thursday.
(and sometimes doesn't wait that long).
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Tim Widdup [mailto:mssqldba-ezmlmshield-x64681575.[Email address protected]
Sent: Thursday, June 28, 2007 10:52 AM
To: LazyDBA Discussion
Subject: RE: please help
By my reckoning it's Thursday...or have I got stuck in a space/time
continuum again!..doh!
-----Original Message-----
From: Edwards Ed [mailto:mssqldba-ezmlmshield-x87647329.[Email address
protected]
Sent: 28 June 2007 14:59
To: LazyDBA Discussion
Subject: RE: please help
Hey Joel,
What's the matter with you? Git outta here! No Oracle questions! Hehe.
It's Fridayyyyyyyyy! Partyyyyyyyyyyyy! Hehe.
Have a great Day!
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: Hannes Coetzee [mailto:mssqldba-ezmlmshield-x64382596.[Email address
protected]
Sent: Thursday, June 28, 2007 9:53 AM
To: LazyDBA Discussion
Subject: RE: please help
Wow, good to hear from somebody who searches for help on Oracle on Microsoft
forum!!!!!!
-----Original Message-----
From: DEBARBAT David [mailto:mssqldba-ezmlmshield-x64498227.[Email address
protected]
Sent: 28 June 2007 03:45 PM
To: LazyDBA Discussion
Subject: RE: please help
Thanks Joel
It's not on Windows......beurkkkk.....Solaris is better....
I'm going to increase the buffer first...and import data first following
indexes....
To avoid searches on net, do you hvae the syntax on mind ?
Thanks
David
-----Message d'origine-----
De : Joel [mailto:mssqldba-ezmlmshield-x26996910.[Email address protected]
Envoyé : jeudi 28 juin 2007 14:59 À : LazyDBA Discussion Objet : RE: please
help
Hehe... besides not knowing what 4.5 Go is.... your in a Microsoft
forum. Hehe.
Commit is only good alongside the buffer parameter and will commit when the
buffer gets full instead of after each table which is the default.
You can use a big buffer to speed things up, but are probably more likely to
be successful importing the data first, and then the indexes.
The rest is more complicated, like parallizing imports by breaking up the
users or tables... This success would depend on your IO configuration and
controllers -- separate IO processes.
Try the data, then index thing first, with a big buffer... start with 10Mbs
or 20Mbs.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: DEBARBAT David
[mailto:mssqldba-ezmlmshield-x50081030.[Email address protected]
Sent: Thursday, June 28, 2007 7:40 AM
To: LazyDBA Discussion
Subject: RE: please help
Hi,
I have an import which take about 5 hours for a database oracle 9i of
4.5 Go
imp admbackup/oracle file=$DUMP_FILE buffer=300000 ignore=Y commit=y
fromuser=blablabla touser=blablabla
Does someone know if I can make some optimizations on this import ? Does
paremeter commit=y can reduce the speed.
Thanks.
David
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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 message is subject to the disclaimer found at
http://www.macsteel.co.za/emaildisclaimer.jsp
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
© Message Copyright EMX Company Limited 2007. All rights reserved.
Full email disclaimer can be viewed at:
http://www.emxco.com/disclaimer.html
EMX Company Limited.
Tel: +44 1279 858300, Fax: +44 1279 858301, Client Services Tel: +44 1279
858333, Website: www.emxco.com
Calls, e-mails and written correspondence may be monitored to assist with
training, policy enforcement and resolution of disputes.
____________________________________________________________________
This email has been scanned for all viruses by MessageLabs.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential or proprietary information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents and notify the sender immediately of the error.
Internet communications are not necessarily secure, and may be monitored, intercepted or changed after they are sent. DXS and its subsidiaries do not accept liability for any loss you may suffer as a result of interception, or any liability for such changes.
---------------------------------------------------------------------
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
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/875 - Release Date: 6/27/2007 9:08 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/875 - Release Date: 6/27/2007 9:08 PM
------------------------------------------------------------------------------------------
This e-mail was checked by the Verizon Business Internet Mail Content Filtering Service.
The I M C F provides you with upstream anti-spam and content filtering and multi layered virus protection.
For more information please contact your Verizon Business account manager or the sender of this e-mail!!
------------------------------------------------------------------------------------------
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
© Message Copyright EMX Company Limited 2007. All rights reserved.
Full email disclaimer can be viewed at:
http://www.emxco.com/disclaimer.html
EMX Company Limited.
Tel: +44 1279 858300, Fax: +44 1279 858301, Client Services Tel: +44 1279 858333, Website: www.emxco.com
Calls, e-mails and written correspondence may be monitored to assist with training, policy enforcement and resolution of disputes.
____________________________________________________________________
This email has been scanned for all viruses by MessageLabs.
MS Sql Server LazyDBA home page