-
And I really tried not to show my bias.
I think Windows NT is great for a Client OS and as a db server for small workgroup apps. In fact, I recommend NT for small shops all the time. When it comes to 1000 users and 2TB of data, no, that belongs on a unix box.
Jeff Hunter
-
Last time the import failed due to temp becoming full. I incresed the temp to 1.5gb and sga to 500mg(db buff alone is 250mb) and the table size is 3gb(30million rows)..
export is going on since 1.5 hours or so..
As well, on the other session i check dba_free_space for temp and still it is unused. it is as is..(1.5gb).. so where is it using temp ts and when??
Any inputs ??
thx
-
When indexes are created sorts are needed so temporary tablespace would be used
-
Import with index=n ,buffer=the max possible,
create the indexes by using the indexfile option.
use alter session set sort_area_size= the max possible.
create the temp tablespace with intial and next big sizes.
run the index file ...
everything will be fast.
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|