cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

parameters to improve windchill database import

ptc-1016899
1-Newbie
1-Newbie
‎Nov 30, 2009 04:45 AM
‎Nov 30, 2009 04:45 AM

parameters to improve windchill database import

I am trying to import a large PDMLink databse dump of 80GB size into oracle 9i. It is taking 52 to 55 hours. Are there any paramaters/ setting which can improve the import time.
Labels:
0 Kudos
Notify Moderator
1 REPLY 1
DmitryTsarev
17-Peridot
17-Peridot
(To:ptc-1016899)
‎Dec 04, 2009 02:36 PM
‎Dec 04, 2009 02:36 PM

I'd first make sure that the space for tablespaces is preallocated so no "autoextend" is happening when importing. Especially considering that the last time I was looking into Oracle, the increment value for autoextend set during Windchill installation, was set to quite low value. I'd also consider moving the BLOB data out of the database to vaults.
0 Kudos
Notify Moderator
Announcements


Contact Community Management
Top Tags